Online Access Free 1z1-063 Practice Test

Which three statements are true about the keystore storage framework for transparent data encryption?
(Choose three.)

• A.It enables separation of duties between the database administrator and the security administrator.
• B.It handles encrypted data without modifying applications.
• C.It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.
• D.It transparently decrypts data for the database users and applications that access this data.
• E.It enables a keystore to be stored only in a file on a file system.
• F.It facilitates and helps to enforce keystore backup requirements.

Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which type of encryption is used for the backup performed by using this command?

• A.password-mode encryption
• B.transparent encryption
• C.dual-mode encryption
• D.default encryption

View the Exhibit showing steps to create a database resource manager plan.
SQL>execute dbms_resource_manager.create_pendingarea();
PL/SQL procedure successfully completed.
SQL>exec dbms_resource_manager, create_consumergroup
(consumer_group=>'OLTP,,comment=>,onlineuser')
PL/SQL procedure successfully completed.
SQL>exec bras resource_manager.create plan(plan=>'PRIU3ER3',comment=>'dssprio'); SQL>exec Dbms_resource_manager.create_plan_directive(plan=>'PRIU3ER3',group_or_subplan=>'OLTP',comment=>'on PL/3QLproceduresuccessfullycompleted.
After executing the steps in the exhibit you execute this procedure, which results in an error:
SQL> EXECUTE dbms_resource_manager. validate_pending_area ();
What is the reason for the error?

• A.The procedure must be executed before creating any plan directive.
• B.The sys_group group is not included in the resource plan.
• C.Pending areas can not be validated until submitted.
• D.The pending area is automatically submitted when creating plan directives.
• E.The other_groups group is not included in the resource plan.

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)

• A.To enable a resource plan for a PDB, a CDB resource plan must be created and enabled.
• B.If no PDB plan is enabled for a pluggable database, all sessions for that PDB are treated to an equal share of resources.
• C.If no PDB plan is enabled for a pluggable database, the PDB uses the CDB plan.
• D.If a PDB plan is enabled for a pluggable database, Resource Manager uses the resource allocation at the PDB level and ignores the limits set at the CDB level.
• E.If a PDB plan is enabled for a pluggable database, resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

You are administering a multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode and contains pluggable databases (PDBs), PDB_1 and PDB_2.
While opening PDB_1, you get an error:
SQL> alter pluggable database pdb_1 open;
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
ORA-01110: data file 11: '/u01/app/oracle/oradata/cdb1/pdb_1/example01.dbf' To repair the failure, you open an RMAN session for the target database CDB$ROOT. You execute the following as the first command:
RMAN> REPAIR FAILURE;
Which statement describes the consequence of the command?

• A.The command executes successfully, performs recovery, and opens PDB_1.
• B.The command performs the recovery and closes the failure.
• C.The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command.
• D.The command produces an error because RMAN is not connected to the target database PDB_1.