Question No. 1

Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES APP application. Examine these steps:

Install the SALES_APP application, induding the common tables, in the application root.

Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root.

Create an application seed.

Install the SALES_APP application in the application seed.

Create the SALES_APP1 and SALES_APP2 application PDBs.

Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.

Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.

Sync the application seed with the application root. Which are the minimum required steps in the correct sequence?

A1,3,5,7

B2,5,6

C1,5,6

D3,4,1.6,8

E1,3,5,6,7

Show Answer

Correct Answer: C

Question No. 2

A container database, CDB1, contains a pluggable database PDB1. Another container database is called CDB2. You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time. Which three are required?

ACDB2 must be in shared UNDO mode only.

BCDB2 must be in archivelog mode.

CCDB1 must be in archivelog mode.

DCDB1 and CDB2 must both be in local UNDO mode.

ECDB1 must be in shared UNDO mode only.A container database, CDB1, contains a pluggable database PDB1.

FCDB1 and CDB2 must be in shared UNDO mode.

Show Answer

Correct Answer: B, C, D

Question No. 3

Which two are true about creating pluggable databases (PDBs) in Oracle 19c and later releases?

AA PDB snapshot depends on an existing storage snapshot of the source PDB.

BAPDB snapshot can be a full copy of a source PDB.

CA PDB snapshot can be a sparse copy of a source PDB

DA snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

EA snapshot copy PDB can be a full copy of a source PDB

Show Answer

Correct Answer: B, C

Question No. 4

Which two are true about creating RMAN backups for an Oracle container database?

AOnline Redo Log backups can be created while connected to CDB$ROOT

BControl file backups can be created while connected to CDB$ROOT.

CThe BACKUP TABLESPACE command can back up a pDB tablespace even if RMAN is connected to CDB$ROOT.

DArchived Redo Log backups can be created while connected to PDB

EControl file backups can not be created while connected to a PDB

Show Answer

Correct Answer: A, B

Question No. 5

Which three are true about Automatic Workload Repository (AWR) snapshots?

AThey can be retained forever.

BThey are always created automatically.

CThey are always created manually.

DThey are generated if STATISTICS LEVEL is set to TYPICAL.

EThey are generated if STATISTICS LEVEL is set to BASIC.

FThey are generated if STATISTICS LEVEL is set to ALL.

Show Answer

Correct Answer: B, D, F

Free Oracle 1Z0-083 Exam Actual Questions

The questions for 1Z0-083 were last updated On Apr 29, 2024