IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows Sample Questions:

1. A storage group named HOT_SG was created as follows:

What does the DATA TAG 1 clause do?

A) It indicates that the value 1 is to be assigned to data stored in the HOT_SG storage group, which Workload Manager (WLM) can then use to determine the processing priority to assign to database activities that interact with this data.
B) It indicates that the multiple storage paths referenced in the HOT_SG storage group definition exist in one physical location.
C) It assigns a unique identifier to the instance of the HOT_SG storage group being defined; this identifier can then be used when moving table spaces to and from the storage group, when dropping the storage group, or when commenting on the storage group.
D) It tells the DB2 Optimizer that database objects stored in the HOT_SG storage group are to be given preference over other objects when data access plans are generated.

2. The following query is executed frequently against the SALES table: SELECT sales_person, region FROM sales WHERE region = 'Quebec' Which statement will create an index for optimal query performance?

A) CREATE INDEX sales_idx ON sales (sales_person)
B) CREATE INDEX sales_idx ON sales (region)
C) CREATE INDEX sales_idx ON sales (region, sales_person)
D) CREATE INDEX sales_idx ON sales (region) INCLUDE (sales_person)

3. Prior to migrating to DB2 10.1, a DBA executed the following command on a daily basis: db2_all "<<-1< db2 BACKUP DATABASE sales TO /mnt/backup" Which command can now be used to perform the same backup operation?

A) BACKUP DATABASE sales ON ALL DBPARTITIONNUMS TO /mnt/backup
B) BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT DBPARTITIONNUM (1) TO /mnt/backup
C) BACKUP DATABASE sales ON DBPARTITIONNUM (1) TO /mnt/backup
D) BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT CATPARTITION TO /mnt/backup

4. A DBA wants to create a table named SALES that has the following characteristics:
- Data for the first half of the year will reside in table space TBSP1; the index for this data will reside in table space TBSP21. - Data for the second half of the year will reside in table space TBSP2; the index for this data will reside in table space TBSP22.
Which clause must be used with the CREATE TABLE statement to define this table?

A) DISTRIBUTE BY HASH
B) ORGANIZE BY KEY SEQUENCE
C) ORGANIZE BY DIMENSIONS
D) PARTITION BY RANGE

5. The following message is frequently seen in the DB2 Diagnostics Log file (db2diag.log): MESSAGE : ADM5502W The escalation of "28581" locks on table "TEST.TABLE1" to lock intent "X" was successful. Which two database configuration parameter settings should be checked? (Choose two.)

A) MAXAPPLS
B) MAXLOCKS
C) LOCKLIST
D) LOCKTIMEOUT
E) MAXAGENTS

Solutions: