C2090-611 Online Practice Questions and Answers

Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting a "bad page". DB2DART is performed for the entire database and it appears that several bad pages were detected in table space TBSP_1. What command can be used to recover the database and repair the corruption in table space TBSP_1?

A. RESTART DATABASE

B. RECOVER DATABASE

C. RESTORE TABLESPACE

D. ROLLFORWARD DATABASE

What is the correct procedure for recovering a dropped table when DROPPED TABLE RECOVERY has been enabled and the database must remain online?

A. Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore the database and recover the droppedtable.

B. Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore the appropriate table space and recover thedropped table.

C. Restore the database from a backup image that was taken before the table was dropped; run the ROLLFORWARD DATABASE command withthe RECOVER DROPPED TABLE option to restore the

database and recover the dropped table.

D. Restore the appropriate table space from a backup image that was taken before the table was dropped; run the ROLLFORWARD DATABASEcommand with the RECOVER DROPPED TABLE option to restore the appropriate table space and recover the dropped table.

Which statement about BEFORE triggers is FALSE?

A. A BEFORE trigger's action is executed for each row in the set of affected rows before the trigger event executes.

B. A BEFORE trigger's action is executed for each row in the set of affected rows instead of executing the trigger event.

C. A BEFORE trigger is used to perform validation of input data and to automatically generate values for newly inserted rows.

D. A BEFORE trigger cannot be used to modify data in a database because they are activated before the trigger event is applied to the database.

Which command is used to export connectivity configuration information from a file known as a configuration profile?

A. db2ca

B. db2cfexp

C. db2cfimp

D. db2cfgexp

How is the time that an agent waits for log records to be flushed to disk calculated?

A. LOG_END_TIME divided by TOTAL_COMMITS

B. LOG_WAIT_TIME divided by TOTAL_COMMITS

C. LOG_WRITE_TIME divided by TOTAL_COMMITS

D. LOG_FLUSH_TIME divided by TOTAL_COMMITS

Which statement about insert time clustering tables (ITC) is true?

A. ITC tables cannot be range-partitioned tables.

B. ITC tables are supported in DB2 pureScale environments.

C. Rows of an ITC table are clustered by the time they are inserted into the table.

D. If an ITC table is clustered by one or more user specified dimensions, the specified dimensions must be timestamps.

What authority is required to grant a user ACCESSCTRL authority?

A. DBADM

B. SQLADM

C. SECADM

D. DATAACCESS

What authority must be held to create a trusted context?

A. DBADM

B. SQLADM

C. SECADM

D. CONNECT

Which statement about referential constraints is true?

A. A referential constraint can be defined against a catalog table.

B. A referential constraint can be defined on both tables and views.

C. A referential constraint is used to enforce a logical rule about values of one or more columns in one or more tables.

D. A referential constraint is used to enforce a logical rule about how values in one or more columns in a table should be referenced in a query.

Given the following command: LOAD FROM newrows.del OF DEL INSERT INTO mytab ALLOW READ ACCESS Which statement(s) must be executed before applications can query the newly loaded data?

A. SET INTEGRITY FOR mytab IMMEDIATE CHECKED

B. ALTER TABLE mytab CHECK (COL IS VALIDATED)

C. ALTER TABLE mytab ALLOW READ ACCESS IMMEDIATE CHECKED

D. ALTER TABLE mytab ALLOW READ ACCESS;SET INTEGRITY FOR mytab IMMEDIATE UNCHECKED;