IBM IBM Certified Advanced Database Administrator C2090-611 Questions & Answers

• Question 101:

  Which authorities can be audited with the AUDIT statement?

  A. SECADM, DBADM, SYSMAINT, and SYSCTRL can be audited, but SYSADM cannot.

  B. SYSADM, DBADM, SYSMAINT, and SYSCTRL can be audited, but SECADM cannot.

  C. SYSADM, SECADM, DBADM, SQLADM, ACCESSCTRL, and DATAACCESS can be audited.

  D. DBADM, SYSMAINT, ACCESSCTRL, and DATAACCESS can be audited, but SYSADM and SECADM cannot.

  Correct Answer: C

• Question 102:

  Which authority is required to revoke SECADM authority?

  A. DBADM

  B. SECADM

  C. SYSADM

  D. SQLADM

  Correct Answer: B

• Question 103:

  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.

  Correct Answer: B

• Question 104:

  A table named SALES was created as follows:

  

  If management wants to use Label-Based Access Control (LBAC) to protect individual rows in the SALES table, and the security policy needed (SEC_POLICY) has already been created, what must be done to protect the table as desired?

  A. Associate the SEC_POLICY security policy with the SALES table.

  B. Add a column with the DB2SECURITYLABEL data type to the SALES table.

  C. Add a column with the DB2SECURITYLABEL data type to the SALES table and then associate the SEC_POLICY security policy with the table.

  D. Add a SECURED WITH clause to every column in the SALES table and then associate the SEC_POLICY security policy with the SALES table.

  Correct Answer: C

• Question 105:

  If the current value for self-tuning memory is: Self Tuning Memory (SELF_TUNING_MEM) = ON (Inactive) Which statement is true?

  A. Self-tuning is occurring only on the instance memory area.

  B. The memory tuner is actively tuning the memory on the system.

  C. Self-tuning is not occurring because it is waiting for the database to be recycled.

  D. Self-tuning is not occurring because there are less than two memory consumers enabled.

  Correct Answer: D

• Question 106:

  What are two types of security label components that can be used with Label-Based Access Control (LBAC)? (Choose two).

  A. Set

  B. Tree

  C. Group

  D. Range

  E. Hierarchy

  Correct Answer: AB

• Question 107:

  Where are column mask definitions stored?

  A. In the table definition

  B. In the system catalog

  C. In the table space metadata

  D. In the database configuration file

  Correct Answer: B

• Question 108:

  Which statement is correct when describing trusted contexts?

  A. A trusted context defines a trust relationship for a connection between the database and an external entity.

  B. A trusted context promotes the authorization level of the connection initiator and grants them DBADM authority.

  C. A trusted context defines a trust relationship between a user and a table allowing that user additional capabilities.

  D. A trusted context gives the database connection the ability to bypass auditing since authentication has already occurred.

  Correct Answer: A

• Question 109:

  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

  Correct Answer: D

• Question 110:

  In IBM Data Studio, where can you schedule script-based jobs?

  A. Job Console

  B. Job Manager

  C. Task Manager

  D. Utilities Console

  Correct Answer: B