Question 1

To be able to connect to Oracle11g, the user must have the ____________________ privilege.

Accepted Answer

CREATE SESSION

Question 2

What are the differences between object and system privileges?

Accepted Answer

An object privilege allows DML operations on a specific database object while a system privilege usually focuses on DDL operations or DML operations on a specific type of object.

Question 3

Even if a password has been assigned, a user is not required to enter a password for a role that has been set as the ____________________ role for that user.

Accepted Answer

default

Question 4

The ____________________ command is used to remove a user account from the Oracle10g database.

Accepted Answer

The answer of The ____________________ command is used to remove...

Question 5

Partial list of privileges
  
-Which of the following SQL statements would most likely be used to generate the partial output shown above?

Accepted Answer

A)  SELECT name FROM SYSTEM_PRIVILEGE_MAP; 
B)  SELECT * FROM USER_CURRENT_PRIVILEGES; 
C)  SELECT * FROM SESSION_PRIVS; 
D)  SELECT name FROM SESSION_PRIVS; 
A)  SELECT name FROM SYSTEM_PRIVILEGE_MAP; 
B)  SELECT * FROM USER_CURRENT_PRIVILEGES; 
C)  SELECT * FROM SESSION_PRIVS; 
D)  SELECT name FROM SESSION_PRIVS;

Question 6

The $\underline {\text { CHANGE PASSWORD }}$ option can be used to force a user to change the user password at the time of the next login. _________________________

Accepted Answer

A) True 
 B)False

Question 7

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 8

The PASSWORD EXPIRE option can be used to force a user to change his or her password at the time of the next login.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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

Question 10

Authentication is the process of ensuring that the individuals trying to access the system are who they claim to be.

Accepted Answer

A) True 
 B)False

Question 11

User names can consist of up to$\underline { 30 }$ characters and include the _, #, and $ symbols. _________________________

Accepted Answer

A) True 
 B)False

Question 12

Which of the following commands is used to establish a user account?

Accepted Answer

A)  CREATE NEW USER username IDENTIFIED BY password; 
B)  CREATE USERNAME username IDENTITY password; 
C)  CREATE USER username PASSWORD password; 
D)  CREATE USER username IDENTIFIED BY password; 
A)  CREATE NEW USER username IDENTIFIED BY password; 
B)  CREATE USERNAME username IDENTITY password; 
C)  CREATE USER username PASSWORD password; 
D)  CREATE USER username IDENTIFIED BY password;

Question 13

The ____________________ clause of the GRANT command specifies the user(s) or role(s) receiving the privilege.

Accepted Answer

The answer of The ____________________ clause of the GRANT command...

Question 14

A role can be removed from the database with the $\underline {\text { DELETE ROLE } }$ command. _________________________

Accepted Answer

A) True 
 B)False

Question 15

All privileges enabled for the current user can be queried from the ____________________ data dictionary view.

Accepted Answer

The answer of All privileges enabled for the current user...

Question 16

The ____ keywords are used to grant object privileges to users and roles.

Accepted Answer

A)  GRANT...FOR...TO 
B)  CREATE...WITH...TO 
C)  GRANT...WITH...TO 
D)  GRANT...ON...TO 
A)  GRANT...FOR...TO 
B)  CREATE...WITH...TO 
C)  GRANT...WITH...TO 
D)  GRANT...ON...TO

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Which of the following SQL commands will require the user RTHOMAS to change the account password the next time the database is accessed?

Accepted Answer

A)  ALTER USER rthomas PASSWORD EXPIRE ; 
B)  ALTER USER rthomas CHANGE PASSWORD; 
C)  ALTER USER rthomas UPDATE PASSWORD; 
D)  ALTER USER rthomas EXPIRE PASSWORD; 
A)  ALTER USER rthomas PASSWORD EXPIRE ; 
B)  ALTER USER rthomas CHANGE PASSWORD; 
C)  ALTER USER rthomas UPDATE PASSWORD; 
D)  ALTER USER rthomas EXPIRE PASSWORD;

Question 19

A role that is no longer needed by any users can be removed from the database using the ____________________ command.

Accepted Answer

The answer of A role that is no longer needed...

Question 20

Which of the following will revoke a user's object privileges?

Accepted Answer

A)  REVOKE objectprivilege ON OBJECT objectname FROM username; 
B)  REVOKE objectprivilege ON objectname FROM username; 
C)  REVOKE objectprivilege ON objectname FOR username; 
D)  DROP objectprivilege ON objectname FROM username; 
A)  REVOKE objectprivilege ON OBJECT objectname FROM username; 
B)  REVOKE objectprivilege ON objectname FROM username; 
C)  REVOKE objectprivilege ON objectname FOR username; 
D)  DROP objectprivilege ON objectname FROM username;

To be able to connect to Oracle11g, the user must have the ____________________ privilege.

What are the differences between object and system privileges?

Even if a password has been assigned, a user is not required to enter a password for a role that has been set as the ____________________ role for that user.

The ____________________ command is used to remove a user account from the Oracle10g database.

Partial list of privileges -Which of the following SQL statements would most likely be used to generate the partial output shown above?

The $\underline {\text { CHANGE PASSWORD }}$ option can be used to force a user to change the user password at the time of the next login. _________________________

Which command will establish a new role?

The PASSWORD EXPIRE option can be used to force a user to change his or her password at the time of the next login.

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

Authentication is the process of ensuring that the individuals trying to access the system are who they claim to be.

User names can consist of up to $\underline { 30 }$ characters and include the _, #, and $ symbols. _________________________

Which of the following commands is used to establish a user account?

The ____________________ clause of the GRANT command specifies the user(s) or role(s) receiving the privilege.

A role can be removed from the database with the $\underline {\text { DELETE ROLE } }$ command. _________________________

All privileges enabled for the current user can be queried from the ____________________ data dictionary view.

The ____ keywords are used to grant object privileges to users and roles.

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

Which of the following SQL commands will require the user RTHOMAS to change the account password the next time the database is accessed?

A role that is no longer needed by any users can be removed from the database using the ____________________ command.

Which of the following will revoke a user's object privileges?

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

To be able to connect to Oracle11g, the user must have the ____________________ privilege.

What are the differences between object and system privileges?

Even if a password has been assigned, a user is not required to enter a password for a role that has been set as the ____________________ role for that user.

The ____________________ command is used to remove a user account from the Oracle10g database.

Partial list of privileges -Which of the following SQL statements would most likely be used to generate the partial output shown above?

The CHANGE PASSWORD ‾\underline {\text { CHANGE PASSWORD }} CHANGE PASSWORD ​ option can be used to force a user to change the user password at the time of the next login. _________________________

Which command will establish a new role?

The PASSWORD EXPIRE option can be used to force a user to change his or her password at the time of the next login.

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

Authentication is the process of ensuring that the individuals trying to access the system are who they claim to be.

User names can consist of up to 30‾\underline { 30 }30​ characters and include the _, #, and $ symbols. _________________________

Which of the following commands is used to establish a user account?

The ____________________ clause of the GRANT command specifies the user(s) or role(s) receiving the privilege.

A role can be removed from the database with the DELETE ROLE ‾\underline {\text { DELETE ROLE } } DELETE ROLE ​ command. _________________________

All privileges enabled for the current user can be queried from the ____________________ data dictionary view.

The ____ keywords are used to grant object privileges to users and roles.

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

Which of the following SQL commands will require the user RTHOMAS to change the account password the next time the database is accessed?

A role that is no longer needed by any users can be removed from the database using the ____________________ command.

Which of the following will revoke a user's object privileges?

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 { CHANGE PASSWORD }}$ option can be used to force a user to change the user password at the time of the next login. _________________________

User names can consist of up to $\underline { 30 }$ characters and include the _, #, and $ symbols. _________________________

A role can be removed from the database with the $\underline {\text { DELETE ROLE } }$ command. _________________________