C2090-611

C2090-611 practice questions, page 3 of 5, with answer review and explanations.

Question 11

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

  1. Self-tuning is occurring only on the instance memory area.
  2. The memory tuner is actively tuning the memory on the system.
  3. Self-tuning is not occurring because it is waiting for the database to be recycled.
  4. Self-tuning is not occurring because there are less than two memory consumers enabled.

Question 12

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

  1. Set
  2. Tree
  3. Group
  4. Range
  5. Hierarchy

Question 13

Where are column mask definitions stored?

  1. In the table definition
  2. In the system catalog
  3. In the table space metadata
  4. In the database configuration file

Question 14

Which statement is correct when describing trusted contexts?

  1. A trusted context defines a trust relationship for a connection between the database and an external entity.
  2. A trusted context promotes the authorization level of the connection initiator and grants them DBADM authority.
  3. A trusted context defines a trust relationship between a user and a table allowing that user additional capabilities.
  4. A trusted context gives the database connection the ability to bypass auditing since authentication has already occurred.

Question 15

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?

  1. Associate the SEC_POLICY security policy with the SALES table.
  2. Add a column with the DB2SECURITYLABEL data type to the SALES table.
  3. Add a column with the DB2SECURITYLABEL data type to the SALES table and then associate the SEC_POLICY security policy with the table.
  4. Add a SECURED WITH clause to every column in the SALES table and then associate the SEC_POLICY security policy with the SALES table.