Question 1

The $\underline { FOR }$ clause of the GRANT command is used to specify the object to which the privilege applies. _________________________

Accepted Answer

The answer of The $\underline { FOR }$ clause of...

Question 2

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

Question 3

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.

Question 4

Even if users are $\underline { \text { authenticated } }$by the operating system, the users are still required to have valid Oracle11g accounts to access the database. _________________________

Accepted Answer

Authentication by the operating system is separate from access to the database, which requires a valid Oracle11g account.

Question 5

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

Revoking a privilege with the WITH GRANT OPTION from a user will also revoke the same privilege from all the users to whom that user granted the privilege. This is known as cascading revocation.

Question 6

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

Accepted Answer

This is because privileges are granted to users through roles, so when the role is removed, the privileges associated with it are also removed from the users who were granted them.

Question 7

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

Accepted Answer

The SESSION_PRIVS view can be used by a user to check all the currently enabled privileges.

Question 8

A user can change his or her current $\underline { \text { PASSWORD } }$ using the PASSWORD command. _________________________

Accepted Answer

The PASSWORD command allows a user to change their current password.

Question 9

The $\underline {\text { CHANGE PASSWORD }}$ option can be used to force a user to change the user password at the time of the next login. _________________________

Accepted Answer

The answer of The $\underline {\text { CHANGE PASSWORD }}$...

Question 10

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 11

The $\underline {  \text { WITH ADMIN OPTION }  }$ is required to enable the user to grant the specified object privileges to other users. _________________________

Accepted Answer

The answer of The \(\underline {  \text { WITH...

Question 12

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

Accepted Answer

This statement is true. Users can be assigned a default role which will automatically be enabled whenever they log in to the database. This can help simplify security settings and ensure that users have the appropriate level of access to data within the database.

Question 13

$\underline { \text { Privileges } }$ allow Oracle11g users to execute certain SQL statements. _________________________

Accepted Answer

Privileges in Oracle11g allow users to execute certain SQL statements based on their level of access granted by the database administrator.

Question 14

Oracle11g uses a process known as $\underline {  \text { selection }  }$to ensure that users are who they say they are. _________________________

Accepted Answer

Oracle11g uses a process known as authentication, not selection, to verify the identity of users.

Question 15

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 16

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 system privileges for the current user.

Question 17

The $\underline { \text { PASS IS }  }$ clause of the CREATE USER command indicates the password assigned to a user. _________________________

Accepted Answer

The answer of The \(\underline { \text { PASS IS...

Question 18

There are $\underline {  15  }$ object privileges available in Oracle11g. _________________________

Accepted Answer

There are 15 object privileges available in Oracle11g, which include privileges such as SELECT, INSERT, UPDATE, DELETE, INDEX, EXECUTE, and more.

Question 19

$\underline {\text { Obiect } }$ privileges allow users to execute DDL commands. _________________________

Accepted Answer

The answer of $\underline {\text { Obiect } }$ privileges...

Question 20

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.

Quiz 7: User Creation and Management

The $\underline { FOR }$ clause of the GRANT command is used to specify the object to which the privilege applies. _________________________

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

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

Even if users are $\underline { \text { authenticated } }$ by the operating system, the users are still required to have valid Oracle11g accounts to access the database. _________________________

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.

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

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

A user can change his or her current $\underline { \text { PASSWORD } }$ using the PASSWORD command. _________________________

The $\underline {\text { CHANGE PASSWORD }}$ option can be used to force a user to change the user password at the time of the next login. _________________________

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

The $\underline { \text { WITH ADMIN OPTION } }$ is required to enable the user to grant the specified object privileges to other users. _________________________

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

$\underline { \text { Privileges } }$ allow Oracle11g users to execute certain SQL statements. _________________________

Oracle11g uses a process known as $\underline { \text { selection } }$ to ensure that users are who they say they are. _________________________

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

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

The $\underline { \text { PASS IS } }$ clause of the CREATE USER command indicates the password assigned to a user. _________________________

There are $\underline { 15 }$ object privileges available in Oracle11g. _________________________

$\underline {\text { Obiect } }$ privileges allow users to execute DDL commands. _________________________

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

Quiz 7: User Creation and Management

The FOR‾\underline { FOR }FOR​ clause of the GRANT command is used to specify the object to which the privilege applies. _________________________

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

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

Even if users are authenticated ‾\underline { \text { authenticated } } authenticated ​ by the operating system, the users are still required to have valid Oracle11g accounts to access the database. _________________________

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.

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

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

A user can change his or her current PASSWORD ‾\underline { \text { PASSWORD } } PASSWORD ​ using the PASSWORD command. _________________________

The CHANGE PASSWORD ‾\underline {\text { CHANGE PASSWORD }} CHANGE PASSWORD ​ option can be used to force a user to change the user password at the time of the next login. _________________________

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

The WITH ADMIN OPTION ‾\underline { \text { WITH ADMIN OPTION } } WITH ADMIN OPTION ​ is required to enable the user to grant the specified object privileges to other users. _________________________

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

Privileges ‾\underline { \text { Privileges } } Privileges ​ allow Oracle11g users to execute certain SQL statements. _________________________

Oracle11g uses a process known as selection ‾\underline { \text { selection } } selection ​ to ensure that users are who they say they are. _________________________

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

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

The PASS IS ‾\underline { \text { PASS IS } } PASS IS ​ clause of the CREATE USER command indicates the password assigned to a user. _________________________

There are 15‾\underline { 15 }15​ object privileges available in Oracle11g. _________________________

Obiect ‾\underline {\text { Obiect } } Obiect ​ privileges allow users to execute DDL commands. _________________________

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

The $\underline { FOR }$ clause of the GRANT command is used to specify the object to which the privilege applies. _________________________

Even if users are $\underline { \text { authenticated } }$ by the operating system, the users are still required to have valid Oracle11g accounts to access the database. _________________________

A user can change his or her current $\underline { \text { PASSWORD } }$ using the PASSWORD command. _________________________

The $\underline {\text { CHANGE PASSWORD }}$ option can be used to force a user to change the user password at the time of the next login. _________________________

The $\underline { \text { WITH ADMIN OPTION } }$ is required to enable the user to grant the specified object privileges to other users. _________________________

$\underline { \text { Privileges } }$ allow Oracle11g users to execute certain SQL statements. _________________________

Oracle11g uses a process known as $\underline { \text { selection } }$ to ensure that users are who they say they are. _________________________

The $\underline { \text { PASS IS } }$ clause of the CREATE USER command indicates the password assigned to a user. _________________________

There are $\underline { 15 }$ object privileges available in Oracle11g. _________________________

$\underline {\text { Obiect } }$ privileges allow users to execute DDL commands. _________________________