Free Access Oracle.1z0-063.v2022-04-21.q171 Practice Test (Page 14)

Question 61

Your multitenant container database (CDB) CDB1that is running in ARCHIVELOGmode contains two pluggable databases (PDBs), PDB2_1and PDB2_2, both of which are open. RMAN is connected to the target pluggable database PDB2_1.
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which statement is true about the execution of this command to back up the database?

A.All data files belonging to PDB2_1are backed up and all archive log files are deleted.

B.Only the data files belonging to pdb2_1are backed up.

C.All data files belonging to PDB2_1are backed up along with the archive log files.

D.This command gives an error because archive log files can be backed up only when RMAN is connected to the root database.

Question 62

Which three statements are true about unplugging a pluggable database (PDB)?

A.The PDB must be open in read only mode.

B.The PDB must be dosed.

C.The unplugged PDB becomes a non-CDB.

D.The unplugged PDB can be plugged into the same multitenant container database (CDB)

E.The unplugged PDB can be plugged into another CDB.

F.The PDB data files are automatically removed from disk.

Question 63

Examine the commands executed to monitor database operations: $> conn sys/oracle@prod as sysdba
SQL> VAR eid NUMBER
SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job',FORCED_TRACKING=>'Y');
Which two statements are true?

A.Database operations will be monitored only when they consume a significant amount of resource.

B.Database operations for all sessions will be monitored.

C.Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.

D.Only DML and DDL statements will be monitored for the session.

E.All subsequent statements in the session will be treated as one database operation and will be monitored.

Question 64

Which two statements are true regarding SecureFile lobs? (Choose two.)

A.The amount of undo retained is user controlled.

B.They can be used only for nonpartitioned tables.

C.Fragmentation is minimized by using variable-sized chunks.

D.They support random reads and writes of encrypted LOB data.

Question 65

Which three statements are true about common roles? (Choose three.)

A.A common role can be granted only to a common user.

B.Only system privileges can be granted to a common role in a container database (CDB).

C.Object privileges can be granted to a common role in a pluggable database (PDB).

D.A common user that is granted a common role can grant the role to other common and local users in a PDB.

E.A common role cannot be created by a local user.

Other Version: 2768Oracle.1z0-063.v2022-10-18.q151

Latest Upload: 282PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 412Nokia.4A0-113.v2026-05-01.q69; 440EC-COUNCIL.312-49v11.v2026-04-30.q214; 403Microsoft.MB-820.v2026-04-30.q101; 274Salesforce.MC-202.v2026-04-30.q57; 322BICSI.INSTC_V8.v2026-04-29.q53; 457NMLS.MLO.v2026-04-28.q82; 299NCARB.Project-Management.v2026-04-28.q27; 546EMC.D-AV-DY-23.v2026-04-27.q184; 1388ServiceNow.CSA.v2026-04-27.q483

Question 61

Question 62

Question 63

Question 64

Question 65

Download PDF File