IBM DB2 9.X Test

This test is available in both the Average Skill level and the Advanced Skill level. The Average Skill level test will have at least 25 questions and will take approximately 30 minutes to complete. The Advanced Skill level test will have at least 40 questions and will take approximately 45 to 60 minutes to complete. These tests may also be combined with other tests to present a Combined Test of any length.

These are Multiple Choice type tests with at least four possible answers, only one of which is correct. We constantly change, revise and upgrade our test and really value your opinion. Please send us any suggestions or additions so that we may consider them.

Among the areas covered by this test are the following:

  • Controlling database access,
  • Authorities and privileges,
  • Granting Authorities and privileges,
  • Servers, instances, and databases,
  • Working with XML data,
  • DB2 9.7 data type
  • and much more

We have included a sample question below to give you the style and essence of the test To take a demo of our tests please click the Try a Test Demo button above.

Which one of the following modes is used with the LOCK TABLE statement will cause the DB2 Database Manager to acquire a table-level lock. The table-level lock prevents other concurrency transactions from accessing data stored in the table while the owning transaction is active?

1)      RESTRICT

2)      ISOLATED

3)      SHARE

4)       EXCLUSIVE