Index TAB 1X1 was created as shown below:
CREATE INDEX tablxl ON tab1(col_1)
Which modification to index TAB 1X1 can be performed with an ALTER INDEX statement?
A. ALTER INDEXtablxl PCTFREE 40
B. ALTER INDEXtablxl CLUSTER
C. ALTER INDEXtablxl ADD COLUMN (col_2)
D. ALTER INDEXtablxl COMPRESS YES
正解:D
質問 2:
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.
正解:B
質問 3:
What are three implementations for DB2 Workload Management? (Choose three.)
A. service class
B. workload
C. snapshot
D. alert
E. threshold
正解:A,B,E
質問 4:
The event monitor for transactions has been replaced in DB2 9.7 with which tool?
A. db2top
B. MON_GET_WORKLOAD table function
C. MON_GET_ACTIVITY_DETAILS table function
D. db2evmonfmt
正解:B
質問 5:
Which statement is true about unique constraints?
A. There can be multiple unique constraints per table.
B. There can be only one unique constraint key per table
C. A unique constraint is identical to a unique index.
D. A foreign key can only reference a unique constraint.
正解:A
質問 6:
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. Existing packages will be copied to the new database and can be used immediately.
C. Incremental backups are not allowed until a non-incremental backup is taken.
D. Incremental backup images for the original database can be used to restore the new database.
正解:A,C
質問 7:
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 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.
B. 1. Restore table space TS1 from the DB1 backup image.
2. Roll forward to end of logs.
C. 1. Restore database DB1.
2.Roll forward to the correct point-in-time.
3.Rename TS1 to TS2.
D. 1, Restore database DB1
2. Roll forward to end of logs.
正解:C
質問 8:
Click the Exhibit button.
Refer to the GET DB CFG output shown in the exhibit Where can the db2diag.log file be found?
A. /home/db2inst1 Zdb2inst1 /sqllib/db2durnp
B. /local/db/db2inst1 /sqllib/db2dump
C. /local/db/db2inst1 /db2data/db2durnp
D. /home/db2inst1 Zdb2inst1 /db2dump
正解:C
質問 9:
Which two DB2 commands are used to extract, format, and present diagnostic information? (Choose two.)
A. db2xprt
B. db2diag
C. db2dart
D. db2exfmt
正解:B,C
本杉** -
出題確率の高いテーマをコンパクトにまとめ、最小限の対策で合格をめざすA2090-541参考書だぜ