Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Revoking a privilege that was issued with the WITH ____________________ OPTION will cause any subsequent recipients to have their privilege revoked also.

Accepted Answer

The answer of Revoking a privilege that was issued with...

Question 3

Which of the following SQL statements will grant all object privileges for the ORDERS table to user RTHOMAS?

Accepted Answer

A)  GRANT ALL ON orders TO rthomas; 
B)  GRANT * ON orders TO rthomas; 
C)  GRANT ALL OBJECTS ON orders TO rthomas; 
D)  GRANT ALL OPRIVS ON orders TO rthomas; 
A)  GRANT ALL ON orders TO rthomas; 
B)  GRANT * ON orders TO rthomas; 
C)  GRANT ALL OBJECTS ON orders TO rthomas; 
D)  GRANT ALL OPRIVS ON orders TO rthomas;

Question 4

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

A) True 
 B)False

Question 5

Which of the following SQL statements will assign the DBA role as the default role for user RTHOMAS?

Accepted Answer

A)  ALTER USER rthomas SET DEFAULT TO DBA; 
B)  SET ROLE DBA; 
C)  ALTER USER rthomas DEFAULT ROLE dba; 
D)  none of the above 
A)  ALTER USER rthomas SET DEFAULT TO DBA; 
B)  SET ROLE DBA; 
C)  ALTER USER rthomas DEFAULT ROLE dba; 
D)  none of the above

Question 6

Which of the following terms refers to a collection of privileges?

Accepted Answer

A)  role 
B)  grouping 
C)  groupset 
D)  accesset 
A)  role 
B)  grouping 
C)  groupset 
D)  accesset

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

The WITH ____________________ OPTION is required to allow the recipient to grant the object privilege(s) to other users.

Accepted Answer

The answer of The WITH ____________________ OPTION is required to...

Question 10

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 11

Which of the following commands will grant a role to a user?

Accepted Answer

A)  GRANT rolename TO username; 
B)  GRANT ROLE rolename TO username; 
C)  GRANT rolename FOR username; 
D)  GRANT ROLE rolename FOR username; 
A)  GRANT rolename TO username; 
B)  GRANT ROLE rolename TO username; 
C)  GRANT rolename FOR username; 
D)  GRANT ROLE rolename FOR username;

Question 12

A user can assume a different set of privileges or a different role by issuing the ____________________ ROLE command.

Accepted Answer

The answer of A user can assume a different set...

Question 13

The $\underline { \text { WITH GRANT OPTION }  }$ cannot be included when assigning privileges to roles. _________________________

Accepted Answer

A) True 
 B)False

Question 14

A role can be created with the CREATE ROLE command.

Accepted Answer

A) True 
 B)False

Question 15

In Oracle11g, a user name can consist of a maximum of ____________________ characters.

Accepted Answer

The answer of In Oracle11g, a user name can consist...

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Which of the following keywords must be included with the GRANT command to allow the user to grant system privileges to other users?

Accepted Answer

A)  WITH GRANT OPTION 
B)  WITH ADMIN OPTION 
C)  WITH SYSADMIN OPTION 
D)  WITH DBA OPTION 
A)  WITH GRANT OPTION 
B)  WITH ADMIN OPTION 
C)  WITH SYSADMIN OPTION 
D)  WITH DBA OPTION

Question 18

Which of the following SQL statements will revoke the DBA role from user RTHOMAS?

Accepted Answer

A)  REVOKE ROLE dba FROM rthomas; 
B)  UNGRANT ROLE dba FROM rthomas; 
C)  REVOKE dba FROM rthomas; 
D)  UNGRANT dba FROM rthomas; 
A)  REVOKE ROLE dba FROM rthomas; 
B)  UNGRANT ROLE dba FROM rthomas; 
C)  REVOKE dba FROM rthomas; 
D)  UNGRANT dba FROM rthomas;

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

Which of the following commands will revoke the SELECT privilege for the ORDERS table previously granted to user RTHOMAS?

Accepted Answer

A)  REVOKE SELECT FROM rthomas; 
B)  REVOKE SELECT ON orders FROM rthomas; 
C)  REVOKE SELECT FOR orders FROM rthomas; 
D)  UNGRANT SELECT FROM rthomas; 
A)  REVOKE SELECT FROM rthomas; 
B)  REVOKE SELECT ON orders FROM rthomas; 
C)  REVOKE SELECT FOR orders FROM rthomas; 
D)  UNGRANT SELECT FROM rthomas;

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

Revoking a privilege that was issued with the WITH ____________________ OPTION will cause any subsequent recipients to have their privilege revoked also.

Which of the following SQL statements will grant all object privileges for the ORDERS table to user RTHOMAS?

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.

Which of the following SQL statements will assign the DBA role as the default role for user RTHOMAS?

Which of the following terms refers to a collection of privileges?

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

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

The WITH ____________________ OPTION is required to allow the recipient to grant the object privilege(s) to other users.

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

Which of the following commands will grant a role to a user?

A user can assume a different set of privileges or a different role by issuing the ____________________ ROLE command.

The $\underline { \text { WITH GRANT OPTION } }$ cannot be included when assigning privileges to roles. _________________________

A role can be created with the CREATE ROLE command.

In Oracle11g, a user name can consist of a maximum of ____________________ characters.

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

Which of the following keywords must be included with the GRANT command to allow the user to grant system privileges to other users?

Which of the following SQL statements will revoke the DBA role from user RTHOMAS?

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

Which of the following commands will revoke the SELECT privilege for the ORDERS table previously granted to user RTHOMAS?

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 be granted both system and object privileges in the same GRANT command.

Revoking a privilege that was issued with the WITH ____________________ OPTION will cause any subsequent recipients to have their privilege revoked also.

Which of the following SQL statements will grant all object privileges for the ORDERS table to user RTHOMAS?

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.

Which of the following SQL statements will assign the DBA role as the default role for user RTHOMAS?

Which of the following terms refers to a collection of privileges?

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

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

The WITH ____________________ OPTION is required to allow the recipient to grant the object privilege(s) to other users.

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

Which of the following commands will grant a role to a user?

A user can assume a different set of privileges or a different role by issuing the ____________________ ROLE command.

The WITH GRANT OPTION ‾\underline { \text { WITH GRANT OPTION } } WITH GRANT OPTION ​ cannot be included when assigning privileges to roles. _________________________

A role can be created with the CREATE ROLE command.

In Oracle11g, a user name can consist of a maximum of ____________________ characters.

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

Which of the following keywords must be included with the GRANT command to allow the user to grant system privileges to other users?

Which of the following SQL statements will revoke the DBA role from user RTHOMAS?

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

Which of the following commands will revoke the SELECT privilege for the ORDERS table previously granted to user RTHOMAS?

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 $\underline { \text { WITH GRANT OPTION } }$ cannot be included when assigning privileges to roles. _________________________