单项选择题
You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan？（）
A. assign users to consumer groups
B. set the resource plan for the instance
C. configure a simple resource plan and specify plan directives
D. configure a complex resource plan and specify plan directives
相关考题
-
单项选择题
Whilesettingupthethresholdfortablespacespaceusagemetricsforoneofyourtablespaces，youdefinethecriticalthresholdas60%andwarningthresholdas75%.Whatwouldbetheresultofthissetting？（）
A. It would result in an error because the warning threshold cannot be more than the critical threshold.
B. The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.
C. The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.
D. Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values. -
单项选择题
Manually，yousettheconsumergroupofallofthenewlycreateduserstoMYDB_GRP.Youwanttheuserstobeabletochangetheirconsumergroupsaspertheapplicationrequirement.Whatwasthefirststepthatwasneededintheprocesstoachievethisobjective？（）
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
