Question 1

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)   \E) A) and B)
F) All of the above

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)   DBAE) A) and B)
F) A) and C) C

Question 3

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...

Question 4

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 5

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;E) A) and B)
F) B) and D)

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

There are ____ resources you can limit with a profile.

Accepted Answer

A)   six
B)   seven
C)   eight
D)   nineE) A) and C)
F) A) and B) D

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

____ shows privileges belonging to the current user.

Accepted Answer

A)   USER_PRIVILEGES
B)   USER_PRIVS
C)   USER_SYS_PRIVS
D)   USER_OBJ_PRIVSE) All of the above
F) C) and D)

Question 10

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 11

How can you turn off auditing?

Accepted Answer

You may want to turn off auditing or cha...

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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)   RUNE) B) and C)
F) A) and C)

Question 14

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 15

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

Accepted Answer

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

Question 16

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)   GRANTE) B) and D)
F) A) and C)

Question 17

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 18

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)   eventE) C) and D)
F) All of the above

Question 19

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

Accepted Answer

A)   two
B)   three
C)   four
D)   fiveE) B) and C)
F) A) and D)

Question 20

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...

Exam 12: Security Management

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.

Correct Answer
verified

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

Correct Answer
verified
C

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

Correct Answer
verified
The default quota (the maximum amount of...
View Answer

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

There are ____ resources you can limit with a profile.

Correct Answer
verified
D

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

Correct Answer
verified

____ shows privileges belonging to the current user.

Correct Answer
verified

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

Correct Answer
verified

How can you turn off auditing?

Correct Answer
verified
You may want to turn off auditing or cha...
View Answer

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Exam 12: Security Management

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedC

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

Correct AnswerverifiedThe default quota (the maximum amount of...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

There are ____ resources you can limit with a profile.

Correct AnswerverifiedD

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

Correct AnswerverifiedShow Answer

____ shows privileges belonging to the current user.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

How can you turn off auditing?

Correct AnswerverifiedYou may want to turn off auditing or cha...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified
The default quota (the maximum amount of...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
You may want to turn off auditing or cha...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified