You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user. You execute the commands:

SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23;

SQL> CREATE ROLE C##CONNECT;

SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT;

SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;

Which statement is true about the c##connect role?

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?

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?