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

Which command will define the alternate diagnostic data directory path as /db2data/db2dump2?

A. db2set ALT_DIAGPATH=/db2data/db2dump2

B. db2set SECONDARY_DIAGPATH=/db2data/db2dump2

C. UPDATE DBM CFG USING ALT_DIAGPATH /db2data/db2dump2

D. UPDATE DBM CFG USING SECONDARY_DIAGPATH /db2data/db2dump2

Which statement regarding SECADM authority is true?

A. The instance owner has SECADM authority by default.

B. PUBLIC cannot receive SECADM authority, either directly or indirectly.

C. Only users with SECADM authority are allowed to grant the CONNECT database authority to others.

D. The SECADM_GROUP database manager configuration parameter determines who has SECADM authority by default.

Which statements will enable automatic storage in storage group SG_HOT for a given database managed table space MY_TS and remove all existing non-automatic storage containers from the table space?

A. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE;ALTER TABLESPACE my_ts REBALANCE;

B. ALTER TABLEPACE my_ts MANAGED BY DATABASE;ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE;ALTER TABLESPACE my_ts REBALANCE;

C. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE USE STOGROUP sg_hot;ALTER STOGROUP sg_hot DROP '/db2/filesystem1', '/db2/filesystem2';ALTER TABLESPACE my_ts REBALANCE;

D. ALTER TABLESPACE my_ts MANAGED BY DATABASE USE STOGROUP sg_hot;ALTER STOGROUP sg_hot DROP '/db2/filesystem1', '/db2/filesystem2';ALTER TABLESPACE my_ts REBALANCE;

Given a system-period temporal table POLICY_INFO with its associated history table HIST_POLICY_INFO, which statement is true?

A. When querying with a time period specification, only the HIST_POLICY_INFO table is queried.

B. When querying with no time period specification, only the HIST_POLICY_INFO table is queried.

C. When querying with a time period specification, both the POLICY_INFO and HIST_POLICY_INFO tables are potentially queried.

D. When querying with no time period specification, both the POLICY_INFO and HIST_POLICY_INFO tables are potentially queried.

Which statement is true regarding the workload management dispatcher?

A. The workload management dispatcher monitors work performed by entities executing in the DB2 system service class.

B. The workload management dispatcher monitors the allocation of CPU resources between service classes on a system.

C. The workload management dispatcher monitors non-DB2 work performed in fenced mode processes such as fenced stored procedures.

D. The workload management dispatcher monitors work performed by applications or middleware products that perform a portion of their workoutside of the DB2 database manager.

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

What are two types of DB2 Discovery requests that a client can make? (Choose two.)

A. KNOWN

B. SEARCH

C. LOOKUP

D. TRUSTED

E. UNTRUSTED

Which is the suggested way to restore a database with a subset of its original table spaces?

A. Execute the RESTORE DATABASE command with the REBUILD WITH option and specify the set of table spaces that are needed.

B. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES option and specify the set of table spaces that areneeded.

C. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES IN IMAGE option and specify the set of table spacesthat are needed.

D. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES IN DATABASE option and specify the set of tablespaces that are needed.

If the following statement is executed: REORGCHK UPDATE STATISTICS ON TABLE ALL What will happen?

A. RUNSTATS will be executed on all user tables and a REORGCHK report will be generated.

B. RUNSTATS will be executed on all user and system tables and a REORGCHK report will be generated.

C. RUNSTATS will be executed on all user tables only if statistics have not been collected and a REORGCHK report will be generated.

D. RUNSTATS will be executed on all system tables only if statistics have not been collected and a REORGCHK report will be generated.