Free Oracle 1Z0-083 Exam Dumps Questions & Answers

Which three are true about an application container?

• A.  It always contains multiple applications.
• B.  It always contains a single application.
• C.  It always has a new application PDBs created by copying PDB$SEED.
• D.  It can have new application PDBs created by copying PDB$SEED.
• E.  Two or more application PDBs in the same application container can be given exclusive access to some tables.
• F.  Two or more application PDBs in the same application container can share access to tables.

Which two are true about Oracle instance recovery? (Choose two.)

• A.  Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.
• B.  Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.
• C.  Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.
• D.  Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
• E.  Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.
• F.  Recovery begins from the beginning of the CURRENT redo log group.

Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?

• A.  RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
• B.  The UNDO TABLESPACE clause is never required.
• C.  RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.
• D.  The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
• E.  The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

You issued this command:
RMAN> BACKUP RECOVERY AREA FORCE;
Which three are true? (Choose three.)

• A.  All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up.
• B.  All files in any previous FRA that have been backed up already, are backed up.
• C.  All Oracle recovery files normally written to the FRA and which have not yet been backed up, are backed up.
• D.  All files in any previous FRA that have not yet been backed up, are backed up.
• E.  All files in the current FRA that have been backed up already, are backed up.
• F.  All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up.
• G.  All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up.

Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

• A.  The owner of VPC cannot own recovery catalog.
• B.  The recovery_catalog_owner role should be granted to the virtual catalog owner.
• C.  The register database privilege should be granted to the virtual catalog owner.
• D.  At least one target database should be registered in the recovery catalog.
• E.  A base recovery catalog should exist.