Question 1

All privileges enabled for the current user can be queried from the ____________________ data dictionary view.

Accepted Answer

The answer of All privileges enabled for the current user...

Question 2

System and object privileges can be taken away from a user or a role using the ____________________ command.

Accepted Answer

The answer of System and object privileges can be taken...

Question 3

The system privileges assigned to roles can be seen from the ____________________ data dictionary view.

Accepted Answer

The answer of The system privileges assigned to roles can...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

A user can issue the ENABLE ROLE command to enable a role assigned to the user._________________________​

Accepted Answer

A) True 
 B)False

Question 7

Which of the following statements about granting object privileges is incorrect?

Accepted Answer

A)  The grantor has a choice to either grant individual privileges,or to use the ALL keyword in the GRANT clause. 
B)  The FROM clause is used to identify the password of the user to which the privilege(s)applies. 
C)  The TO clause identifies the user or role receiving the privilege. 
D)  The WITH GRANT OPTION gives the user the ability to grant the same object privileges to other users. 
A)  The grantor has a choice to either grant individual privileges,or to use the ALL keyword in the GRANT clause. 
B)  The FROM clause is used to identify the password of the user to which the privilege(s)applies. 
C)  The TO clause identifies the user or role receiving the privilege. 
D)  The WITH GRANT OPTION gives the user the ability to grant the same object privileges to other users.

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Which of the following SQL commands will require the user RTHOMAS to change the account password the next time the database is accessed?

Accepted Answer

A)  ALTER USER rthomas PASSWORD EXPIRE ; 
B)  ALTER USER rthomas CHANGE PASSWORD; 
C)  ALTER USER rthomas UPDATE PASSWORD; 
D)  ALTER USER rthomas EXPIRE PASSWORD; 
A)  ALTER USER rthomas PASSWORD EXPIRE ; 
B)  ALTER USER rthomas CHANGE PASSWORD; 
C)  ALTER USER rthomas UPDATE PASSWORD; 
D)  ALTER USER rthomas EXPIRE PASSWORD;

All privileges enabled for the current user can be queried from the ____________________ data dictionary view.

System and object privileges can be taken away from a user or a role using the ____________________ command.

The system privileges assigned to roles can be seen from the ____________________ data dictionary view.

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

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

A user can issue the ENABLE ROLE command to enable a role assigned to the user._________________________

Which of the following statements about granting object privileges is incorrect?

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

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

Which of the following SQL commands will require the user RTHOMAS to change the account password the next time the database is accessed?

Overview of Database Concepts

Basic SQL Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single-Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 7: User Creation and Management

All privileges enabled for the current user can be queried from the ____________________ data dictionary view.

System and object privileges can be taken away from a user or a role using the ____________________ command.

The system privileges assigned to roles can be seen from the ____________________ data dictionary view.

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

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

A user can issue the ENABLE ROLE command to enable a role assigned to the user._________________________​

Which of the following statements about granting object privileges is incorrect?

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

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

Which of the following SQL commands will require the user RTHOMAS to change the account password the next time the database is accessed?

Overview of Database Concepts

Basic SQL Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single-Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

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

A user can issue the ENABLE ROLE command to enable a role assigned to the user._________________________

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