IBM C2090-600 Free Practice Exam & Test Training

Question 1

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

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

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

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

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.