C2090-614 Online Practice Questions and Answers

Which constraints are used to tell the DB2 Optimizer to consider business rules that are not enforced by the database manager?

A. Check constraints

B. Default constraints

C. Informational constraints

D. Referential integrity constraints

Where is the HADR_TARGET_LIST configuration parameter set?

A. On the primary database only.

B. On all participating databases.

C. On the tertiary standby databases.

D. On the auxiliary standby databases only.

To configure instance-level auditing with db2audit, which authority is required?

A. SYSADM

B. SYSCTRL

C. SECADM

D. SYSMAINT

If the following statements are executed:

CREATE STOGROUP sg_hot ON '/path1', '/path2', '/path3'; CREATE STOGROUP sg_med ON '/path4', '/path5', '/path6'; CREATE TABLESPACE tbsp1 USING STOGROUP sg_hot;

What is the recommended way to move table space TBSP1 from storage group SG_HOT to storage group SG_MED?

A. Issue an ALTER TABLESPACE statement with the 'USING sg_med' option.

B. Issue an ALTER STOGROUP statement with the 'MOVE tbsp1 TO sg_med' option.

C. Perform a table space RESTORE operation with the 'USING STOGROUP sg_hot' option.

D. Use the ADMIN_MOVE_TABLESPACE procedure to move table space TBSP1 to SG_HOT.

Which statement about partitioned indexes is FALSE?

A. Both system- and user-generated indexes can be partitioned.

B. Each index partition contains references only to data in its corresponding data partition.

C. A partitioned index is made up of a set of index partitions, each of which contains the index entries for a single data partition

D. When attaching new partitions, the SET INTEGRITY statement must be run before data in the newly attached partition will be reflected in the corresponding partition index.

A DBA wants to create a table named SALES that has the following characteristics:

Data for the first half of the year will reside in table space TBSP1; the index for this data will reside in table space TBSP21.

Data for the second half of the year will reside in table space TBSP2; the index for this data will reside in table space TBSP22. Which clause must be used with the CREATE TABLE statement to define this table?

A. DISTRIBUTE BY HASH

B. PARTITION BY RANGE

C. ORGANIZE BY DIMENSIONS

D. ORGANIZE BY KEY SEQUENCE

Which command(s) should be used to drop database partition 10 from a database named MYDB?

A. STOP DBM DROP DBPARTITIONNUM 10; DROP DBPARTITIONNUM VERIFY;

B. DROP DBPARTITIONNUM VERIFY; STOP DBM DROP DBPARTITIONNUM 10;

C. CONNECT TO mydb; DROP DBPARTITIONNUM 10; CONNECT RESET;

D. CONNECT TO mydb; DROP DBPARTITIONNUM 10; ACTIVATE DB mydb;

What values can be assigned to the HADR_SYNCMODE configuration parameter?

A. SYNC, NEARSYNC, ASYNC, and NOSYNC

B. SYNC, NOSYNC, ASYNC, and SUPERASYNC

C. SYNC, ASYNC, SEMISYNC, and SUPERASYNC

D. SYNC, NEARSYNC, ASYNC, and SUPERASYNC

With HADR, IBM Tivoli System Automation for Multiplatforms (SA MP) automated failover can be used with which database(s)?

A. The primary database only.

B. The auxiliary standby database only.

C. The principal standby database only.

D. The primary, auxiliary standby, and principal standby database.

In what situation should you use a redirected restore operation?

A. You want to drop a storage group during a restore process.

B. You want to move data from one operating system to another.

C. You want to restore you table spaces into new storage groups.

D. You want to restore your table space containers into a different physical location.