Question 1

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

Accepted Answer

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

Question 2

User names in Oracle12c can consist of up to 30 characters.​

Accepted Answer

A) True 
 B)False

Question 3

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 4

Object privileges allow users to execute DDL commands._________________________​

Accepted Answer

A) True 
 B)False

Question 5

Even if a password has been assigned,a user is not required to enter a password for a role that has been set as the ____________________ role for that user.

Accepted Answer

The answer of Even if a password has been assigned,a...

Question 6

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 7

​Which of the following commands will allow a use to connect to the Oracle database?

Accepted Answer

A)  GRANT SESSION TO username; 
B)  GRANT CREATE SESSION TO username; 
C)  GRANT CREATE SESSION FOR username; 
D)  GRANT CREATE LOGON TO username; 
A)  GRANT SESSION TO username; 
B)  GRANT CREATE SESSION TO username; 
C)  GRANT CREATE SESSION FOR username; 
D)  GRANT CREATE LOGON TO username;

Question 8

Which of the following SQL statements will create a new role named PRCLERK?​

Accepted Answer

A)  ​CREATE prclerk; 
B)  ​CREATE ROLE prclerk; 
C)  ​CREATE ROLE prclerk ON payroll; 
D)  ​CREATE ROLE prclerk WITH SELECT ANY TABLE PRIVILEGE; 
A)  ​CREATE prclerk; 
B)  ​CREATE ROLE prclerk; 
C)  ​CREATE ROLE prclerk ON payroll; 
D)  ​CREATE ROLE prclerk WITH SELECT ANY TABLE PRIVILEGE;

Question 9

Revoking a privilege originally granted with the WITH ____________________ OPTION will have no cascading effect on other users.

Accepted Answer

The answer of Revoking a privilege originally granted with the...

Question 10

A privilege with the ANY keyword is automatically a(n)____________________ privilege since it is not associated with a specific object.

Accepted Answer

The answer of A privilege with the ANY keyword is...

Question 11

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 12

Which of the following clauses is required when granting an objective privilege to a user?

Accepted Answer

A)  ​FOR 
B)  ​ON 
C)  ​OBJECT 
D)  ​none of the above 
A)  ​FOR 
B)  ​ON 
C)  ​OBJECT 
D)  ​none of the above

Question 13

Which of the following SQL statements will remove the SELECT ANY TABLE privilege from the database so it can never be granted to another user?​

Accepted Answer

A)  ​REVOKE SELECT ANY TABLE; 
B)  ​REVOKE SELECT ANY TABLE FROM data_dictionary; 
C)  ​REMOVE SELECT ANY TABLE; 
D)  ​none of the above 
A)  ​REVOKE SELECT ANY TABLE; 
B)  ​REVOKE SELECT ANY TABLE FROM data_dictionary; 
C)  ​REMOVE SELECT ANY TABLE; 
D)  ​none of the above

Question 14

What are the differences between object and system privileges?

Accepted Answer

An object privilege allows DML

Question 15

The PASSWORD EXPIRE option can be used to force a user to change his or her password at the time of the next login.​

Accepted Answer

A) True 
 B)False

Question 16

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 17

Which of the following SQL statements will grant the SELECT privilege for the ORDERS table to all database users?

Accepted Answer

A)  GRANT SELECT ON orders TO PUBLIC; 
B)  GRANT SELECT ON orders TO EVERYONE; 
C)  GRANT SELECT ON orders TO *; 
D)  none of the above 
A)  GRANT SELECT ON orders TO PUBLIC; 
B)  GRANT SELECT ON orders TO EVERYONE; 
C)  GRANT SELECT ON orders TO *; 
D)  none of the above

Question 18

Object privileges allow users to perform DML operations on the data contained within database objects.

Accepted Answer

A) True 
 B)False

Question 19

The ____________________ clause of the GRANT command specifies the user(s)or role(s)receiving the privilege.

Accepted Answer

The answer of The ____________________ clause of the GRANT command...

Question 20

A user can change his or her current password using the PASSWORD command.​

Accepted Answer

A) True 
 B)False

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

User names in Oracle12c can consist of up to 30 characters.

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

Object privileges allow users to execute DDL commands._________________________

Even if a password has been assigned,a user is not required to enter a password for a role that has been set as the ____________________ role for that user.

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 commands will allow a use to connect to the Oracle database?

Which of the following SQL statements will create a new role named PRCLERK?

Revoking a privilege originally granted with the WITH ____________________ OPTION will have no cascading effect on other users.

A privilege with the ANY keyword is automatically a(n)____________________ privilege since it is not associated with a specific object.

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

Which of the following clauses is required when granting an objective privilege to a user?

Which of the following SQL statements will remove the SELECT ANY TABLE privilege from the database so it can never be granted to another user?

What are the differences between object and system privileges?

The PASSWORD EXPIRE option can be used to force a user to change his or her password at the time of the next login.

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

Which of the following SQL statements will grant the SELECT privilege for the ORDERS table to all database users?

Object privileges allow users to perform DML operations on the data contained within database objects.

The ____________________ clause of the GRANT command specifies the user(s)or role(s)receiving the privilege.

A user can change his or her current password using the PASSWORD 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

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

User names in Oracle12c can consist of up to 30 characters.​

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

Object privileges allow users to execute DDL commands._________________________​

Even if a password has been assigned,a user is not required to enter a password for a role that has been set as the ____________________ role for that user.

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 commands will allow a use to connect to the Oracle database?

Which of the following SQL statements will create a new role named PRCLERK?​

Revoking a privilege originally granted with the WITH ____________________ OPTION will have no cascading effect on other users.

A privilege with the ANY keyword is automatically a(n)____________________ privilege since it is not associated with a specific object.

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

Which of the following clauses is required when granting an objective privilege to a user?

Which of the following SQL statements will remove the SELECT ANY TABLE privilege from the database so it can never be granted to another user?​

What are the differences between object and system privileges?

The PASSWORD EXPIRE option can be used to force a user to change his or her password at the time of the next login.​

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

Which of the following SQL statements will grant the SELECT privilege for the ORDERS table to all database users?

Object privileges allow users to perform DML operations on the data contained within database objects.

The ____________________ clause of the GRANT command specifies the user(s)or role(s)receiving the privilege.

A user can change his or her current password using the PASSWORD 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

User names in Oracle12c can consist of up to 30 characters.

Object privileges allow users to execute DDL commands._________________________

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 commands will allow a use to connect to the Oracle database?

Which of the following SQL statements will create a new role named PRCLERK?

Which of the following SQL statements will remove the SELECT ANY TABLE privilege from the database so it can never be granted to another user?

The PASSWORD EXPIRE option can be used to force a user to change his or her password at the time of the next login.

A user can change his or her current password using the PASSWORD command.