The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement: SQL>ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’; What will be the outcome of this statement?()
A The statement will deactivate DAY_PLAN.
B The statement will activate DAY_PLAN as the top plan.
C The statement will activate MANAGERS_PLAN as the top plan.
D The statement will return an error because MANAGERS_PLAN is not the top plan.
正确答案
答案解析
相似试题
(单选题)
What is the maximum database block size supported for the Oracle9i database?()
(单选题)
For which database operation would you need the database to be in the MOUNT state()
(单选题)
What does the minimize load database parameter mean when backing up a database?()
(单选题)
Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs?()
(多选题)
Which two database operations can be performed at the MOUNT stage of database startup?()
(单选题)
you can perform an active database duplication when the database is in NOARCHIVELOG mode.()
(单选题)
The()writes the Flashback Database logs in the flash recovery area.
(单选题)
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()
(多选题)
What are the prerequisites for enabling Flashback Database? ()
(单选题)
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database?()