IBM C2090-611 Online Practice Questions and Exam Preparation

IBM C2090-611 Online Questions & Answers

• Question 1:

  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.
  B. PUBLIC cannot receive SECADM authority, either directly or indirectly.

• Question 2:

  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
  C. LOG_WRITE_TIME divided by TOTAL_COMMITS

• Question 3:

  What unit of measurement is used to represent the cumulative total cost of a node in a Visual Explain access plan diagram?

  A. CPU cycles
  B. Elapsed time, in milliseconds
  C. Processing instructions performed
  D. Timerons
  D. Timerons

• Question 4:

  When the ALTER TABLE DETACH operation is used to detach a single data partition from a partitioned table, at what point does the newly detached data partition become accessible as a standalone table?

  A. After a SET INTEGRITY statement is executed.
  B. After a truncate table operation is performed in the background.
  C. Immediately after the ALTER TABLE DETACH statement is executed.
  D. Immediately after asynchronous partition detach processing completes for this data partition.
  D. Immediately after asynchronous partition detach processing completes for this data partition.

• Question 5:

  What is the purpose of the Design Advisor?

  A. To recommend physical changes to objects in a database.
  B. To recommend database configuration parameter changes.
  C. To generate profiles for autonomic activity within the database.
  D. To generate query definitions required to create usage reports.
  A. To recommend physical changes to objects in a database.

• Question 6:

  If you are running DB2 in clustered environment, what utility should you use to get the status of cluster?

  A. db2istat
  B. db2clust
  C. db2haicu
  D. db2hastat
  C. db2haicu

• Question 7:

  If a single node database is actively being used by applications when a power failure occurs, what method is used to bring the database back to a consistent state once power has been restored?

  A. Crash recovery
  B. Version recovery
  C. Disaster recovery
  D. Roll-forward recovery
  A. Crash recovery

• Question 8:

  What authority is required to grant a user ACCESSCTRL authority?

  A. DBADM
  B. SQLADM
  C. SECADM
  D. DATAACCESS
  C. SECADM

• Question 9:

  A partitioned table named SALES was created as follows: Which statement about the PARTS_IDX index is true?

  

  A. The index PARTS_IDX will be a nonpartitioned index and it will be stored in table space TBSP3.
  B. The index PARTS_IDX will be a nonpartitioned index and it will be stored in table space TBSP0.
  C. The index PARTS_IDX will contain 3 partitions and all three partitions will be stored in table space TBSP3.
  D. The index PARTS_IDX will contain 3 partitions; the first partition will be stored in table space TBSP0, the second in TBSP1, and the third inTBSP2.
  D. The index PARTS_IDX will contain 3 partitions; the first partition will be stored in table space TBSP0, the second in TBSP1, and the third inTBSP2.

• Question 10:

  Which registry variable is used to enable transparent Lightweight Directory Access Protocol (LDAP)?

  A. DB2LDAP
  B. DB2AUTH
  C. CLNT_PW_PLUGIN
  D. SRVCON_PW_PLUGIN
  B. DB2AUTH