Databases Reference
In-Depth Information
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 priv-
ileges to every user in the database?
