IBM DB2 9.7 DBA for Linux UNIX and Windows Sample Questions:

1. If a non-recoverable database crashes, how can a DBA successfully restart the database if a table space is damaged and cannot complete crash recovery?

A) The damaged table space will require that the entire database be restored from the latest backup image because the database is non-recoverable and will not be accessible.
B) The database must be restarted using the RESTART DATABASE command with the DROP PENDING TABLESPACES option specified. At that point, the database can be brought on-line and the damaged table space must be dropped and re-created.
C) The damaged table space must be restored from the latest backup and any active transaction logs in the log path can then be applied to it using the TABLESPACE ONLINE option of the ROLLFORWARD DATABASE command. This will bring the table space on-line and synchronize it with the rest of the database.
D) The damaged table space must be restored from the latest backup image. Once restored from the backup image, the RESTART DATABASE command can be issued to apply all the relevant transactions from the active logs. At that point, the database will come on-line and all table spaces will be synchronized.

2. Which two plug-in types does the DB2 database system provide? (Choose two.)

A) Server authentication
B) Kerberos authentication
C) Encryption authentication
D) Group retrieval

3. Which statement is correct about informational constraints?

A) An informational constraint can be used by the SQL compiler to improve the access to data and query performance.
B) An informational constraint is a column or combination of columns that has the same properties as a unique constraint.
C) An informational constraint specifies that every row that is inserted or updated in the table must conform to the definition of the table.
D) The database manager uses an informational constraint to enforce the uniqueness of the key during changes to the columns of the unique constraint.

4. What correctly describes an MDC table rollout cleanup for qualifying DELETE statements after the statement shown below is run?
SET CURRENT MDC ROLLOUT MODE IMMEDIATE

A) MDC rollout optimization is used. The RID indexes are updated immediately during the delete process. The deleted blocks are available for reuse after an online REORG with the new RECLAIM EXTENTS clause.
B) MDC rollout optimization is used. The RID indexes are updated immediately during the delete process. The deleted blocks are available for reuse after the transaction commits.
C) MDC rollout optimization is not used. The DELETE statement is processed in the same way as a DELETE statement that does not qualify for rollout.
D) MDC rollout optimization is not used. The RID indexes are updated immediately during the delete process. The deleted blocks are available for reuse after the transaction commits.

5. Click the Exhibit button.

Refer to the exhibit for information on how tables TABA and TABB were created. What would be the number of extents allocated for each table after the successful creation of both tables?

A) TABA: 4 extents TABB: 40 extents
B) TABA: 1 extent TABB: 10 extents
C) TABA: 1 extent TABB: 1 extent
D) TABA: 2 extents TABB: 20 extents

Solutions: