Question 1

What is the benefit of assigning privileges to users through roles?

Accepted Answer

The DBA can assign a group of privileges

Question 2

​Which of the following statements about granting system privileges is incorrect?

Accepted Answer

A)  ​The system privilege being assigned is identified in the GRANT clause. 
B)  ​The user(s)or role(s)receiving the system privilege is identified in the TO clause. 
C)  ​WITH ADMIN OPTION is used to allow any user or role identified in the TO clause to grant the system privilege(s)to any other database users. 
D)  ​WITH EXCLUSIVE MODE is used to forbid any user not identified in the TO clause from granting the system privilege(s)to any other database users. 
A)  ​The system privilege being assigned is identified in the GRANT clause. 
B)  ​The user(s)or role(s)receiving the system privilege is identified in the TO clause. 
C)  ​WITH ADMIN OPTION is used to allow any user or role identified in the TO clause to grant the system privilege(s)to any other database users. 
D)  ​WITH EXCLUSIVE MODE is used to forbid any user not identified in the TO clause from granting the system privilege(s)to any other database users.

Question 3

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 4

If a user issues the ____________________ command to change his or her password,the user will be prompted for both the old and new password.

Accepted Answer

The answer of If a user issues the ____________________ command...

Question 5

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 6

To be able to connect to Oracle12c,the user must have the ____________________ privilege.

Accepted Answer

The answer of To be able to connect to Oracle12c,the...

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

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

Accepted Answer

A) True 
 B)False

Question 9

The DEFAULT ROLE option of the ALTER USER command can be used to assign a default role to an existing user._________________________​

Accepted Answer

A) True 
 B)False

Question 10

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 11

Once a privilege has been granted to a role,it cannot be revoked without re-creating the role.​

Accepted Answer

A) True 
 B)False

Question 12

Privileges allow Oracle12c users to execute certain SQL statements._________________________

Accepted Answer

A) True 
 B)False

Question 13

Oracle12c uses a process known as selection to ensure that users are who they say they are._________________________​

Accepted Answer

A) True 
 B)False

Question 14

Which of the following will revoke a user's object privileges?​

Accepted Answer

A)  ​REVOKE objectprivilege ON OBJECT objectname FROM username; 
B)  ​REVOKE objectprivilege ON objectname FROM username; 
C)  ​REVOKE objectprivilege ON objectname FOR username; 
D)  ​DROP objectprivilege ON objectname FROM username; 
A)  ​REVOKE objectprivilege ON OBJECT objectname FROM username; 
B)  ​REVOKE objectprivilege ON objectname FROM username; 
C)  ​REVOKE objectprivilege ON objectname FOR username; 
D)  ​DROP objectprivilege ON objectname FROM username;

Question 15

Which of the following statements about privileges is incorrect?​

Accepted Answer

A)  ​There are five types of privileges,including DATATYPE,ROLETYPE,and USERNAME privileges. 
B)  ​System privileges allow access to the Oracle 12c database and let users perform DDL operations such as CREATE,ALTER,and DROP on database objects. 
C)  ​Object privileges allow users to perform DML operations on the data contained within the database objects. 
D)  ​When a user creates an object,he or she automatically has all the object privileges associated with that object. 
A)  ​There are five types of privileges,including DATATYPE,ROLETYPE,and USERNAME privileges. 
B)  ​System privileges allow access to the Oracle 12c database and let users perform DDL operations such as CREATE,ALTER,and DROP on database objects. 
C)  ​Object privileges allow users to perform DML operations on the data contained within the database objects. 
D)  ​When a user creates an object,he or she automatically has all the object privileges associated with that object.

Question 16

Which of the following refers to the process of ensuring that individuals trying to access the system are who they say they are,thus preventing them from illegally accessing data?

Accepted Answer

A)  ​authorization 
B)  ​authentication 
C)  ​individualization 
D)  ​accreditation 
A)  ​authorization 
B)  ​authentication 
C)  ​individualization 
D)  ​accreditation

Question 17

____________________ privileges allow users to execute specific DDL commands.

Accepted Answer

The answer of ____________________ privileges allow users to execute specific...

Question 18

Authentication is the process of ensuring that the individuals trying to access the system are who they claim to be.​

Accepted Answer

A) True 
 B)False

Question 19

The GENERATE ROLE command is used to add a new role to the database._________________________​

Accepted Answer

A) True 
 B)False

Question 20

The ____ command is used to revoke a role.​

Accepted Answer

A)  ​REVOKE rolename FROM username; 
B)  ​ALTER rolename REVOKE username; 
C)  ​DROP rolename FROM username; 
D)  ​DROP rolename REVOKE FROM username; 
A)  ​REVOKE rolename FROM username; 
B)  ​ALTER rolename REVOKE username; 
C)  ​DROP rolename FROM username; 
D)  ​DROP rolename REVOKE FROM username;

What is the benefit of assigning privileges to users through roles?

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

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.

If a user issues the ____________________ command to change his or her password,the user will be prompted for both the old and new password.

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

To be able to connect to Oracle12c,the user must have the ____________________ privilege.

Which of the following statements about roles is incorrect?

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

The DEFAULT ROLE option of the ALTER USER command can be used to assign a default role to an existing user._________________________

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

Once a privilege has been granted to a role,it cannot be revoked without re-creating the role.

Privileges allow Oracle12c users to execute certain SQL statements._________________________

Oracle12c uses a process known as selection to ensure that users are who they say they are._________________________

Which of the following will revoke a user's object privileges?

Which of the following statements about privileges is incorrect?

Which of the following refers to the process of ensuring that individuals trying to access the system are who they say they are,thus preventing them from illegally accessing data?

____________________ privileges allow users to execute specific DDL commands.

Authentication is the process of ensuring that the individuals trying to access the system are who they claim to be.

The GENERATE ROLE command is used to add a new role to the database._________________________

The ____ command is used to revoke a 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

What is the benefit of assigning privileges to users through roles?

​Which of the following statements about granting system privileges is incorrect?

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.​

If a user issues the ____________________ command to change his or her password,the user will be prompted for both the old and new password.

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

To be able to connect to Oracle12c,the user must have the ____________________ privilege.

Which of the following statements about roles is incorrect?​

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

The DEFAULT ROLE option of the ALTER USER command can be used to assign a default role to an existing user._________________________​

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

Once a privilege has been granted to a role,it cannot be revoked without re-creating the role.​

Privileges allow Oracle12c users to execute certain SQL statements._________________________

Oracle12c uses a process known as selection to ensure that users are who they say they are._________________________​

Which of the following will revoke a user's object privileges?​

Which of the following statements about privileges is incorrect?​

Which of the following refers to the process of ensuring that individuals trying to access the system are who they say they are,thus preventing them from illegally accessing data?

____________________ privileges allow users to execute specific DDL commands.

Authentication is the process of ensuring that the individuals trying to access the system are who they claim to be.​

The GENERATE ROLE command is used to add a new role to the database._________________________​

The ____ command is used to revoke a 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

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

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.

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

Which of the following statements about roles is incorrect?

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

The DEFAULT ROLE option of the ALTER USER command can be used to assign a default role to an existing user._________________________

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

Once a privilege has been granted to a role,it cannot be revoked without re-creating the role.

Oracle12c uses a process known as selection to ensure that users are who they say they are._________________________

Which of the following will revoke a user's object privileges?

Which of the following statements about privileges is incorrect?

Authentication is the process of ensuring that the individuals trying to access the system are who they claim to be.

The GENERATE ROLE command is used to add a new role to the database._________________________

The ____ command is used to revoke a role.