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

Which statement about the initiation of parallel I/O is correct?

A. For list prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.

B. For read-ahead prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.

C. For sequential prefetching, parallel I/O is initiated when the prefetch size is a multiple of the extent size for a table space. Each prefetch request is divided into smaller requests and assigned to different I/O servers.

D. For sequential prefetching, parallel I/O is initiated when the extent size is a multiple of the prefetch size for a table space. Each prefetch request is divided into smaller requests and assigned to different I/O servers.

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.

Which statement about dropped table recovery is correct?

A. Multiple dropped tables can be recovered with a single table space-level restore operation.

B. By default, the DROPPED TABLE RECOVERY option is off when a new table space is created.

C. The dropped table recovery feature lets you recover only dropped table data with a database- level restore operation.

D. For a dropped table to be recoverable, the table space in which the table resides must have the DROPPED TABLE RECOVERY option turned on.

On which two operating systems can DB2 pureScale run? (Choose two.)

A. AIX

B. Linux

C. HP-UX

D. Solaris

E. Windows

What must be done to convert an existing table into an Insert-Time-Clustered (ITC) table?

A. Call the ADMIN_MOVE_TABLE procedure.

B. Call the ADMIN_REVALIDATE_DB_OBJECTS procedure.

C. Issue a REORG TABLE statement with the ORGANIZE BY INSERT TIME option.

D. Issue an ALTER TABLE statement with the ORGANIZE BY INSERT TIME option.

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 statement about Range Clustered Tables (RCT) is correct?

A. Storage space is not pre-allocated for an RCT.

B. The ALTER TABLE statement can be used to change the physical structure of an RCT.

C. When defining a range of key values for an RCT, a minimum value is optional.

D. The minimum value of a key column for an RCT cannot be a negative value.

Which command will be executed successfully on every database partition if db2_all is used?

A. CONNECT

B. FORCE APPLICATION

C. RESTART DATABASE

D. ACTIVATE DATABASE

What can be done to prevent applications from failing when DB2 cannot create a new log file?

A. Set MAX_LOG to 0

B. Set LOGBUFSZ to -1

C. Set LOGSECOND to -1

D. Set BLK_LOG_DSK_FUL to YES