Question 1

Granting users limited ____________________ to access data is one security method used in Oracle11g.

Accepted Answer

The answer of Granting users limited ____________________ to access data...

Question 2

All available ____________________ privileges in Oracle10g can be displayed through the SYSTEM_PRIVILEGE_MAP data dictionary view.

Accepted Answer

The answer of All available ____________________ privileges in Oracle10g can...

Question 3

All available system privileges for the current user can be displayed through the USER_SYS_PRIVS data dictionary view.

Accepted Answer

A) True 
 B)False

Question 4

When revoking a privilege that was issued with the WITH $\underline {\text { ADMIN }}$ 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 5

The ____ command is used to revoke a role.

Accepted Answer

A)  REVOKE rolename FROM username; 
B)  ALTER rolename REVOKE username; 
C)  DROP rolename FROM username; 
D)  DROP rolename REVOKE FROM username; 
A)  REVOKE rolename FROM username; 
B)  ALTER rolename REVOKE username; 
C)  DROP rolename FROM username; 
D)  DROP rolename REVOKE FROM username;

Question 6

A system privilege can be taken away from a user through the $\underline { \text { UNGRANT } }$ command. _________________________

Accepted Answer

A) True 
 B)False

Question 7

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;

Question 8

Which command will delete a user account from Oracle11g?

Accepted Answer

A)  DELETE USER username; 
B)  DELETE USER username IDENTIFIED BY password; 
C)  DROP USER username IDENTIFIED BY password; 
D)  DROP USER username; 
A)  DELETE USER username; 
B)  DELETE USER username IDENTIFIED BY password; 
C)  DROP USER username IDENTIFIED BY password; 
D)  DROP USER username;

Question 9

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 10

Even if users are $\underline { \text { authenticated } }$by the operating system, the users are still required to have valid Oracle11g accounts to access the database. _________________________

Accepted Answer

A) True 
 B)False

Question 11

A user can query the $\underline {\text { ROLE SYS PRIVS }}$ data dictionary view to determine the privileges currently enabled for that user. _________________________

Accepted Answer

A) True 
 B)False

Question 12

All the Oracle11g system privileges can be viewed through the data dictionary view ____.

Accepted Answer

A)  USER_SYSTEM_PRIVILEGES 
B)  DISPLAY_SYSTEM_PRIVILEGES 
C)  SYSTEM_PRIVILEGE_MAP 
D)  none of the above 
A)  USER_SYSTEM_PRIVILEGES 
B)  DISPLAY_SYSTEM_PRIVILEGES 
C)  SYSTEM_PRIVILEGE_MAP 
D)  none of the above

Question 13

The $\underline {\text { REVOKE }}$ command can be used to revoke system and object privileges, but not both in the same command. _________________________

Accepted Answer

A) True 
 B)False

Question 14

If a user issues the ____________________ command to change his or her password, the user will be prompted for both the old and new password.

Accepted Answer

The answer of If a user issues the ____________________ command...

Question 15

Which of the following privileges will allow a user to reference a table when creating a FOREIGN KEY constraint?

Accepted Answer

A)  FOREIGN KEY 
B)  REFERENCES 
C)  SELECT 
D)  none of the above 
A)  FOREIGN KEY 
B)  REFERENCES 
C)  SELECT 
D)  none of the above

Question 16

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 17

The $\underline { \text { PASS IS }  }$ clause of the CREATE USER command indicates the password assigned to a user. _________________________

Accepted Answer

A) True 
 B)False

Question 18

The $\underline {\text { GENERATE ROLE } }$command is used to add a new role to the database. _________________________

Accepted Answer

A) True 
 B)False

Question 19

A role can only be granted to other roles.

Accepted Answer

A) True 
 B)False

Question 20

The UPDATE ANY TABLE privilege is a system privilege.

Accepted Answer

A) True 
 B)False

Granting users limited ____________________ to access data is one security method used in Oracle11g.

All available ____________________ privileges in Oracle10g can be displayed through the SYSTEM_PRIVILEGE_MAP data dictionary view.

All available system privileges for the current user can be displayed through the USER_SYS_PRIVS data dictionary view.

When revoking a privilege that was issued with the WITH $\underline {\text { ADMIN }}$ 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. _________________________

The ____ command is used to revoke a role.

A system privilege can be taken away from a user through the $\underline { \text { UNGRANT } }$ command. _________________________

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

Which command will delete a user account from Oracle11g?

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

Even if users are $\underline { \text { authenticated } }$ by the operating system, the users are still required to have valid Oracle11g accounts to access the database. _________________________

A user can query the $\underline {\text { ROLE SYS PRIVS }}$ data dictionary view to determine the privileges currently enabled for that user. _________________________

All the Oracle11g system privileges can be viewed through the data dictionary view ____.

The $\underline {\text { REVOKE }}$ command can be used to revoke system and object privileges, but not both in the same command. _________________________

If a user issues the ____________________ command to change his or her password, the user will be prompted for both the old and new password.

Which of the following privileges will allow a user to reference a table when creating a FOREIGN KEY constraint?

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 $\underline { \text { PASS IS } }$ clause of the CREATE USER command indicates the password assigned to a user. _________________________

The $\underline {\text { GENERATE ROLE } }$ command is used to add a new role to the database. _________________________

A role can only be granted to other roles.

The UPDATE ANY TABLE privilege is a system privilege.

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

Granting users limited ____________________ to access data is one security method used in Oracle11g.

All available ____________________ privileges in Oracle10g can be displayed through the SYSTEM_PRIVILEGE_MAP data dictionary view.

All available system privileges for the current user can be displayed through the USER_SYS_PRIVS data dictionary view.

When revoking a privilege that was issued with the WITH ADMIN ‾\underline {\text { ADMIN }} ADMIN ​ 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. _________________________

The ____ command is used to revoke a role.

A system privilege can be taken away from a user through the UNGRANT ‾\underline { \text { UNGRANT } } UNGRANT ​ command. _________________________

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

Which command will delete a user account from Oracle11g?

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

Even if users are authenticated ‾\underline { \text { authenticated } } authenticated ​ by the operating system, the users are still required to have valid Oracle11g accounts to access the database. _________________________

A user can query the ROLE SYS PRIVS ‾\underline {\text { ROLE SYS PRIVS }} ROLE SYS PRIVS ​ data dictionary view to determine the privileges currently enabled for that user. _________________________

All the Oracle11g system privileges can be viewed through the data dictionary view ____.

The REVOKE ‾\underline {\text { REVOKE }} REVOKE ​ command can be used to revoke system and object privileges, but not both in the same command. _________________________

If a user issues the ____________________ command to change his or her password, the user will be prompted for both the old and new password.

Which of the following privileges will allow a user to reference a table when creating a FOREIGN KEY constraint?

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 PASS IS ‾\underline { \text { PASS IS } } PASS IS ​ clause of the CREATE USER command indicates the password assigned to a user. _________________________

The GENERATE ROLE ‾\underline {\text { GENERATE ROLE } } GENERATE ROLE ​ command is used to add a new role to the database. _________________________

A role can only be granted to other roles.

The UPDATE ANY TABLE privilege is a system privilege.

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

When revoking a privilege that was issued with the WITH $\underline {\text { ADMIN }}$ 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. _________________________

A system privilege can be taken away from a user through the $\underline { \text { UNGRANT } }$ command. _________________________

Even if users are $\underline { \text { authenticated } }$ by the operating system, the users are still required to have valid Oracle11g accounts to access the database. _________________________

A user can query the $\underline {\text { ROLE SYS PRIVS }}$ data dictionary view to determine the privileges currently enabled for that user. _________________________

The $\underline {\text { REVOKE }}$ command can be used to revoke system and object privileges, but not both in the same command. _________________________

The $\underline { \text { PASS IS } }$ clause of the CREATE USER command indicates the password assigned to a user. _________________________

The $\underline {\text { GENERATE ROLE } }$ command is used to add a new role to the database. _________________________