Question 1

There are ____ resources you can limit with a profile.

Accepted Answer

A)  six 
B)  seven 
C)  eight 
D)  nine 
A)  six 
B)  seven 
C)  eight 
D)  nine D

Question 2

The ____ user is created to own functions,packages,views,and objects related to Oracle Spatial.

Accepted Answer

A)  SYS 
B)  SYSTEM 
C)  MDSYS 
D)  DBA 
A)  SYS 
B)  SYSTEM 
C)  MDSYS 
D)  DBA C

Question 3

What are the two types of users that can be created? What command is used to create users?

Accepted Answer

The two types of users (those who own tables and other objects and those who use tables and objects owned by other users)are created with the same command: the CREATE USER command.
After creating users to own the business tables,you need to create users who access these tables,but don't need to create any tables of their own.These are the users that the term end-user fits best: the people who use the tables created to support their business functions by adding,changing,removing,and viewing data.You can control how often the user's password expires and what resources are available to these kinds of users.

Question 4

You can grant the ____ to either a role or a user.This allows the user to grant that role to other users or roles.

Accepted Answer

A)  WITH ADMIN OPTION 
B)  NOT IDENTIFIED 
C)  IDENTIFIED BY 
D)  GRANT 
A)  WITH ADMIN OPTION 
B)  NOT IDENTIFIED 
C)  IDENTIFIED BY 
D)  GRANT

Question 5

There are ____ types of privileges that you can assign in the Oracle 10g database.

Accepted Answer

A)  two 
B)  three 
C)  four 
D)  five 
A)  two 
B)  three 
C)  four 
D)  five

Question 6

It is recommended that you assign the SYSTEM or SYSAUX tablespaces as the default tablespace for new users.

Accepted Answer

A) True 
 B)False

Question 7

As a user,your activity in the database is stopped if you reach a limit on a resource set in your profile.

Accepted Answer

A) True 
 B)False

Question 8

To view the resource settings for the system,you should type and run this query: ____.

Accepted Answer

A)  SELECT * FROM RESOURCES; 
B)  SELECT * FROM RESOURCE_SETTING; 
C)  SELECT * FROM RESOURCE_SETTINGS; 
D)  SELECT * FROM RESOURCE_COST; 
A)  SELECT * FROM RESOURCES; 
B)  SELECT * FROM RESOURCE_SETTING; 
C)  SELECT * FROM RESOURCE_SETTINGS; 
D)  SELECT * FROM RESOURCE_COST;

Question 9

Users identified externally do not have to supply their user names or passwords to log on;they simply type a(n)____ in place of user name and password.

Accepted Answer

A)  * 
B)  - 
C)  / 
D)  \ 
A)  * 
B)  - 
C)  / 
D)  \

Question 10

Auditing commands have no effect until you set the ____________________ initialization parameter.

Accepted Answer

The answer of Auditing commands have no effect until you...

Question 11

How can you turn off auditing?

Accepted Answer

You may want to turn off auditing or cha

Question 12

If a user has created other users,those users are not dropped when the creating user is dropped.

Accepted Answer

A) True 
 B)False

Question 13

A(n)____ is a single task sent to the database,such as parsing a new SQL statement or executing a query.

Accepted Answer

A)  call 
B)  command 
C)  execution 
D)  event 
A)  call 
B)  command 
C)  execution 
D)  event

Question 14

The SYSDBA privilege allows the user to start up and shut down the database and to create a(n)____________________ (system initialization parameter file).

Accepted Answer

The answer of The SYSDBA privilege allows the user to...

Question 15

The DBA user does not usually have to be assigned object privileges.

Accepted Answer

A) True 
 B)False

Question 16

The ____ object privilege allows you to call the function,procedure,or package while running an SQL query or other command.

Accepted Answer

A)  FLASHBACK 
B)  SELECT 
C)  EXECUTE 
D)  RUN 
A)  FLASHBACK 
B)  SELECT 
C)  EXECUTE 
D)  RUN

Question 17

____ shows privileges belonging to the current user.

Accepted Answer

A)  USER_PRIVILEGES 
B)  USER_PRIVS 
C)  USER_SYS_PRIVS 
D)  USER_OBJ_PRIVS 
A)  USER_PRIVILEGES 
B)  USER_PRIVS 
C)  USER_SYS_PRIVS 
D)  USER_OBJ_PRIVS

Question 18

You need the BACKUP ANY TABLE privilege to perform an operating system backup of Oracle files.

Accepted Answer

A) True 
 B)False

Question 19

The ____________________ privilege is the same as SYSDBA,except it does not include the ability to create a database.

Accepted Answer

The answer of The ____________________ privilege is the same as...

Question 20

Should you set a quota when creating a user? If so,should you set it to a high or low value?

Accepted Answer

The default quota (the maximum amount of

There are ____ resources you can limit with a profile.

The ____ user is created to own functions,packages,views,and objects related to Oracle Spatial.

What are the two types of users that can be created? What command is used to create users?

You can grant the ____ to either a role or a user.This allows the user to grant that role to other users or roles.

There are ____ types of privileges that you can assign in the Oracle 10g database.

It is recommended that you assign the SYSTEM or SYSAUX tablespaces as the default tablespace for new users.

As a user,your activity in the database is stopped if you reach a limit on a resource set in your profile.

To view the resource settings for the system,you should type and run this query: ____.

Users identified externally do not have to supply their user names or passwords to log on;they simply type a(n)____ in place of user name and password.

Auditing commands have no effect until you set the ____________________ initialization parameter.

How can you turn off auditing?

If a user has created other users,those users are not dropped when the creating user is dropped.

A(n)____ is a single task sent to the database,such as parsing a new SQL statement or executing a query.

The SYSDBA privilege allows the user to start up and shut down the database and to create a(n)____________________ (system initialization parameter file).

The DBA user does not usually have to be assigned object privileges.

The ____ object privilege allows you to call the function,procedure,or package while running an SQL query or other command.

____ shows privileges belonging to the current user.

You need the BACKUP ANY TABLE privilege to perform an operating system backup of Oracle files.

The ____________________ privilege is the same as SYSDBA,except it does not include the ability to create a database.

Should you set a quota when creating a user? If so,should you set it to a high or low value?

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

There are ____ resources you can limit with a profile.

The ____ user is created to own functions,packages,views,and objects related to Oracle Spatial.

What are the two types of users that can be created? What command is used to create users?

You can grant the ____ to either a role or a user.This allows the user to grant that role to other users or roles.

There are ____ types of privileges that you can assign in the Oracle 10g database.

It is recommended that you assign the SYSTEM or SYSAUX tablespaces as the default tablespace for new users.

As a user,your activity in the database is stopped if you reach a limit on a resource set in your profile.

To view the resource settings for the system,you should type and run this query: ____.

Users identified externally do not have to supply their user names or passwords to log on;they simply type a(n)____ in place of user name and password.

Auditing commands have no effect until you set the ____________________ initialization parameter.

How can you turn off auditing?

If a user has created other users,those users are not dropped when the creating user is dropped.

A(n)____ is a single task sent to the database,such as parsing a new SQL statement or executing a query.

The SYSDBA privilege allows the user to start up and shut down the database and to create a(n)____________________ (system initialization parameter file).

The DBA user does not usually have to be assigned object privileges.

The ____ object privilege allows you to call the function,procedure,or package while running an SQL query or other command.

____ shows privileges belonging to the current user.

You need the BACKUP ANY TABLE privilege to perform an operating system backup of Oracle files.

The ____________________ privilege is the same as SYSDBA,except it does not include the ability to create a database.

Should you set a quota when creating a user? If so,should you set it to a high or low value?

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