C2090-612

C2090-612 practice questions, page 5 of 6, with answer review and explanations.

Question 21

What DB2 command when issued displays what migration mode the catalog is in?

  1. DSNC DISPLAY
  2. DISPLAY GROUP
  3. MODIFY irlmproc,STATUS
  4. DISPLAY DATABASE (DSNDB06)

Question 22

Which authority level allows a user to run utilities that change the data in an application database?

  1. DBCTRL
  2. SYSOPR
  3. DBMAINT
  4. INSTALL SYSOPR

Question 23

Which trace gives information about frequent log space shortages?

  1. Audit trace class(8)
  2. Statistics trace class(3)
  3. Accounting trace class(10)
  4. Performance trace class(4)

Question 24

When creating a stored procedure that will access non DB2 resources using the authorization ID of the user invoking the stored procedure, what value must the SECURITY clause specify?

  1. DB2
  2. RACF
  3. USER
  4. DEFINER

Question 25

Row and column level security can be implemented using mask and permissions. Which two DB2 authorities are able to create a mask or permission? (Choose two.)

  1. SECADM authority.
  2. ACCESSCTRL authority.
  3. DATAACCESS authority.
  4. SYSADM authority when SEPARATE_SECURITY=NO.
  5. The owner of the object as he/she has that authority implicitly.