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

Question 51

For which three pieces of information can you use the RMAN list command? (Choose three.)

A.stored scripts in the recovery catalog

B.available archived redo log files

C.backup sets and image copies that are obsolete

D.backups of tablespaces

E.backups that are marked obsolete according to the current retention policy

Question 52

You are administering a multitenant container database (CDB) that has no startup triggers and contains three pluggable databases (PDBs).
You execute the command to start up the CDB.
SQL> STARTUP
Which statement is true?

A.CDB$ROOT, PDB$SEED, and the PDBs are opened in read-only mode.

B.CDB$ROOT and PDB$SEED are opened in read-only mode, but the PDBs are in closed mode.

C.CDB$ROOT is opened in read/write mode, but PDB$SEED and the PDBs are in closed mode.

D.CDB$ROOT is opened in read/write mode, PDB$SEED in read-only mode, and the PDBs in MOUNT state.

E.CDB$ROOT, PDB$SEED, and the PDBs are opened in read/write mode.

Question 53

Which three statements are true about compression of backup sets? (Choose three.)

A.Binary compression creates performance overhead during a backup operation.

B.It works only for locally managed tablespaces.

C.Compressed backups cannot have section size defined during a backup operation

D.Compressed backups can only be written to media.

E.Unused blocks below the high-water mark are not backed up.

Question 54

Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and 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_1 are backed up along with the archive log files.

B.All data files belonging to pdb2_1 are backed up and all archive log files are deleted.

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

D.Only the data files belonging to pdb2_ are backed up.

Question 55

You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600.
Which two statements are true? (Choose two.)

A.A resumable statement can be suspended and resumed only once during execution.

B.A suspended statement will report an error if no corrective action has taken place during a timeout period.

C.Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.

D.Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.

E.Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

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; 439EC-COUNCIL.312-49v11.v2026-04-30.q214; 396Microsoft.MB-820.v2026-04-30.q101; 273Salesforce.MC-202.v2026-04-30.q57; 322BICSI.INSTC_V8.v2026-04-29.q53; 456NMLS.MLO.v2026-04-28.q82; 299NCARB.Project-Management.v2026-04-28.q27; 544EMC.D-AV-DY-23.v2026-04-27.q184; 1388ServiceNow.CSA.v2026-04-27.q483

Question 51

Question 52

Question 53

Question 54

Question 55

Download PDF File