Exam 12: Security Management

The advantage of global users is that they do not require Oracle users that have been created within the database.

The creator of a role or the DBA can adjust the default roles for a user using the ____________________ command.

You can use the ____ data dictionary view to view user profile,expiration date of password,and account status.

You need DBA privileges to recover a user password from the database.

When a new database instance is created,the SYS and ____________________ users are created.

Dropping a role revokes it from all users and roles,except those who are currently logged on and have the role enabled.

You can find out what your current password settings are by running the following query: SELECT * FROM _________________________;

The ____ predefined role provides extensive abilities to create objects,such as procedures,triggers,and object types,for users who need to create their own objects.

The ____________________ profile is a predefined user profile created just after the database is created.

As a DBA,what can you do if the user STUDENTA forgets his / her password?

The predefined user,____________________,has already been given the privileges needed for DBA activities.

To drop a user named TREVOR,who owns no tables or other database objects,type the following command: ____.

The password and ____ are the only password properties that you can change specifically for a user by using the ALTER USER command.

A user name must be no more than ____ characters long.

When a new database instance is created,at least three users are created.

When a role switches to requiring a password,users currently logged on who are granted the role are unaffected until they log off and back on again.

A(n)____ is a collection of settings that limits the use of system resources and the database.

The SYSTEM user can perform the highest-level tasks,such as starting up and shutting down a database instance,as well as performing backup and recovery tasks.

Locking a user with the ____ clause (of the CREATE USER or ALTER USER commands)completely locks this user out of the database.

____ are like table aliases,which any user can use in place of the table's name.