11.5. Review Questions

  1. Privileges can be grouped and assigned as a unit by using what database object?

  2. When granting privileges with the GRANT statement, what does the clause WITH GRANT OPTION do?

  3. DROP USER and CREATE SESSION are examples of what kind of privileges?

  4. What is the name of the table, owned by the user SYS, that contains all audit records?

  5. Write a SQL statement that will create audit records when UPDATE statements fail against the HR.EMPLOYEES table.

  6. Which system privilege allows a user to make a connection to the database?

  7. In addition to assigning a default tablespace to a user, what else must be assigned to a user before that user can create objects in the tablespace?

  8. Which tablespace is assigned to a user for the user's permanent objects if one is not explicitly assigned in the CREATE USER statement?

  9. DELETE, INSERT, and EXECUTE are examples of what kind of privileges?

  10. A profile controls which kinds of database resources?

  11. Which keyword can be used in a GRANT command to assign one or more privileges to every user in the database?

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

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