최신IBM DB2 9.7 Advanced DBA for LUW - C2090-544무료샘플문제
문제1
Which command CANNOT be used to create the compression dictionary for a table?
Which command CANNOT be used to create the compression dictionary for a table?
정답: C
문제2
What are two authorities and/or privileges required for replaying SQL audit logs? (Choose two.)
What are two authorities and/or privileges required for replaying SQL audit logs? (Choose two.)
정답: C,D
문제3
Given INTRA_PARALLEL is OFF, average row length is 900 bytes, and temporary table cardinality is 1000, which setting would prevent a SORTHEAP overflow when the temporary table is sorted?
Given INTRA_PARALLEL is OFF, average row length is 900 bytes, and temporary table cardinality is 1000, which setting would prevent a SORTHEAP overflow when the temporary table is sorted?
정답: A
문제4
If instance DB2INST1 is created and its authentication type is set to KRB_SERVER_ENCRYPT, which statement is true?
If instance DB2INST1 is created and its authentication type is set to KRB_SERVER_ENCRYPT, which statement is true?
정답: C
문제5
Given an HADR pair configured with HADR_PEER_WINDOW set to 300 seconds. If the standby server looses communication with the primary at 11:02:03 am, when can the following command be run so that the standby server will successfully be promoted to be a primary server?
TAKEOVER HADR ON DB mydb BY FORCE PEER WINDOW ONLY
Given an HADR pair configured with HADR_PEER_WINDOW set to 300 seconds. If the standby server looses communication with the primary at 11:02:03 am, when can the following command be run so that the standby server will successfully be promoted to be a primary server?
TAKEOVER HADR ON DB mydb BY FORCE PEER WINDOW ONLY
정답: C
문제6
Which description is correct when discussing the DB2_MEM_TUNING_RANGE registry variable?
Which description is correct when discussing the DB2_MEM_TUNING_RANGE registry variable?
정답: A
문제7
Which registry variable allows you to limit the size of individual containers for automatic storage table spaces?
Which registry variable allows you to limit the size of individual containers for automatic storage table spaces?
정답: B