IBM Assessment: DB2 9.7 DBA for Linux UNIX and Windows 認定 A2090-541 試験問題:

1. Which two operations allow you to control the creation of the compression dictionary using the KEEPDICTIONARY/RESETDICTIONARY options? (Choose two.)

A) IMPORT
B) TRUNCATE
C) REORG
D) LOAD

2. Due to an application error, some data was deleted from a very large table residing in table space TS1. The table space was then renamed TS2 before the error was detected. Rather than try and rebuild this table, it was decided that database DB1 would be restored and then rolled forward to a point-in-time (PIT) before the delete operation took place. Unfortunately the PiT roll forward was done to a time that was too early and some critical transactions were missing when the database was brought back on-line. Which steps must be taken to ensure that the critical transactions which are currently missing from the database are correctly applied to the database and that table space TS1 is renamed TS2?

A) 1. Restore database DB1.
2.Roll forward to the correct point-in-time.
3.Rename TS1 to TS2.
B) 1. Restore table space TS1 from the DB1 backup image.
2.Roll forward to the correct point-in-time.
3.Rename table space TS1 to TS2.
4.Re-run the batch processes.
C) 1, Restore database DB1
2. Roll forward to end of logs.
D) 1. Restore table space TS1 from the DB1 backup image.
2. Roll forward to end of logs.

3. For which two events is it recommended to execute RUNSTATS? (Choose two.)

A) When a table is created.
B) When LOAD with STATISTICS has been run.
C) When row compression has been enabled.
D) When a table is altered by adding new columns.

4. Because of an application abend, a database named PAYROLL needs to be restored to approximately 9:26 am on June 1, 2009. After the database is restored from a backup image, the command shown below is executed: ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING LOCAL TIME AND STOP
When this command is executed, the error shown below is generated:
SQL4970N Roll-forward recovery on database "PAYROLL" cannot reach the specified stop point (end-of-log or point-in-time) because of missing log file(s) on node(s) "0".
Which two commands could be used to resolve this error? (Choose two.)

A) ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING UTC TIME AND STOP
B) ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING UTC TIME AND STOP NORETRIEVE MISSING RECORDS
C) ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING LOCAL TIME AND STOP OVERFLOW LOG PATH /mnt/arclog
D) ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOP

5. A file named db2advise.in contains the text shown below:
--#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT * FROM employee WHERE lastname='HAAS';
What does the line -#SET FREQUENCY 100 convey when this file is used as input for the Design
Advisor?

A) Executes both SQL statements in the workload file 100 times.
B) Executes up to 100 combinations of optimizations for both SQL statements in the workload file
C) Executes the first SOL statement in the workload file 100 times.
D) Executes an index analysis for the first SQL statement in the workload file 100 times.

質問と回答：