Question 1

Which of the following statements about creating a username is incorrect?

Accepted Answer

A)  A user name can contain up to 30 characters. 
B)  A user name can contain the symbols _ ,$,and #. 
C)  A user name cannot contain numbers. 
D)  A user name can contain upper-case letters. 
A)  A user name can contain up to 30 characters. 
B)  A user name can contain the symbols _ ,$,and #. 
C)  A user name cannot contain numbers. 
D)  A user name can contain upper-case letters. C

Question 2

​The ____ privilege will allow a user to connect to the Oracle12c database.

Accepted Answer

A)  ​CREATE CONNECT 
B)  ​CREATE LOG 
C)  ​CREATE SESSION 
D)  ​CONNECT 
A)  ​CREATE CONNECT 
B)  ​CREATE LOG 
C)  ​CREATE SESSION 
D)  ​CONNECT C

Question 3

A user can query the ROLE_SYS_PRIVS data dictionary view to determine the privileges currently enabled for that user._________________________​

Accepted Answer

A) True 
 B)False  False

Question 4

​Which command will establish a new role?

Accepted Answer

A)  ​CREATE NEW ROLE rolename; 
B)  ​CREATE ROLE rolename; 
C)  ​CREATE ROLE rolename FOR username; 
D)  ​CREATE ROLE rolename WITH privilege; 
A)  ​CREATE NEW ROLE rolename; 
B)  ​CREATE ROLE rolename; 
C)  ​CREATE ROLE rolename FOR username; 
D)  ​CREATE ROLE rolename WITH privilege;

Question 5

Which of the following is not a method used by the Oracle 12c database to prevent illegal access into the software?​

Accepted Answer

A)  ​automatic encryption of all user input 
B)  ​limiting user privileges to access data 
C)  authentication through user name and password​ 
D)  ​support for third-party security software and hardware devices 
A)  ​automatic encryption of all user input 
B)  ​limiting user privileges to access data 
C)  authentication through user name and password​ 
D)  ​support for third-party security software and hardware devices

Question 6

Which of the following SQL statements will remove user RTHOMAS from the database?​

Accepted Answer

A)  ​DELETE rthomas; 
B)  ​DELETE USER rthomas; 
C)  ​DROP USER rthomas; 
D)  ​DROP rthomas; 
A)  ​DELETE rthomas; 
B)  ​DELETE USER rthomas; 
C)  ​DROP USER rthomas; 
D)  ​DROP rthomas;

Question 7

The PASS IS clause of the CREATE USER command indicates the password assigned to a user._________________________

Accepted Answer

A) True 
 B)False

Question 8

The UPDATE ANY TABLE privilege is a system privilege.​

Accepted Answer

A) True 
 B)False

Question 9

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

Both system and object privileges can be granted with the GRANT command.​

Accepted Answer

A) True 
 B)False

Question 11

-Which of the following privileges is necessary to perform the connection procedure shown above?​

Accepted Answer

A)  ​CREATE ANY TABLE 
B)  ​CONNECTION 
C)  ​CREATE SESSION 
D)  ​ACCESS DATABASE 
A)  ​CREATE ANY TABLE 
B)  ​CONNECTION 
C)  ​CREATE SESSION 
D)  ​ACCESS DATABASE

Question 12

A user can issue the ____________________ command to enable a role.

Accepted Answer

The answer of A user can issue the ____________________ command...

Question 13

The ____ command will assign a default role to a user.​

Accepted Answer

A)  ​ALTER USER username MODIFY ROLE rolename; 
B)  ​ALTER DEFAULT ROLE rolename GRANT username; 
C)  ​ALTER ROLE rolename MODIFY USER username; 
D)  ​ALTER USER username DEFAULT ROLE rolename; 
A)  ​ALTER USER username MODIFY ROLE rolename; 
B)  ​ALTER DEFAULT ROLE rolename GRANT username; 
C)  ​ALTER ROLE rolename MODIFY USER username; 
D)  ​ALTER USER username DEFAULT ROLE rolename;

Question 14

Which of the following commands will change a user's password?

Accepted Answer

A)  ALTER USERNAME username IDENTIFIED BY newpassword; 
B)  ALTER USER username IDENTITY newpassword; 
C)  ALTER USER username IDENTIFIED BY newpassword; 
D)  ALTER USERNAME username PASSWORD newpassword; 
A)  ALTER USERNAME username IDENTIFIED BY newpassword; 
B)  ALTER USER username IDENTITY newpassword; 
C)  ALTER USER username IDENTIFIED BY newpassword; 
D)  ALTER USERNAME username PASSWORD newpassword;

Question 15

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;

Question 16

Which of the following is a valid SQL command?

Accepted Answer

A)  GRANT SELECT ON orders TO rthomas WITH ADMIN OPTION; 
B)  GRANT SELECT TO rthomas; 
C)  GRANT SELECT ON orders TO rthomas WITH GRANT OPTION; 
D)  none of the above 
A)  GRANT SELECT ON orders TO rthomas WITH ADMIN OPTION; 
B)  GRANT SELECT TO rthomas; 
C)  GRANT SELECT ON orders TO rthomas WITH GRANT OPTION; 
D)  none of the above

Question 17

An object privilege cannot be granted to a role with the WITH GRANT OPTION.​

Accepted Answer

A) True 
 B)False

Question 18

Partial list of privileges
   ​
-The partial listing of privileges shown above displays what type of privileges?​

Accepted Answer

A)  ​object 
B)  ​role 
C)  ​system 
D)  ​data dictionary 
A)  ​object 
B)  ​role 
C)  ​system 
D)  ​data dictionary

Question 19

Which of the following commands can be used to assign a default role to a user?​

Accepted Answer

A)  ​ASSIGN 
B)  ​ROLE ASSIGNMENT 
C)  ​RESET DEFAULT 
D)  ​ALTER USER 
A)  ​ASSIGN 
B)  ​ROLE ASSIGNMENT 
C)  ​RESET DEFAULT 
D)  ​ALTER USER

Question 20

Which of the following SQL statements will change the password for user RTHOMAS to ANEW5PASSWORD​

Accepted Answer

A)  ​ALTER USER rthomas PASSWORD TO anew5password; 
B)  ​CHANGE USER rthomas IDENTIFIED BY anew5password; 
C)  ​MODIFY USER rthomas PASSWORD TO anew5password; 
D)  ​ALTER USER rthomas IDENTIFIED BY anew5password; 
A)  ​ALTER USER rthomas PASSWORD TO anew5password; 
B)  ​CHANGE USER rthomas IDENTIFIED BY anew5password; 
C)  ​MODIFY USER rthomas PASSWORD TO anew5password; 
D)  ​ALTER USER rthomas IDENTIFIED BY anew5password;

Which of the following statements about creating a username is incorrect?

The ____ privilege will allow a user to connect to the Oracle12c database.

A user can query the ROLE_SYS_PRIVS data dictionary view to determine the privileges currently enabled for that user._________________________

Which command will establish a new role?

Which of the following is not a method used by the Oracle 12c database to prevent illegal access into the software?

Which of the following SQL statements will remove user RTHOMAS from the database?

The PASS IS clause of the CREATE USER command indicates the password assigned to a user._________________________

The UPDATE ANY TABLE privilege is a system privilege.

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

Both system and object privileges can be granted with the GRANT command.

-Which of the following privileges is necessary to perform the connection procedure shown above?

A user can issue the ____________________ command to enable a role.

The ____ command will assign a default role to a user.

Which of the following commands will change a user's password?

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

Which of the following is a valid SQL command?

An object privilege cannot be granted to a role with the WITH GRANT OPTION.

Partial list of privileges -The partial listing of privileges shown above displays what type of privileges?

Which of the following commands can be used to assign a default role to a user?

Which of the following SQL statements will change the password for user RTHOMAS to ANEW5PASSWORD

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

Which of the following statements about creating a username is incorrect?

​The ____ privilege will allow a user to connect to the Oracle12c database.

A user can query the ROLE_SYS_PRIVS data dictionary view to determine the privileges currently enabled for that user._________________________​

​Which command will establish a new role?

Which of the following is not a method used by the Oracle 12c database to prevent illegal access into the software?​

Which of the following SQL statements will remove user RTHOMAS from the database?​

The PASS IS clause of the CREATE USER command indicates the password assigned to a user._________________________

The UPDATE ANY TABLE privilege is a system privilege.​

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

Both system and object privileges can be granted with the GRANT command.​

-Which of the following privileges is necessary to perform the connection procedure shown above?​

A user can issue the ____________________ command to enable a role.

The ____ command will assign a default role to a user.​

Which of the following commands will change a user's password?

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

Which of the following is a valid SQL command?

An object privilege cannot be granted to a role with the WITH GRANT OPTION.​

Partial list of privileges ​ -The partial listing of privileges shown above displays what type of privileges?​

Which of the following commands can be used to assign a default role to a user?​

Which of the following SQL statements will change the password for user RTHOMAS to ANEW5PASSWORD​

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 ____ privilege will allow a user to connect to the Oracle12c database.

A user can query the ROLE_SYS_PRIVS data dictionary view to determine the privileges currently enabled for that user._________________________

Which command will establish a new role?

Which of the following is not a method used by the Oracle 12c database to prevent illegal access into the software?

Which of the following SQL statements will remove user RTHOMAS from the database?

The UPDATE ANY TABLE privilege is a system privilege.

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

Both system and object privileges can be granted with the GRANT command.

-Which of the following privileges is necessary to perform the connection procedure shown above?

The ____ command will assign a default role to a user.

An object privilege cannot be granted to a role with the WITH GRANT OPTION.

Partial list of privileges -The partial listing of privileges shown above displays what type of privileges?

Which of the following commands can be used to assign a default role to a user?

Which of the following SQL statements will change the password for user RTHOMAS to ANEW5PASSWORD