Question 1

All available system privileges for the current user can be displayed through the USER_SYS_PRIVS data dictionary view.​

Accepted Answer

The USER_SYS_PRIVS data dictionary view displays all available system privileges for the current user.

Question 2

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

Accepted Answer

ON

Question 3

A user can change his or her current password using the PASSWORD command.

Accepted Answer

The statement is true, a user can change his or her current password using the PASSWORD command.

Question 4

Once a privilege has been granted to a role,it cannot be revoked without re-creating the role.​

Accepted Answer

Privileges can be revoked from a role using the REVOKE command in SQL. It is not necessary to recreate the role.

Question 5

All privileges granted to a role must be revoked before the role can be removed from the database.​

Accepted Answer

Roles can be dropped or removed from the database without explicitly revoking the privileges granted to them; the privileges are automatically revoked when the role is dropped.

Question 6

A user can be assigned a default role that is automatically enabled whenever the user logs in to the database.

Accepted Answer

This is correct. A user can be assigned a default role that is automatically enabled whenever they log in to the database. This default role can be changed or removed as needed.

Question 7

The ALTER USER command can be used to change the name assigned to a user account.​

Accepted Answer

The ALTER USER command is used to change attributes of a user account such as the password, but not to change the name of the user account itself. To change a user's name, you typically have to create a new user with the desired name and transfer the privileges and objects as needed.

Question 8

When a role is removed from the database,users will lose any privileges assigned to them through that role.​

Accepted Answer

When a role is removed, any privileges granted through that role will also be removed, which means users will lose those privileges.

Question 9

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

Accepted Answer

A password can only be assigned to a user, not to a role. Roles are used to group users and assign them a set of permissions, but they do not have their own login credentials.

Question 10

Privileges allow Oracle12c users to execute certain SQL statements._________________________

Accepted Answer

Privileges grant specific permissions to users in Oracle12c, allowing them to execute certain SQL statements.

Question 11

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.​

Accepted Answer

When a privilege is granted with the WITH GRANT OPTION, the recipient of the privilege can grant it to other users. Revoking the privilege from the original recipient will also revoke the privilege from all the users to whom it was granted. This is known as cascading effect.

Question 12

Oracle12c uses a process known as selection to ensure that users are who they say they are._________________________

Accepted Answer

authentication

Question 13

Even if users are authenticated by the operating system,the users are still required to have valid Oracle12c accounts to access the database._________________________

Accepted Answer

Even if the operating system has authenticated the users, they still need valid Oracle12c accounts to access the database.

Question 14

Object privileges allow users to execute DDL commands._________________________

Accepted Answer

System

Question 15

A user can check all his or her currently enabled privileges by examining the SESSION_PRIVS view.

Accepted Answer

This is correct. The SESSION_PRIVS view can be used to check all currently enabled privileges for a user.

Question 16

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

Accepted Answer

PASSWORD EXPIRE

Question 17

The PASS IS clause of the CREATE USER command indicates the password assigned to a user._________________________

Accepted Answer

IDENTIFIED BY

Question 18

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

Accepted Answer

WITH GRANT OPTION

Question 19

The GENERATE ROLE command is used to add a new role to the database._________________________

Accepted Answer

CREATE,CREATE ROLE

Question 20

Use an asterisk in the REVOKE command to revoke all system and object privileges that have been assigned to a user.​

Accepted Answer

In SQL, the REVOKE command does not use an asterisk (*) to revoke all system and object privileges. Privileges must be specified individually or by using specific keywords for groups of privileges.

Quiz 7: User Creation and Management

All available system privileges for the current user can be displayed through the USER_SYS_PRIVS data dictionary view.​

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

A user can change his or her current password using the PASSWORD command.​

Once a privilege has been granted to a role,it cannot be revoked without re-creating the role.​

All privileges granted to a role must be revoked before the role can be removed from the database.​

A user can be assigned a default role that is automatically enabled whenever the user logs in to the database.

The ALTER USER command can be used to change the name assigned to a user account.​

When a role is removed from the database,users will lose any privileges assigned to them through that role.​

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

Privileges allow Oracle12c users to execute certain SQL statements._________________________

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.​

Oracle12c uses a process known as selection to ensure that users are who they say they are._________________________​

Even if users are authenticated by the operating system,the users are still required to have valid Oracle12c accounts to access the database._________________________

Object privileges allow users to execute DDL commands._________________________​

A user can check all his or her currently enabled privileges by examining the SESSION_PRIVS view.

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

The PASS IS clause of the CREATE USER command indicates the password assigned to a user._________________________

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

The GENERATE ROLE command is used to add a new role to the database._________________________​

Use an asterisk in the REVOKE command to revoke all system and object privileges that have been assigned to a user.​

All available system privileges for the current user can be displayed through the USER_SYS_PRIVS data dictionary view.

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

A user can change his or her current password using the PASSWORD command.

Once a privilege has been granted to a role,it cannot be revoked without re-creating the role.

All privileges granted to a role must be revoked before the role can be removed from the database.

The ALTER USER command can be used to change the name assigned to a user account.

When a role is removed from the database,users will lose any privileges assigned to them through that role.

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

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.

Oracle12c uses a process known as selection to ensure that users are who they say they are._________________________

Object privileges allow users to execute DDL commands._________________________

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

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

The GENERATE ROLE command is used to add a new role to the database._________________________

Use an asterisk in the REVOKE command to revoke all system and object privileges that have been assigned to a user.