Exam 7: User Creation and Management

A role can be created with the CREATE ROLE command.​

The FOR clause of the GRANT command is used to specify the object to which the privilege applies._________________________​

The REVOKE command can be used to revoke system and object privileges,but not both in the same command._________________________​

All available ____________________ privileges in Oracle12c can be displayed through the SYSTEM_PRIVILEGE_MAP data dictionary view.

When revoking an object privilege that was issued with the WITH GRANT OPTION,the action will have a cascading effect because if that user granted the privilege to other users,the privilege will be revoked from them also.​

Which of the following SQL statements will revoke the DBA role from user RTHOMAS?​

The ____________________ command is used to grant roles to users.

A role can be removed from the database with the DELETE ROLE command._________________________​

When revoking a privilege that was issued with the WITH ADMIN OPTION,the action will have a cascading effect because if that user granted the privilege to other users,the privilege will be revoked from them also._________________________​

If a user is granted system and object privileges,then subsequently grants those privileges to other users,what happens to the recipients if all of the original user's privileges are revoked?​

Which command will remove an existing role from a database?​

The WITH ADMIN OPTION is required to enable the user to grant the specified object privileges to other users._________________________​

A password cannot be assigned to a role,only to a user.​

____________________ privileges allow users to execute specific DML commands.​

The INSERT,UPDATE,and DELETE object privileges can be applied to tables and views.

A(n)____________________ privilege cannot be granted to a role with the WITH GRANT OPTION.

A role can only be granted to other roles.​

The ____________________ command is used to remove a user account from the Oracle12c database.

The CHANGE PASSWORD option can be used to force a user to change the user password at the time of the next login._________________________​

Revoking a privilege that was issued with the WITH ____________________ OPTION will cause any subsequent recipients to have their privilege revoked also.