Practice exam questions

The following practice exam questions test your knowledge of material that this chapter covers.

1:Which item below correctly identifies, from highest to lowest, the database authorities?
  1. DBADM, DBOPR, DBCTRL

  2. DBADM, DBCTRL, DBMAINT

  3. DBADM, DBMAINT, DBCTRL

  4. DBADM, DBCTRL, DBOPR

2:Which statement is false?
  1. The security and authorization mechanisms that control access to DB2 data are indirect.

  2. Before you issue DB2 commands, you need the appropriate authorization or privilege.

  3. A privilege allows an action on an object.

  4. GRANT and REVOKE statements provide access control for DB2 objects.

3:DB2 IDs can hold privileges that allow them to take certain actions or be prohibited from doing so. Which type of privilege is not valid?
  1. Related privileges, ...

Get Official Introduction to DB2® for z/OS®, The, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.