Question 1

The $\underline {\text { 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 2

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 3

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.

Question 4

The password for a user can be set with the PASSWORD clause of the CREATE USER command.

Accepted Answer

A) True 
 B)False

Question 5

-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 6

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

Accepted Answer

A) True 
 B)False

Question 7

Any privilege with the ANY keyword in it is automatically an object privilege.

Accepted Answer

A) True 
 B)False

Question 8

A user can issue the $\underline {\text { ENABLE ROLE } }$ command to enable a role assigned to the user. _________________________

Accepted Answer

A) True 
 B)False

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

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 13

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 14

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 15

A(n) ____________________ privilege cannot be granted to a role with the WITH GRANT OPTION.

Accepted Answer

The answer of A(n) ____________________ privilege cannot be granted to...

Question 16

There are ____ object privileges in Oracle11g.

Accepted Answer

A)  7 
B)  13 
C)  15 
D)  25 
A)  7 
B)  13 
C)  15 
D)  25

Question 17

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

Question 18

There are $\underline {  15  }$ object privileges available in Oracle11g. _________________________

Accepted Answer

A) True 
 B)False

Question 19

All system and object privileges currently enabled for a user are displayed in the $\underline { \text { SESSION PRIVS } }$ view. _________________________

Accepted Answer

A) True 
 B)False

Question 20

$\underline {\text { Obiect } }$ privileges allow users to execute DDL commands. _________________________

Accepted Answer

A) True 
 B)False

The $\underline {\text { DEFAULT ROLE }}$ option of the ALTER USER command can be used to assign a default role to an existing user. _________________________

Which of the following are examples of object privileges?

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

The password for a user can be set with the PASSWORD clause of the CREATE USER command.

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

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

Any privilege with the ANY keyword in it is automatically an object privilege.

A user can issue the $\underline {\text { ENABLE ROLE } }$ command to enable a role assigned to the user. _________________________

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

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

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

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

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

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

A(n) ____________________ privilege cannot be granted to a role with the WITH GRANT OPTION.

There are ____ object privileges in Oracle11g.

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

There are $\underline { 15 }$ object privileges available in Oracle11g. _________________________

All system and object privileges currently enabled for a user are displayed in the $\underline { \text { SESSION PRIVS } }$ view. _________________________

$\underline {\text { Obiect } }$ privileges allow users to execute DDL commands. _________________________

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 DEFAULT ROLE ‾\underline {\text { DEFAULT ROLE }} DEFAULT ROLE ​ option of the ALTER USER command can be used to assign a default role to an existing user. _________________________

Which of the following are examples of object privileges?

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

The password for a user can be set with the PASSWORD clause of the CREATE USER command.

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

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

Any privilege with the ANY keyword in it is automatically an object privilege.

A user can issue the ENABLE ROLE ‾\underline {\text { ENABLE ROLE } } ENABLE ROLE ​ command to enable a role assigned to the user. _________________________

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

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

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

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

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

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

A(n) ____________________ privilege cannot be granted to a role with the WITH GRANT OPTION.

There are ____ object privileges in Oracle11g.

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

There are 15‾\underline { 15 }15​ object privileges available in Oracle11g. _________________________

All system and object privileges currently enabled for a user are displayed in the SESSION PRIVS ‾\underline { \text { SESSION PRIVS } } SESSION PRIVS ​ view. _________________________

Obiect ‾\underline {\text { Obiect } } Obiect ​ privileges allow users to execute DDL commands. _________________________

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 $\underline {\text { DEFAULT ROLE }}$ option of the ALTER USER command can be used to assign a default role to an existing user. _________________________

A user can issue the $\underline {\text { ENABLE ROLE } }$ command to enable a role assigned to the user. _________________________

There are $\underline { 15 }$ object privileges available in Oracle11g. _________________________

All system and object privileges currently enabled for a user are displayed in the $\underline { \text { SESSION PRIVS } }$ view. _________________________

$\underline {\text { Obiect } }$ privileges allow users to execute DDL commands. _________________________