Oracle Database 12c 1z0-067 Updated Exam

View the Exhibit showing steps to create a database resource manager plan.

SQL>executedbms_resource_manager.create_pendingarea();

PL/SQLproceduresuccessfully completed.

3QL>execdbms_resource_manager,create_consumergroup (consumer_group=>’OLTP,,comment=>,onlineuser’)

PL/SQLproceduresuccessfullycompleted.

SQL>execdbras_resource_raanager.create_plan(plan=>’PRIU3ER3',comment=>'dssprio’);

SQL>exec

Dbms_resource_manager.create_plan_directive(plan=>’PRIU3ER3’,group_or_subplan=>'OLTP’,comraent=>'onlinegrp'CPU_Pl=>60);

PL/3QLproceduresuccessfullycompleted.

After execting the steps in the exhibit you execute this procedure, which results in an error:

SQL> EXECUTEdbms_resource_manager. validate_pending_area ();

What is the reason for the error?

You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively.

From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated.

What could be the reason for this?

Examine the output:

SQL > ARCHIVE LOGLIST

Database log mode Archive Mode

Automatic archival Enabled

Archive Destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 376

Next log sequence to archive 378

Current log sequence 378

Which three types of files are automatically placed in the fast recovery area?

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.

You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.

How would you achieve this?