Question 1

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 2

The WITH GRANT OPTION is required to allow a user to grant the specified object privileges to other users.

Accepted Answer

A) True 
 B)False

Question 3

The GRANT clause of the GRANT command identifies the user who is granting a specific privilege.

Accepted Answer

A) True 
 B)False

Question 4

Permissions allow users to execute certain SQL statements in Oracle11g.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following commands is valid?

Accepted Answer

A)  GRANT SELECT, UPDATE ANY TABLE
ON orders
TO rthomas; 
B)  GRANT SELECT
ON orders
TO rthomas
WITH ADMIN OPTION; 
C)  GRANT SELECT
ON orders
TO rthomas, jdoe; 
D)  none of the above 
A)  GRANT SELECT, UPDATE ANY TABLE
ON orders
TO rthomas; 
B)  GRANT SELECT
ON orders
TO rthomas
WITH ADMIN OPTION; 
C)  GRANT SELECT
ON orders
TO rthomas, jdoe; 
D)  none of the above

Question 6

A password cannot be assigned to a role, only to a user.

Accepted Answer

A) True 
 B)False

Question 7

____________________ privileges allow users to execute specific DML commands.

Accepted Answer

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

Question 8

If a user is granted system and object privileges, then subsequently grants those privileges to other users, what happens to the recipients if all of the original user's privileges are revoked?

Accepted Answer

In terms of the system privileges, nothi

Question 9

A user can be assigned a default role that is automatically enabled whenever the user logs in to the database.

Accepted Answer

A) True 
 B)False

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 keywords must be included with the GRANT command to allow the user to grant object 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 12

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 13

Which of the following is not a method used by the Oracle11g 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 14

The $\underline { FOR }$ clause of the GRANT command is used to specify the object to which the privilege applies. _________________________

Accepted Answer

A) True 
 B)False

Question 15

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 16

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 17

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 18

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

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

Accepted Answer

The DBA can assign a group of privileges

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

The WITH GRANT OPTION is required to allow a user to grant the specified object privileges to other users.

The GRANT clause of the GRANT command identifies the user who is granting a specific privilege.

Permissions allow users to execute certain SQL statements in Oracle11g.

Which of the following commands is valid?

A password cannot be assigned to a role, only to a user.

____________________ privileges allow users to execute specific DML commands.

If a user is granted system and object privileges, then subsequently grants those privileges to other users, what happens to the recipients if all of the original user's privileges are revoked?

A user can be assigned a default role that is automatically enabled whenever the user logs in to the database.

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

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

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

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

The $\underline { FOR }$ clause of the GRANT command is used to specify the object to which the privilege applies. _________________________

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

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

Which command will grant a system privilege to a user?

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?

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

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

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 SQL statements will grant the SELECT privilege for the ORDERS table to all database users?

The WITH GRANT OPTION is required to allow a user to grant the specified object privileges to other users.

The GRANT clause of the GRANT command identifies the user who is granting a specific privilege.

Permissions allow users to execute certain SQL statements in Oracle11g.

Which of the following commands is valid?

A password cannot be assigned to a role, only to a user.

____________________ privileges allow users to execute specific DML commands.

If a user is granted system and object privileges, then subsequently grants those privileges to other users, what happens to the recipients if all of the original user's privileges are revoked?

A user can be assigned a default role that is automatically enabled whenever the user logs in to the database.

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

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

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

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

The FOR‾\underline { FOR }FOR​ clause of the GRANT command is used to specify the object to which the privilege applies. _________________________

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

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

Which command will grant a system privilege to a user?

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?

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

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

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 { FOR }$ clause of the GRANT command is used to specify the object to which the privilege applies. _________________________