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, called administrative authorities

  2. Object privileges

  3. Operating system privileges

  4. Application plan and package privileges

4:Explicit privileges provide very detailed control on certain DB2 objects. Which item below identifies an object for which no explicit privilege can be granted?

  1. JARs

  2. Schemas

  3. Distinct types

  4. Indexes

5:You can use the GRANT statement to do all of the following things except which one?

  1. To grant privileges to a single ID

  2. To grant a specific privilege on one object in a single statement

  3. To grant ALL for all the privileges of accessing a single table

  4. To grant GLOBAL to give all privileges on a table to all users

6:Which item below is not a type of authorization ID for DB2 UDB for z/OS?

  1. Primary authorization ID

  2. Secondary authorization ID

  3. CURRENT SQLID

  4. DB2USER ID

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.16.48.181