C2090-611

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

Question 16

Which authorities can be audited with the AUDIT statement?

  1. SECADM, DBADM, SYSMAINT, and SYSCTRL can be audited, but SYSADM cannot.
  2. SYSADM, DBADM, SYSMAINT, and SYSCTRL can be audited, but SECADM cannot.
  3. SYSADM, SECADM, DBADM, SQLADM, ACCESSCTRL, and DATAACCESS can be audited.
  4. DBADM, SYSMAINT, ACCESSCTRL, and DATAACCESS can be audited, but SYSADM and SECADM cannot.

Question 17

Which authority is required to revoke SECADM authority?

  1. DBADM
  2. SECADM
  3. SYSADM
  4. SQLADM

Question 18

Which statement regarding SECADM authority is true?

  1. The instance owner has SECADM authority by default.
  2. PUBLIC cannot receive SECADM authority, either directly or indirectly.
  3. Only users with SECADM authority are allowed to grant the CONNECT database authority to others.
  4. The SECADM_GROUP database manager configuration parameter determines who has SECADM authority by default.

Question 19

What authorization is needed to execute the CREATE MASK statement?

  1. SECADM
  2. SQLADM
  3. SYSADM
  4. SYSCTRL

Question 20

Which statement is correct for a user who holds SECADM authority?

  1. A user who holds SECADM authority can only grant and revoke database object privileges.
  2. A user who holds SECADM authority can grant and revoke all database level authorities and database object privileges.
  3. A user who holds SECADM authority can only grant and revoke DBADM and SECADM database level authorities.
  4. A user who holds SECADM authority can only grant and revoke label based access control (LBAC) security labels.