Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?
A. When the registry variable DB2_WORKLOAD=ANALYTICS prior to database creation
B. After termination all the back-end processes using TERMINATE command
C. After setting the database configuration parameter AUTO_DEL_REC_OBJ to ON
D. When the registry variableDB2_AUTORECLAIMSPACE=YES
正解:C
質問 2:
Which options are valid for an online reorganization operation?
A. CLEAN OVERFLOWS and RECLAIM EXTENTS
B. FULL and RECLAIM EXTENTS
C. FULL and CLEANUP OVERFLOWS
D. CLASSIC and RECLAIM EXTENTS
正解:B
質問 3:
Which statement about the DB2_BCKP COMPRESSION registry variable is TRUE?
A. It specifies the compression mode to use for DB2 backups.
B. If set, backup images created with the BACKUP command are automatically compressed.
C. It only has effect when applied to a database in which all tables have been compressed.
D. It does not apply to table space backups.
正解:B
質問 4:
Where does the DB2 Problem Determination tool (db2pd) get information from?
A. the db2diag.log file
B. A set of pre-defined event monitors
C. DB2memory sets
D. Monitoring table functions
正解:C
質問 5:
Which of the following enables the user to connect to the HADR standby database and execute select statements?
A. DB2 - HADR- PEER - WAIT- LIMIT
B. HADR_SPOOL_LIMIT
C. DB2_HADR_SOSNDBUF
D. DB2_HADR_ROS
正解:D
質問 6:
Which command will enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment?
A. UPDATE DB CFG USING LOCKLIST AUTOMATIC MAXLOCKS AUTOMATIC
B. UPDATE DB CFG USING OPT_DIRECT_WRKLD YES
C. UPDATE DB CFG USING LOCKLIST 4096 MAXLOCKS 90
D. UPDATE DB CFG USING CF LOCK_SZ AUTOMATIC
正解:C
いち** -
問題集にてひたすら勉強して、試験中にかなり順調に回答しました。合格できました。今後もお付き合いのほど、よろしくお願いいたします。