We're so confident of our products that we provide no hassle product exchange.
IBM DB2 9.7 DBA for Linux UNIX and Windows Sample Questions:
1. Which three table features can be used concurrently in the same table? (Choose three.)
A) local indexes
B) primary key index
C) partitioned tables
D) MDC tables
E) range-clustered tables
2. Given a table that is already compressed, if you create a new index on that table, when will the index be compressed?
A) after running the ALTER INDEX... COMPRESS command and the REORG command
B) after running the REORG command against the table and index
C) after running the ALTER INDEX... COMPRESS command
D) immediately after running the CREATE INDEX command
3. A database administrator created a new database from an existing full database backup image. If the original database resided on a 64-bit AIX server and the new database was created on a different 64-bit AIX server, which two statements are correct? (Choose two.)
A) Existing SQL procedures must be dropped and re-created in the new database before they can be used
B) Incremental backup images for the original database can be used to restore the new database.
C) Existing packages will be copied to the new database and can be used immediately.
D) Incremental backups are not allowed until a non-incremental backup is taken.
4. What are three implementations for DB2 Workload Management? (Choose three.)
A) alert
B) snapshot
C) service class
D) threshold
E) workload
5. Which HADR feature minimizes the impact of software maintenance on the Standby server?
A) Configure AUTOMATIC maintenance and perform a roll forward.
B) Configure AUTOMATIC maintenance and perform a rolling upgrade
C) Configure all AUTOMATIC maintenance parameters.
D) Configure all AUTOMATIC features.
Solutions:
| Question # 1 Answer: A,C,D | Question # 2 Answer: D | Question # 3 Answer: A,D | Question # 4 Answer: C,D,E | Question # 5 Answer: B |
By Jerome
