Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Partial list of privileges
   ​
-Which of the following SQL statements would most likely be used to generate the partial output shown above?

Accepted Answer

A)  ​SELECT name FROM SYSTEM_PRIVILEGE_MAP; 
B)  ​SELECT * FROM USER_CURRENT_PRIVILEGES; 
C)  ​SELECT * FROM SESSION_PRIVS; 
D)  ​SELECT name FROM SESSION_PRIVS; 
A)  ​SELECT name FROM SYSTEM_PRIVILEGE_MAP; 
B)  ​SELECT * FROM USER_CURRENT_PRIVILEGES; 
C)  ​SELECT * FROM SESSION_PRIVS; 
D)  ​SELECT name FROM SESSION_PRIVS;

Question 3

The WITH GRANT OPTION cannot be included when assigning privileges to roles._________________________​

Accepted Answer

A) True 
 B)False

Question 4

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 5

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 6

Permissions allow users to execute certain SQL statements in Oracle12c.

Accepted Answer

A) True 
 B)False

Question 7

The REVOKE command can be used to revoke a role from a user or another role.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Which of the following keywords must be included with the GRANT command to allow the user to grant object 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 10

Granting users limited ____________________ to access data is one security method used in Oracle12c.​

Accepted Answer

The answer of Granting users limited ____________________ to access data...

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

A user can have several roles enabled at the same time._________________________​

Accepted Answer

A) True 
 B)False

Question 14

Which of the following commands is valid?

Accepted Answer

A)  ​GRANT SELECT,UPDATE ANY TABLE
ON orders
TO rthomas; 
B)  ​GRANT SELECT
ON orders
TO rthomas
WITH ADMIN OPTION; 
C)  GRANT SELECT
ON orders
TO rthomas,jdoe; 
D)  none of the above 
A)  ​GRANT SELECT,UPDATE ANY TABLE
ON orders
TO rthomas; 
B)  ​GRANT SELECT
ON orders
TO rthomas
WITH ADMIN OPTION; 
C)  GRANT SELECT
ON orders
TO rthomas,jdoe; 
D)  none of the above

Question 15

The ____ keywords are used to grant object privileges to users and roles.​

Accepted Answer

A)  ​GRANT...FOR...TO 
B)  ​CREATE...WITH...TO 
C)  ​GRANT...WITH...TO 
D)  ​GRANT...ON...TO 
A)  ​GRANT...FOR...TO 
B)  ​CREATE...WITH...TO 
C)  ​GRANT...WITH...TO 
D)  ​GRANT...ON...TO

Question 16

All system and object privileges currently enabled for a user are displayed in the SESSION_PRIVS view._________________________​

Accepted Answer

A) True 
 B)False

Question 17

Even if users are authenticated by the operating system,the users are still required to have valid Oracle12c accounts to access the database._________________________

Accepted Answer

A) True 
 B)False

Question 18

​All the Oracle12c system privileges can be viewed through the data dictionary view ____.

Accepted Answer

A)  ​USER_SYSTEM_PRIVILEGES 
B)  ​DISPLAY_SYSTEM_PRIVILEGES 
C)  ​SYSTEM_PRIVILEGE_MAP 
D)  ​none of the above 
A)  ​USER_SYSTEM_PRIVILEGES 
B)  ​DISPLAY_SYSTEM_PRIVILEGES 
C)  ​SYSTEM_PRIVILEGE_MAP 
D)  ​none of the above

Question 19

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 20

A user's password is specified in the ____________________ clause of the CREATE USER command.

Accepted Answer

The answer of A user's password is specified in the...

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

Partial list of privileges -Which of the following SQL statements would most likely be used to generate the partial output shown above?

The WITH GRANT OPTION cannot be included when assigning privileges to roles._________________________

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

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

Permissions allow users to execute certain SQL statements in Oracle12c.

The REVOKE command can be used to revoke a role from a user or another role.

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

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

Granting users limited ____________________ to access data is one security method used in Oracle12c.

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

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

A user can have several roles enabled at the same time._________________________

Which of the following commands is valid?

The ____ keywords are used to grant object privileges to users and roles.

All system and object privileges currently enabled for a user are displayed in the SESSION_PRIVS view._________________________

Even if users are authenticated by the operating system,the users are still required to have valid Oracle12c accounts to access the database._________________________

All the Oracle12c system privileges can be viewed through the data dictionary view ____.

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

A user's password is specified in the ____________________ clause of the CREATE USER command.

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 assigned a default role that is automatically enabled whenever the user logs in to the database.

Partial list of privileges ​ -Which of the following SQL statements would most likely be used to generate the partial output shown above?

The WITH GRANT OPTION cannot be included when assigning privileges to roles._________________________​

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

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

Permissions allow users to execute certain SQL statements in Oracle12c.

The REVOKE command can be used to revoke a role from a user or another role.

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

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

Granting users limited ____________________ to access data is one security method used in Oracle12c.​

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

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

A user can have several roles enabled at the same time._________________________​

Which of the following commands is valid?

The ____ keywords are used to grant object privileges to users and roles.​

All system and object privileges currently enabled for a user are displayed in the SESSION_PRIVS view._________________________​

Even if users are authenticated by the operating system,the users are still required to have valid Oracle12c accounts to access the database._________________________

​All the Oracle12c system privileges can be viewed through the data dictionary view ____.

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

A user's password is specified in the ____________________ clause of the CREATE USER command.

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

Partial list of privileges -Which of the following SQL statements would most likely be used to generate the partial output shown above?

The WITH GRANT OPTION cannot be included when assigning privileges to roles._________________________

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

Granting users limited ____________________ to access data is one security method used in Oracle12c.

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

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

A user can have several roles enabled at the same time._________________________

The ____ keywords are used to grant object privileges to users and roles.

All system and object privileges currently enabled for a user are displayed in the SESSION_PRIVS view._________________________

All the Oracle12c system privileges can be viewed through the data dictionary view ____.

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