Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

A role can be taken away from a user through the ____________________ command.

Accepted Answer

The answer of A role can be taken away from...

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

The ____________________ command is used to grant roles to users.

Accepted Answer

The answer of The ____________________ command is used to grant...

Question 5

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

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Which of the following statements about roles is incorrect?

Accepted Answer

A)  A role is a group, or collection, of privileged passwords and user names. 
B)  A role is a group, or collection, of privileges. 
C)  Rather than assign the same privileges again and again to different users, a simpler approach is to assign the privileges to a role, and then assign the role to the users. 
D)  Users can be assigned several different roles, based on the tasks they perform. 
A)  A role is a group, or collection, of privileged passwords and user names. 
B)  A role is a group, or collection, of privileges. 
C)  Rather than assign the same privileges again and again to different users, a simpler approach is to assign the privileges to a role, and then assign the role to the users. 
D)  Users can be assigned several different roles, based on the tasks they perform.

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 10

Which of the following is a valid SQL command?

Accepted Answer

A)  GRANT SELECT ON orders TO rthomas WITH ADMIN OPTION; 
B)  GRANT SELECT TO rthomas; 
C)  GRANT SELECT ON orders TO rthomas WITH GRANT OPTION; 
D)  none of the above 
A)  GRANT SELECT ON orders TO rthomas WITH ADMIN OPTION; 
B)  GRANT SELECT TO rthomas; 
C)  GRANT SELECT ON orders TO rthomas WITH GRANT OPTION; 
D)  none of the above

Question 11

Which command will remove an existing role from a database?

Accepted Answer

A)  DROP rolename; 
B)  DROP ROLE rolename; 
C)  DELETE ROLE rolename; 
D)  DELETE rolename; 
A)  DROP rolename; 
B)  DROP ROLE rolename; 
C)  DELETE ROLE rolename; 
D)  DELETE rolename;

Question 12

The ____________________ command can be used to create a new role.

Accepted Answer

The answer of The ____________________ command can be used to...

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

A role can be taken away from a user through the ____________________ command.

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

The ____________________ command is used to grant roles to users.

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.

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

Which of the following statements about roles is incorrect?

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

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

Which of the following is a valid SQL command?

Which command will remove an existing role from a database?

The ____________________ command can be used to create a new role.

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

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

A role can be taken away from a user through the ____________________ command.

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

The ____________________ command is used to grant roles to users.

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.

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

Which of the following statements about roles is incorrect?

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

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

Which of the following is a valid SQL command?

Which command will remove an existing role from a database?

The ____________________ command can be used to create a new role.

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

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

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