Question 1

The CONNECT role in past versions of Oracle had many powerful privileges granted to it.

Accepted Answer

A) True 
 B)False

Question 2

Most privileges are given to specific users or ____________________.

Accepted Answer

The answer of Most privileges are given to specific users...

Question 3

A ____ is an object based on another object,for example an object type that is based on another object type.

Accepted Answer

A)  derivated object 
B)  subobject 
C)  child object 
D)  template-based object 
A)  derivated object 
B)  subobject 
C)  child object 
D)  template-based object

Question 4

You can use the AUDIT command to set up object auditing for any object you own.Otherwise,you must have the ____ privilege to audit objects.

Accepted Answer

A)  AUDIT ALL 
B)  AUDIT OBJECTS 
C)  AUDIT ANY 
D)  AUDIT SYSTEM 
A)  AUDIT ALL 
B)  AUDIT OBJECTS 
C)  AUDIT ANY 
D)  AUDIT SYSTEM

Question 5

The default quota on all tablespaces for a user is zero unless you grant the RESOURCE role or the UNLIMITED TABLESPACE system privilege to the user.

Accepted Answer

A) True 
 B)False

Question 6

One of the user naming restrictions in Oracle is that a user name cannot be identical to a keyword,such as TABLE or INDEX.

Accepted Answer

A) True 
 B)False

Question 7

A role can be removed from the database by running the ____________________ command.

Accepted Answer

The answer of A role can be removed from the...

Question 8

The privileges of querying most data dictionary views that begin with ____________________ have been given to all users by Oracle by default.

Accepted Answer

The answer of The privileges of querying most data dictionary...

Question 9

Monitoring activity in a database is called ____.

Accepted Answer

A)  auditing 
B)  monitoring 
C)  logging 
D)  managing 
A)  auditing 
B)  monitoring 
C)  logging 
D)  managing

Question 10

USER_TAB_PRIVS_MADE lists privileges for tables but not other types of objects.

Accepted Answer

A) True 
 B)False

Question 11

Oracle recommends that you create your own roles instead of using the CONNECT,RESOURCE,an DBA roles,because these three roles will be dropped in a future release.

Accepted Answer

A) True 
 B)False

Question 12

You can modify the DEFAULT profile in the same way you modify profiles that you create,but you cannot drop the DEFAULT profile.

Accepted Answer

A) True 
 B)False

Question 13

You can check the system privileges for the STUDENTA and STUDENTB users by typing and executing the following query:
SELECT * FROM DBA_SYS_PRIVS
WHERE GRANTEE LIKE ____;

Accepted Answer

A)  'STUDENT*' 
B)  'STUDENT?' 
C)  'STUDENT.' 
D)  'STUDENT%' 
A)  'STUDENT*' 
B)  'STUDENT?' 
C)  'STUDENT.' 
D)  'STUDENT%'

Question 14

The Enterprise Manager console's ____ Manager can be used to create and manage roles very easily.

Accepted Answer

A)  Role 
B)  Privilege 
C)  Security 
D)  User 
A)  Role 
B)  Privilege 
C)  Security 
D)  User

Question 15

When you ____________________ a privilege,you take away the privilege.

Accepted Answer

The answer of When you ____________________ a privilege,you take away...

Question 16

Each user can be assigned one or more profiles at a time.

Accepted Answer

A) True 
 B)False

Question 17

After a user has a role,you cannot add more privileges to the role.

Accepted Answer

A) True 
 B)False

Question 18

When you change a user's quota in a tablespace,what happens to the tables that the user has already created in the tablespace?

Accepted Answer

If you increase the quota,nothing happen

Question 19

The ____________________ privilege is usually reserved for the DBA,allowing him or her to create a table in any schema.

Accepted Answer

The answer of The ____________________ privilege is usually reserved for...

Question 20

The ____ data dictionary view contains all object privileges granted.

Accepted Answer

A)  DBA_SYS_PRIVS 
B)  DBA_OBJ_PRIVS 
C)  DBA_OBJ_PRIVS_MADE 
D)  DBA_TAB_PRIVS 
A)  DBA_SYS_PRIVS 
B)  DBA_OBJ_PRIVS 
C)  DBA_OBJ_PRIVS_MADE 
D)  DBA_TAB_PRIVS

The CONNECT role in past versions of Oracle had many powerful privileges granted to it.

Most privileges are given to specific users or ____________________.

A ____ is an object based on another object,for example an object type that is based on another object type.

You can use the AUDIT command to set up object auditing for any object you own.Otherwise,you must have the ____ privilege to audit objects.

The default quota on all tablespaces for a user is zero unless you grant the RESOURCE role or the UNLIMITED TABLESPACE system privilege to the user.

One of the user naming restrictions in Oracle is that a user name cannot be identical to a keyword,such as TABLE or INDEX.

A role can be removed from the database by running the ____________________ command.

The privileges of querying most data dictionary views that begin with ____________________ have been given to all users by Oracle by default.

Monitoring activity in a database is called ____.

USER_TAB_PRIVS_MADE lists privileges for tables but not other types of objects.

Oracle recommends that you create your own roles instead of using the CONNECT,RESOURCE,an DBA roles,because these three roles will be dropped in a future release.

You can modify the DEFAULT profile in the same way you modify profiles that you create,but you cannot drop the DEFAULT profile.

You can check the system privileges for the STUDENTA and STUDENTB users by typing and executing the following query: SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE LIKE ____;

The Enterprise Manager console's ____ Manager can be used to create and manage roles very easily.

When you ____________________ a privilege,you take away the privilege.

Each user can be assigned one or more profiles at a time.

After a user has a role,you cannot add more privileges to the role.

When you change a user's quota in a tablespace,what happens to the tables that the user has already created in the tablespace?

The ____________________ privilege is usually reserved for the DBA,allowing him or her to create a table in any schema.

The ____ data dictionary view contains all object privileges granted.

Oracle Architecture Overview

Tools and Architecture

Creating an Oracle Instance

Oracle Physical Architecture and Data Dictionary Views

Basic Storage Concepts and Settings

The Basics of Querying a Database

Basic Table Management

Advanced Table Management

Constraints, indexes, and Other Specialized Objects

Basic Data Management

Advanced Data Management

Performance Monitoring

Proactive Maintenance

Backup and Recovery

Filters

Exam 12: Security Management

The CONNECT role in past versions of Oracle had many powerful privileges granted to it.

Most privileges are given to specific users or ____________________.

A ____ is an object based on another object,for example an object type that is based on another object type.

You can use the AUDIT command to set up object auditing for any object you own.Otherwise,you must have the ____ privilege to audit objects.

The default quota on all tablespaces for a user is zero unless you grant the RESOURCE role or the UNLIMITED TABLESPACE system privilege to the user.

One of the user naming restrictions in Oracle is that a user name cannot be identical to a keyword,such as TABLE or INDEX.

A role can be removed from the database by running the ____________________ command.

The privileges of querying most data dictionary views that begin with ____________________ have been given to all users by Oracle by default.

Monitoring activity in a database is called ____.

USER_TAB_PRIVS_MADE lists privileges for tables but not other types of objects.

Oracle recommends that you create your own roles instead of using the CONNECT,RESOURCE,an DBA roles,because these three roles will be dropped in a future release.

You can modify the DEFAULT profile in the same way you modify profiles that you create,but you cannot drop the DEFAULT profile.

You can check the system privileges for the STUDENTA and STUDENTB users by typing and executing the following query: SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE LIKE ____;

The Enterprise Manager console's ____ Manager can be used to create and manage roles very easily.

When you ____________________ a privilege,you take away the privilege.

Each user can be assigned one or more profiles at a time.

After a user has a role,you cannot add more privileges to the role.

When you change a user's quota in a tablespace,what happens to the tables that the user has already created in the tablespace?

The ____________________ privilege is usually reserved for the DBA,allowing him or her to create a table in any schema.

The ____ data dictionary view contains all object privileges granted.

Oracle Architecture Overview

Tools and Architecture

Creating an Oracle Instance

Oracle Physical Architecture and Data Dictionary Views

Basic Storage Concepts and Settings

The Basics of Querying a Database

Basic Table Management

Advanced Table Management

Constraints, indexes, and Other Specialized Objects

Basic Data Management

Advanced Data Management

Performance Monitoring

Proactive Maintenance

Backup and Recovery

Filters