最新的IBM Assessment: DB2 9.7 DBA for Linux UNIX and Windows - A2090-541免費考試真題

A. SYSMON authority level

B. SYSPERF authority level

C. SYSADM authority level

D. SYSCTRL authority level

E. SECADM authority level

A. When the DB2_AUTO_REBIND registry variable is set to YES.

B. When the DB2_AUTO_REBIND configuration parameter is set to ENABLED

C. When invalid packages are executed.

D. When inoperative packages are executed.

A. db2fodc

B. db2top

C. db2dart

D. db2pm

A. EXPORT TO combined.ixf OF IXF SELECT * FROMtable_a, table_b

B. EXPORT TO combined.ixf OF IXF SELECT * FROM table a INTERSECT SELECT * FROM table b

C. EXPORT TO combined.ixf OF IXF SELECT * FROMtable_a: EXPORT APPEND TO combined.ixf OF IXF SELECT * FROM table_b;

D. EXPORT TO combined.ixf OF IXF SELECT * FROMtable_a UNION ALL SELECT * FROM table_b

A. 30%

B. 50%

C. 40%

D. 60%

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.

A. Solaris

B. AIX

C. Windows

D. Linux