Chapter 11


1.

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

a role can be used to group system and object privileges and assign them as a unit to database users.

2.

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

the with grant option clause allows the grantee to pass on the privilege to another database user.

3.

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

 drop user and create session are examples of system privileges.

4.

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

the table sys.aud$ contains all audit records.

5.

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

the following sql statement will create audit records when update statements fail against the hr.employees table: audit update on hr.employees whenever not successful;

6.

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

the create session 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?

a quota 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?

the system tablespace is assigned to a user for permanent objects if no tablespace is explicitly assigned in the create user statement.

9.

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

 delete , insert , and execute are examples of object privileges.

10.

A profile controls which kinds of database resources?

a profile controls things such as concurrent connections to the database, cpu time used, continuous idle time, disk reads performed, failed login attempts, how often a password needs to be changed, and elapsed time connected.

11.

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

the public keyword can be used instead of an individual username or role in a grant command to assign one or more privileges to every user in the database.

Answers

1.

A role can be used to group system and object privileges and assign them as a unit to database users.

2.

The WITH GRANT OPTION clause allows the grantee to pass on the privilege to another database user.

3.

DROP USER and CREATE SESSION are examples of system privileges.

4.

The table SYS.AUD$ contains all audit records.

5.

The following SQL statement will create audit records when UPDATE statements fail against the HR.EMPLOYEES table:

audit update on hr.employees whenever not successful;

6.

The CREATE SESSION system privilege allows a user to make a connection to the database.

7.

A quota must be assigned to a user before that user can create objects in the tablespace.

8.

The SYSTEM tablespace is assigned to a user for permanent objects if no tablespace is explicitly assigned in the CREATE USER statement.

9.

DELETE, INSERT, and EXECUTE are examples of object privileges.

10.

A profile controls things such as concurrent connections to the database, CPU time used, continuous idle time, disk reads performed, failed login attempts, how often a password needs to be changed, and elapsed time connected.

11.

The PUBLIC keyword can be used instead of an individual username or role in a GRANT command to assign one or more privileges to every user in the database.




Oracle9i DBA JumpStart
Oracle9i DBA JumpStart
ISBN: 0782141897
EAN: 2147483647
Year: 2006
Pages: 138
Authors: Bob Bryla

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net