单项选择题
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.
相关考题
-
单项选择题
Byusingthetransactionidentifierprovidedby()foraparticularrowchange,youcanusetheFlashbackTransactionQuerytoseetheoperationperformedbythetransaction.
A. Flashback Table
B. Flashback Database
C. Flashback Version Query
D. The RMAN REPORT command
E. The DBA_PENDING_TRANSACTIONS view -
单项选择题
WhateffectshouldthelossofanindextablespacehaveonanOracleinstancethatisrunning?()
A. instance hangs
B. instance gets aborted
C. instance continues running
D. instance gets restarted automatically -
单项选择题
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
