Want to pass your DB2 10.1 DBA for Linux UNIX and Windows C2090-611 exam in the very first attempt? Try Pass2lead! It is equally effective for both starters and IT professionals.
VCE
Which command can be used to restore a corrupted database using only the recovery history file?
A. RESTART DATABASE
B. RECOVER DATABASE
C. RESTORE DATABASE
D. ROLLFORWARD DATABASE
An existing non-automatic storage database named MYDB has been successfully converted to an automatic storage database. What must be done to convert any existing DMS table spaces to automatic storage table spaces?
A. Execute the statement ALTER DATABASE mydb CONVERT TO AUTOMATIC STORAGE IMMEDIATE.
B. Execute the statement ALTER DATABASE mydb CONVERT TABLESPACES TO AUTOMATIC STORAGE.
C. Execute the ALTER TABLESPACE statement with the MANAGED BY STOGROUP clause specified for each DMS table space that is to beconverted.
D. Execute the ALTER TABLESPACE statement with the MANAGED BY AUTOMATIC STORAGE clause specified for each DMS table space that isto be converted.
Which command will enable automatic reorg on a database?
A. UPDATE DB CFG USING AUTO_REORG ON
B. UPDATE DB CFG USING AUTO_MAINT ON AUTO_REORG ON
C. UPDATE DB CFG USING AUTO_TBL_MAINT ON AUTO_REORG ON
D. UPDATE DB CFG USING AUTO_MAINT ON AUTO_TBL_MAINT ON AUTO_REORG ON