Manually， you set th...

单项选择题Manually， you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective？（）

A. The user must have been granted the DBA role.
B. The user must have been granted the switch privilege as a part of a role.
C. The user must have been granted the Resource Manager administrator privilege.
D. The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题By using the transaction identifier provided by（）for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction.

A. Flashback Table
B. Flashback Database
C. Flashback Version Query
D. The RMAN REPORT command
E. The DBA_PENDING_TRANSACTIONS view

点击查看答案

2.单项选择题What effect should the loss of an index tablespace have on an Oracle instance that is running？（）

A. instance hangs
B. instance gets aborted
C. instance continues running
D. instance gets restarted automatically

点击查看答案

3.单项选择题 Why would you use the following FLASHBACK TABLE command？（）
FLASHBACK TABLE emp TO TIMESTAMP （’11：45’.’hh12：mi’）；

A. to undo the changes made to the EMP table since the specified time
B. to restore the EMP table that was wrongly dropped from the database
C. to view the transactions that have modified the EMP table since the specified time
D. to view the changes made to the EMP table for one or more rows since the specified time

点击查看答案

4.多项选择题In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）

A. the V$LOG view
B. the V$DBFILE view
C. the V$LOGFILE view
D. the V$INSTANCE_RECOVERY view
E. Oracle Enterprise Manager Database Control

点击查看答案

5.多项选择题You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）

A. ONLINE
B. REVERSE
C. PARALLEL
D. COMPRESS
E. NOLOGGING
F. COMPUTE STATISTICS

点击查看答案

6.单项选择题 You want to create a consumer group， GROUP1， and you execute the following command in the command-line interface：
SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =>’group1’， COMMENT => ’New Group’）；
This command errorsout displaying the following message：
ERROR at line 1：
ORA-01031： insufficient privileges
ORA-06512： at "SYS.DBMS_RMIN"， line 115
ORA-06512： at SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA-06512： at line 1
What action would you take to overcome this error？（）

A. grant SYSDBA to the user
B. grant SYSOPER to the user
C. grant the RESOURCE role to the user
D. use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the use
E. grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package

点击查看答案

7.多项选择题Which two statements are correct regarding the Oracle Flashback Drop feature？（）

A. Recycle bin exists for the tables only in non-SYSTEM， locally managed tablespaces.
B. You can flash back a dropped table provided row movement has been enabled on the table.
C. If you drop an index before dropping its associated table， then the recovery of the index is not supported when you flash back the dropped table.
D. When you execute the DROP TABLESPACE？ INCLUDING CONTENTS command， the objects in the tablespace are places in the recycle bin.
E. When a dropped table is moved to the recycle bin， only the table is renamed to a system-generated name； its associated objects and constraints are not renamed.
F. If you drop a table that is protected by the recycle bin， then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.

点击查看答案

8.单项选择题You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？（）

A. flash back the database
B. import the temporary tablespace from the last export
C. restore all the data files and temporary files from the last full database backup and perform a recovery
D. not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace

点击查看答案

9.多项选择题 These are the details about V$FLASHBACK_DATABASE_STAT： SQL> DESC v$FLASHBACK_DATABASE_STAT
Name Null？ Type
------------- -------- --------------
BEGIN_TIME DATE
END_TIME DATE
FLASHBACK_DATA NUMBER
DB_DATA NUMBER
REDO_DATA NUMBER
ESTIMATED_FLASHBACK_SIZE NUMBER
Which two statements regarding the V$FLASHBACK_DATABASE_STATview aretrue？（）

A. BEGIN_TIME is the time at which Flashback logging is enabled.
B. END_TIME is the time at which the query is executed on the view.
C. REDO_DATA is the number of bytes of redo data written during the interval.
D. This view contains information about flashback data pertaining to the last 24 hours.
E. FLASHBACK_DATA is the amount of flashback data generated since the database was opened.

点击查看答案

10.单项选择题You were recently hired by Certkiller .com as a database administrator. You are asked to find out whether the currently functional listener process， named L1， has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task？（）

A. by using the STATUS command of the Listener control utility
B. by using the STATUS L1 command of the Listener control utility
C. by using the SHOW RULES command of the Listener control utility
D. by using the SET PASSWORD command of the Listener control utility
E. by searching for the PASSWORD_LISTENER entry in the listener.ora file

点击查看答案