OCP CBT Question 680

Please solve the following question.

Examine the following commands executed by a DBA: ```sql BEGIN DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA(); DBMS_RESOURCE_MANAGER.CREATE_PLAN('MY_PLAN', 'My Test Plan'); DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP('OLTP_GROUP', 'OLTP Users'); DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE( PLAN => 'MY_PLAN', GROUP_OR_SUBPLAN => 'OLTP_GROUP', MGMT_PERCENT => 80); DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE( PLAN => 'MY_PLAN', GROUP_OR_SUBPLAN => 'OTHER_GROUPS', MGMT_PERCENT => 20); DBMS_RESOURCE_MANAGER.VALIDATE_PENDING_AREA(); DBMS_RESOURCE_MANAGER.SUBMIT_PENDING_AREA(); END; / ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = 'MY_PLAN'; ``` What will be the outcome after these commands are successfully executed?

All sessions will immediately be assigned to either OLTP_GROUP or OTHER_GROUPS based on their current activity.

The MY_PLAN resource plan will become the active plan, and sessions will be mapped to consumer groups based on existing mapping rules or default behavior.

The MY_PLAN resource plan will be created, but it will not be active until the database is restarted.

The commands will fail because SYS_GROUP is not explicitly included in the plan directives.