Question 1

The PASSWORD EXPIRE option can be used to force a user to change his or her password at the time of the next login.​

Accepted Answer

The PASSWORD EXPIRE option can be set at the user level or at the profile level to force the user to change his or her password at the next login. This helps to ensure the security of the database and protect against unauthorized access.

Question 2

Authentication is the process of ensuring that the individuals trying to access the system are who they claim to be.​

Accepted Answer

This is the definition of authentication.

Question 3

Object privileges allow users to perform DML operations on the data contained within database objects.

Accepted Answer

Object privileges are used to grant permissions for performing DML operations on database objects such as tables, views, and procedures.

Question 4

An object privilege cannot be granted to a role with the WITH GRANT OPTION.​

Accepted Answer

This statement is true. An object privilege cannot be granted to a role with the WITH GRANT OPTION. The WITH GRANT OPTION allows a user or role to pass on their own privileges to other users or roles, and this capability is not allowed for object privileges.

Question 5

A user can be granted both system and object privileges in the same GRANT command.​

Accepted Answer

System privileges and object privileges are granted using separate GRANT commands in SQL. System privileges allow a user to perform administrative tasks, while object privileges give rights on specific database objects like tables or views.

Question 6

The system privileges available in Oracle 12c can be viewed through the SYSTEM_PRIVILEGE_MAP data dictionary view.​

Accepted Answer

This statement is true. The SYSTEM_PRIVILEGE_MAP data dictionary view displays the system privileges available in Oracle 12c.

Question 7

Both system and object privileges can be granted with the GRANT command.​

Accepted Answer

Both system and object privileges can be granted with the GRANT command in SQL.

Question 8

Even if a set of privileges have been assigned to a role,it does not make it any easier for the DBA since the privileges will still need to be granted individually to the users.​

Accepted Answer

Assigning privileges to a role and then granting that role to users simplifies the administration process for the DBA, as it allows for the management of permissions in a more centralized and efficient manner.

Question 9

The password for a user can be set with the PASSWORD clause of the CREATE USER command.

Accepted Answer

The answer of The password for a user can be...

Question 10

Any privilege with the ANY keyword in it is automatically an object privilege.​

Accepted Answer

The ANY keyword in a privilege does not automatically make it an object privilege; it often indicates a system privilege that allows actions on any object of a certain type, not a specific object privilege.

Question 11

User names in Oracle12c can consist of up to 30 characters.​

Accepted Answer

User names in Oracle12c can consist of up to 30 characters.

Question 12

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

Accepted Answer

The CREATE ROLE command is used to create a role in a database system.

Question 13

The GRANT ROLE command is used to grant roles to users.​

Accepted Answer

The answer of The GRANT ROLE command is used to...

Question 14

The UPDATE ANY TABLE privilege is a system privilege.​

Accepted Answer

The answer of The UPDATE ANY TABLE privilege is a...

Question 15

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

Accepted Answer

The INSERT, UPDATE, and DELETE object privileges can be applied to both tables and views in a database.

Question 16

The GRANT clause of the GRANT command identifies the user who is granting a specific privilege.​

Accepted Answer

The GRANT clause specifies the privileges being granted, not the user granting them; the user granting the privileges is typically the one executing the GRANT command.

Question 17

A role can only be granted to other roles.​

Accepted Answer

A role can be granted to both users and other roles, allowing for flexible permission management in databases and systems.

Question 18

The WITH GRANT OPTION is required to allow a user to grant the specified object privileges to other users.

Accepted Answer

The WITH GRANT OPTION privilege allows a user to grant the object privileges they have been granted to other users. Without this privilege, the user cannot grant those privileges to others.

Question 19

Permissions allow users to execute certain SQL statements in Oracle12c.

Accepted Answer

The answer of Permissions allow users to execute certain SQL...

Question 20

The ON clause of the GRANT command is used to specify which objects can be altered by the system privilege(s)specified in the command.​

Accepted Answer

The ON clause of the GRANT command is used to specify the database objects (like tables, views, sequences, etc.) on which the privileges are being granted, not to specify objects that can be altered by system privileges. System privileges are granted directly without specifying objects.

Quiz 7: User Creation and Management

The PASSWORD EXPIRE option can be used to force a user to change his or her password at the time of the next login.​

Authentication is the process of ensuring that the individuals trying to access the system are who they claim to be.​

Object privileges allow users to perform DML operations on the data contained within database objects.

An object privilege cannot be granted to a role with the WITH GRANT OPTION.​

A user can be granted both system and object privileges in the same GRANT command.​

The system privileges available in Oracle 12c can be viewed through the SYSTEM_PRIVILEGE_MAP data dictionary view.​

Both system and object privileges can be granted with the GRANT command.​

Even if a set of privileges have been assigned to a role,it does not make it any easier for the DBA since the privileges will still need to be granted individually to the users.​

The password for a user can be set with the PASSWORD clause of the CREATE USER command.

Any privilege with the ANY keyword in it is automatically an object privilege.​

User names in Oracle12c can consist of up to 30 characters.​

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

The GRANT ROLE command is used to grant roles to users.​

The UPDATE ANY TABLE privilege is a system privilege.​

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

The GRANT clause of the GRANT command identifies the user who is granting a specific privilege.​

A role can only be granted to other roles.​

The WITH GRANT OPTION is required to allow a user to grant the specified object privileges to other users.

Permissions allow users to execute certain SQL statements in Oracle12c.

The ON clause of the GRANT command is used to specify which objects can be altered by the system privilege(s)specified in the command.​

The PASSWORD EXPIRE option can be used to force a user to change his or her password at the time of the next login.

Authentication is the process of ensuring that the individuals trying to access the system are who they claim to be.

An object privilege cannot be granted to a role with the WITH GRANT OPTION.

A user can be granted both system and object privileges in the same GRANT command.

The system privileges available in Oracle 12c can be viewed through the SYSTEM_PRIVILEGE_MAP data dictionary view.

Both system and object privileges can be granted with the GRANT command.

Even if a set of privileges have been assigned to a role,it does not make it any easier for the DBA since the privileges will still need to be granted individually to the users.

Any privilege with the ANY keyword in it is automatically an object privilege.

User names in Oracle12c can consist of up to 30 characters.

A role can be created with the CREATE ROLE command.

The GRANT ROLE command is used to grant roles to users.

The UPDATE ANY TABLE privilege is a system privilege.

The GRANT clause of the GRANT command identifies the user who is granting a specific privilege.

A role can only be granted to other roles.

The ON clause of the GRANT command is used to specify which objects can be altered by the system privilege(s)specified in the command.