logo

IBM C2090-600 - IBM DB2 11.1 DBA for LUW Exam

Download Exam View Entire Exam Collapse/Expand All Expose All Answers
Page: 1 / 13
Total 60 questions
Question #1 (Topic: )
Which statement regarding event monitors is TRUE?
A. Event monitor data can be reviewed while the event monitor is active B. Event monitors must always be started manually after activating a database C. Event monitors must write data to .EVT files before the data can be loaded into database tables D. Event monitors are used to obtain information about how a database system looks at a specific point in time
Answer: B
Question #2 (Topic: )
If the following SQL statements are executed:
CREATE DATABASE testdb AUTOMATIC STORAGE NO;
CONNECT TO testdb;
CREATE STOGROUP sg1 ON /data1;
CREATE STOGROUP ibmstogroup ON /data2;
CREATE STOGROUP sg2 ON /data3;
Which storage group is the default storage group for the TESTDB database?
A. SG1 B. SG2 C. IBMSTOGROUP D. IBMDEFAULTTSG
Answer: C
Question #3 (Topic: )
Which of the following enables the user to connect to the HADR standby database and
execute select statements?
A. DB2_HADR_ROS B. HADR_SPOOL_LIMIT C. DB2_HADR_SOSNDBUF D. DB2_HADR_PEER_WAIT_LIMIT
Answer: A
Question #4 (Topic: )
What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple
steps?
A. It does not acquire locks on the table B. It does not require additional temporary disk space C. It enables the user to control when the table will be offline D. It allows the ADMIN_MOVE_TABLE procedure to be used in HADR environments
Answer: D
Question #5 (Topic: )
Which statement about the DB2_BCKP_COMPRESSION registry variable is TRUE?
A. It does not apply to table space backups. B. It specifies the compression mode to use for DB2 backups. C. It only has effect when appliedto a database in which all tables have been compressed. D. If set, backup images created with the BACKUP command are automatically compressed.
Answer: D
Download Exam
Page: 1 / 13
Total 60 questions