IBM IBM Certified Database Administrator C2090-612 Questions & Answers

• Question 41:

  DB2 10 is in enabling-new-function mode* after migrating from Version 8, which statement is correct?

  A. The DB2 subsystem was at some point in in NFM.

  B. The DB2 subsystem can still fall back to DB2 Version 8.

  C. Coexistence is allowed with a DB2 9 data sharing group member.

  D. The asterisk (*) indicates objects created in NFM can no longer be accessed.

  Correct Answer: A

• Question 42:

  Which DSNZPARM parameter controls the number of locks that may be acquired on a table space?

  A. NUMLKUS

  B. MAXUSRS

  C. NUMLKTS

  D. MXDTCACH

  Correct Answer: C

• Question 43:

  If security administration is separated from system and database administration, via zparm, which level of authority is required to define roles or trusted contexts?

  A. SYSADM

  B. DBADM

  C. SECADM

  D. INSTALL SYSOPR

  Correct Answer: C

• Question 44:

  Which minimum system privilege allows you to create a trusted context?

  A. DBADM

  B. SECADM

  C. SYSCTRL

  D. ACCESSCTRL

  Correct Answer: B

• Question 45:

  What must be done in order to audit read access to a table?

  A. AUDIT ALL must be set on the table and an audit trace must be started.

  B. An EDITPROC must be defined on the table and an audit trace must be started.

  C. DATA CAPTURE CHANGES must be set on the table and the DB2 log must be captured.

  D. A security label column should be defined on the table within a trusted context.

  Correct Answer: A

• Question 46:

  Which privilege allows the execution of the EXPLAIN STMTCACHE ALL SQL statement?

  A. SYSOPR

  B. SYSCTRL

  C. SQLADM

  D. SECADM

  Correct Answer: C

• Question 47:

  Which of the following techniques CANNOT be used to implement DB2 based row level authorization in a read-only environment for a specific table?

  A. Using a view.

  B. Using a VALIDPROC.

  C. Using multi-level security.

  D. Using masks and permissions.

  Correct Answer: B

• Question 48:

  You have been asked to find packages that use isolation level UR in dynamic SQL. Which trace will be utilized?

  A. Audit trace class(4)

  B. Monitor trace class(6)

  C. Performance trace class(3)

  D. Accounting trace class(1,2,3,7,8)

  Correct Answer: C

• Question 49:

  The access path chosen for a query shows a table space scan, when it appears that there is an index available that would provide a more efficient access path. What situation could have caused a table space scan to be chosen instead of the index?

  A. Index is created with PCTFREE of zero.

  B. The number of columns in the index is less than four.

  C. RUNSTATS were run when there were no rows in the table.

  D. RUNSTATS were run when there was a million rows in the table.

  Correct Answer: C

• Question 50:

  What is the maximum levels of backup that DB2 plan stability can support?

  A. 1

  B. 2

  C. 3

  D. 4

  Correct Answer: C