Question 1

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 2

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 3

Which of the following SQL statements will allow a user to enable the DBA role?

Accepted Answer

A)  ENABLE dba; 
B)  SET ROLE dba; 
C)  SET dba; 
D)  none of the above 
A)  ENABLE dba; 
B)  SET ROLE dba; 
C)  SET dba; 
D)  none of the above

Question 4

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 5

When revoking an object privilege that was issued with the WITH GRANT OPTION, the action will have a cascading effect because if that user granted the privilege to other users, the privilege will be revoked from them also.

Accepted Answer

A) True 
 B)False

Question 6

$\underline { \text { Privileges } }$ allow Oracle11g users to execute certain SQL statements. _________________________

Accepted Answer

A) True 
 B)False

Question 7

The $\underline {  \text { WITH ADMIN OPTION }  }$ is required to enable the user to grant the specified object privileges to other users. _________________________

Accepted Answer

A) True 
 B)False

Question 8

The GRANT ROLE command is used to grant roles to users.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

A user can have several $\underline {\text { roles } }$enabled at the same time. _________________________

Accepted Answer

A) True 
 B)False

Question 11

The $\underline {\text { REVOKE }}$ command can be used to revoke a role from a user or another role. _________________________

Accepted Answer

A) True 
 B)False

Question 12

Which of the following can be considered potential threats to an organization's data?

Accepted Answer

A)  natural disaster 
B)  disgruntled employees 
C)  computer criminals 
D)  all of the above 
A)  natural disaster 
B)  disgruntled employees 
C)  computer criminals 
D)  all of the above

Question 13

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 14

A(n) $\underline {\text { group } }$ is a collection of privileges that can be granted to users. _________________________

Accepted Answer

A) True 
 B)False

Question 15

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 16

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

Accepted Answer

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

Question 17

____________________ privileges allow users to execute specific DDL commands.

Accepted Answer

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

Question 18

The system privileges available in Oracle11g can be viewed through the SYSTEM_PRIVILEGE_MAP data dictionary view.

Accepted Answer

A) True 
 B)False

Question 19

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

The ____ privilege will allow a user to connect to the Oracle11g 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

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

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

Which of the following SQL statements will allow a user to enable the DBA role?

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

When revoking an object privilege that was issued with the WITH GRANT OPTION, the action will have a cascading effect because if that user granted the privilege to other users, the privilege will be revoked from them also.

$\underline { \text { Privileges } }$ allow Oracle11g users to execute certain SQL statements. _________________________

The $\underline { \text { WITH ADMIN OPTION } }$ is required to enable the user to grant the specified object privileges to other users. _________________________

The GRANT ROLE command is used to grant roles to users.

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

A user can have several $\underline {\text { roles } }$ enabled at the same time. _________________________

The $\underline {\text { REVOKE }}$ command can be used to revoke a role from a user or another role. _________________________

Which of the following can be considered potential threats to an organization's data?

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

A(n) $\underline {\text { group } }$ is a collection of privileges that can be granted to users. _________________________

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

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

____________________ privileges allow users to execute specific DDL commands.

The system privileges available in Oracle11g can be viewed through the SYSTEM_PRIVILEGE_MAP data dictionary view.

Which of the following statements about privileges is incorrect?

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

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

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

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

Which of the following SQL statements will allow a user to enable the DBA role?

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

When revoking an object privilege that was issued with the WITH GRANT OPTION, the action will have a cascading effect because if that user granted the privilege to other users, the privilege will be revoked from them also.

Privileges ‾\underline { \text { Privileges } } Privileges ​ allow Oracle11g users to execute certain SQL statements. _________________________

The WITH ADMIN OPTION ‾\underline { \text { WITH ADMIN OPTION } } WITH ADMIN OPTION ​ is required to enable the user to grant the specified object privileges to other users. _________________________

The GRANT ROLE command is used to grant roles to users.

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

A user can have several roles ‾\underline {\text { roles } } roles ​ enabled at the same time. _________________________

The REVOKE ‾\underline {\text { REVOKE }} REVOKE ​ command can be used to revoke a role from a user or another role. _________________________

Which of the following can be considered potential threats to an organization's data?

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

A(n) group ‾\underline {\text { group } } group ​ is a collection of privileges that can be granted to users. _________________________

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

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

____________________ privileges allow users to execute specific DDL commands.

The system privileges available in Oracle11g can be viewed through the SYSTEM_PRIVILEGE_MAP data dictionary view.

Which of the following statements about privileges is incorrect?

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

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

$\underline { \text { Privileges } }$ allow Oracle11g users to execute certain SQL statements. _________________________

The $\underline { \text { WITH ADMIN OPTION } }$ is required to enable the user to grant the specified object privileges to other users. _________________________

A user can have several $\underline {\text { roles } }$ enabled at the same time. _________________________

The $\underline {\text { REVOKE }}$ command can be used to revoke a role from a user or another role. _________________________

A(n) $\underline {\text { group } }$ is a collection of privileges that can be granted to users. _________________________