User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? ()(Choose four.)
You want to enable the user, Scott, to change to the GRP1 consumer group by issuing the following code:
SQL> EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP
(’SCOTT’, ’GRP1’, FALSE);
How will you grant the switch privilege to the user, Scott?()
You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command:
You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT's segments.What would you do to achieve this?()
Do you want to pay cash or sign the bill?这句话意思是()。
The DBA issues this SQL command:
CREATE USER scott
IDENTIFIES by tiger;
What privileges does the user Scott have at this point? ()
You executed the following command to drop a user:
DROP USER scott CASCADE;
Which two statements regarding the above command are correct?()
免费的网站请分享给朋友吧