Question 1

A system privilege can be taken away from a user through the UNGRANT command._________________________​

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Which of the following SQL statements will allow a user to enable the DBA role?​

Accepted Answer

A)  ​ENABLE dba; 
B)  ​SET ROLE dba; 
C)  ​SET dba; 
D)  ​none of the above 
A)  ​ENABLE dba; 
B)  ​SET ROLE dba; 
C)  ​SET dba; 
D)  ​none of the above

Question 4

Which command will delete a user account from Oracle12c?​

Accepted Answer

A)  ​DELETE USER username; 
B)  ​DELETE USER username IDENTIFIED BY password; 
C)  ​DROP USER username IDENTIFIED BY password; 
D)  ​DROP USER username; 
A)  ​DELETE USER username; 
B)  ​DELETE USER username IDENTIFIED BY password; 
C)  ​DROP USER username IDENTIFIED BY password; 
D)  ​DROP USER username;

Question 5

A(n)group is a collection of privileges that can be granted to users._________________________​

Accepted Answer

A) True 
 B)False

Question 6

Which command will grant a system privilege to a user?​

Accepted Answer

A)  ​GRANT systemprivilege USERNAME username 
B)  ​GRANT PRIVILEGE systemprivilege TO username 
C)  ​GRANT systemprivilege TO username 
D)  ​GRANT systemprivilege ON username 
A)  ​GRANT systemprivilege USERNAME username 
B)  ​GRANT PRIVILEGE systemprivilege TO username 
C)  ​GRANT systemprivilege TO username 
D)  ​GRANT systemprivilege ON username

Question 7

Which of the following views will display the privileges currently enabled for a user?​

Accepted Answer

A)  ​CURRENT_PRIVS 
B)  ​SESSION_PRIVILEGES 
C)  ​SESSION_PRIVS 
D)  ​CURRENT_PRIVILEGES 
A)  ​CURRENT_PRIVS 
B)  ​SESSION_PRIVILEGES 
C)  ​SESSION_PRIVS 
D)  ​CURRENT_PRIVILEGES

Question 8

User names can consist of up to 30 characters and include the _,#,and $ symbols._________________________​

Accepted Answer

A) True 
 B)False

Question 9

Which of the following commands can be used to revoke system or object privileges previously granted to a user?

Accepted Answer

A)  UNGRANT 
B)  REMOVE 
C)  REVOKE 
D)  DROP 
A)  UNGRANT 
B)  REMOVE 
C)  REVOKE 
D)  DROP

Question 10

Which of the following commands is used to establish a user account?​

Accepted Answer

A)  ​CREATE NEW USER username IDENTIFIED BY password; 
B)  ​CREATE USERNAME username IDENTITY password; 
C)  ​CREATE USER username PASSWORD password; 
D)  ​CREATE USER username IDENTIFIED BY password; 
A)  ​CREATE NEW USER username IDENTIFIED BY password; 
B)  ​CREATE USERNAME username IDENTITY password; 
C)  ​CREATE USER username PASSWORD password; 
D)  ​CREATE USER username IDENTIFIED BY password;

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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 13

A role that is no longer needed by any users can be removed from the database using the ____________________ command.

Accepted Answer

The answer of A role that is no longer needed...

Question 14

Which of the following are examples of object privileges?

Accepted Answer

A)  SELECT and UPDATE 
B)  CREATE USER and CREATE TABLE 
C)  UPDATE ANY TABLE and ALTER ANY TABLE 
D)  all of the above 
A)  SELECT and UPDATE 
B)  CREATE USER and CREATE TABLE 
C)  UPDATE ANY TABLE and ALTER ANY TABLE 
D)  all of the above

Question 15

All available system privileges for the current user can be displayed through the USER_SYS_PRIVS data dictionary view.​

Accepted Answer

A) True 
 B)False

Question 16

​Which of the following privileges will allow a user to reference a table when creating a FOREIGN KEY constraint?

Accepted Answer

A)  ​FOREIGN KEY 
B)  ​REFERENCES 
C)  ​SELECT 
D)  ​none of the above 
A)  ​FOREIGN KEY 
B)  ​REFERENCES 
C)  ​SELECT 
D)  ​none of the above

Question 17

Which of the following commands will enable a role for a user?​

Accepted Answer

A)  ​ENABLE ROLE rolename; 
B)  ​ENABLE rolename; 
C)  ​SET ROLE rolename; 
D)  ​ROLE rolename; 
A)  ​ENABLE ROLE rolename; 
B)  ​ENABLE rolename; 
C)  ​SET ROLE rolename; 
D)  ​ROLE rolename;

Question 18

Which of the following will add a password to a role?

Accepted Answer

A)  ALTER USER username SET ROLE rolename; 
B)  ALTER ROLE rolename SET USER username 
C)  ALTER USER username PASSWORD password; 
D)  ALTER ROLE rolename IDENTIFIED BY password; 
A)  ALTER USER username SET ROLE rolename; 
B)  ALTER ROLE rolename SET USER username 
C)  ALTER USER username PASSWORD password; 
D)  ALTER ROLE rolename IDENTIFIED BY password;

Question 19

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 20

Which of the following can be considered potential threats to an organization's data?

Accepted Answer

A)  ​natural disaster 
B)  ​disgruntled employees 
C)  ​computer criminals 
D)  ​all of the above 
A)  ​natural disaster 
B)  ​disgruntled employees 
C)  ​computer criminals 
D)  ​all of the above

A system privilege can be taken away from a user through the UNGRANT command._________________________

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

Which of the following SQL statements will allow a user to enable the DBA role?

Which command will delete a user account from Oracle12c?

A(n)group is a collection of privileges that can be granted to users._________________________

Which command will grant a system privilege to a user?

Which of the following views will display the privileges currently enabled for a user?

User names can consist of up to 30 characters and include the _,#,and $ symbols._________________________

Which of the following commands can be used to revoke system or object privileges previously granted to a user?

Which of the following commands is used to establish a user account?

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

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

A role that is no longer needed by any users can be removed from the database using the ____________________ command.

Which of the following are examples of object privileges?

All available system privileges for the current user can be displayed through the USER_SYS_PRIVS data dictionary view.

Which of the following privileges will allow a user to reference a table when creating a FOREIGN KEY constraint?

Which of the following commands will enable a role for a user?

Which of the following will add a password to a role?

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 can be considered potential threats to an organization's data?

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 system privilege can be taken away from a user through the UNGRANT command._________________________​

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

Which of the following SQL statements will allow a user to enable the DBA role?​

Which command will delete a user account from Oracle12c?​

A(n)group is a collection of privileges that can be granted to users._________________________​

Which command will grant a system privilege to a user?​

Which of the following views will display the privileges currently enabled for a user?​

User names can consist of up to 30 characters and include the _,#,and $ symbols._________________________​

Which of the following commands can be used to revoke system or object privileges previously granted to a user?

Which of the following commands is used to establish a user account?​

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

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

A role that is no longer needed by any users can be removed from the database using the ____________________ command.

Which of the following are examples of object privileges?

All available system privileges for the current user can be displayed through the USER_SYS_PRIVS data dictionary view.​

​Which of the following privileges will allow a user to reference a table when creating a FOREIGN KEY constraint?

Which of the following commands will enable a role for a user?​

Which of the following will add a password to a role?

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 can be considered potential threats to an organization's data?

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 system privilege can be taken away from a user through the UNGRANT command._________________________

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

Which of the following SQL statements will allow a user to enable the DBA role?

Which command will delete a user account from Oracle12c?

A(n)group is a collection of privileges that can be granted to users._________________________

Which command will grant a system privilege to a user?

Which of the following views will display the privileges currently enabled for a user?

User names can consist of up to 30 characters and include the _,#,and $ symbols._________________________

Which of the following commands is used to establish a user account?

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

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

All available system privileges for the current user can be displayed through the USER_SYS_PRIVS data dictionary view.

Which of the following privileges will allow a user to reference a table when creating a FOREIGN KEY constraint?

Which of the following commands will enable a role for a user?

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