1z0-083 Exam Questions and Answers | Exam-Dumps.net (Page: 8)

QUESTION: 36

Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three.)

to allow database duplication without a connection to the target instance.
to store backup metadata that would cause the controlfile to become too large.
to store backups that would cause the controlfile to become too large.
to report on the database schema at an earlier point in time.
to allow database duplication without a connection to the auxiliary instance.

Answer(s): A,B,D

You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog. You create an auxiliary instance and want to execute the command: RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE; What is a prerequisite for the successful execution of this command?

RMAN must be connected to the target database instance and the auxiliary instance.
A most recent backup set of the PROD database must exist.
Flashback must be enabled for the PROD database.
The target database must be in MOUNT state.

Answer(s): A

Reveal Solution Next Question

QUESTION: 38

A container database called CDB1 is OMF-enabled. PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1: CREATE PLUGGABLE DATABASE pdb1 USING ‘/u01/app/oracle/oradata/pdb1.xml’ SOURCE_FILE_NAME_CONVERT = (‘/u01/app/oracle/oradata/’, ‘/u02/app/oracle/oradata/’);

Which two are true? (Choose two.)

PDB1 data files already exist in the correct location.
DBMS_PDCHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
PDB_FILE_NAME_CONVERT must be set before executing the command.
/u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.
PDB1 must be dropped from CDB1.

Answer(s): D,E

Reveal Solution Next Question

QUESTION: 39

Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)

By default, the transported database will use Oracle Managed Files (OMF)
Data files can be converted on the destination system.
Data files can be converted on the source system.
A new DBID is automatically created for the transported database.
Databases can be transported between systems with different endian formats.
The password file is automatically converted by RMAN.

Answer(s): A,B,C

Reveal Solution Next Question

QUESTION: 40

Examine this command:
$ rhpctl move database –sourcehome Oracle_home_path –destinationhome Oracle_home_path
For which two purposes can you use this command? (Choose two.)

to switch an existing Oracle Database home to a newer release of Oracle software on the same server
to switch to a read-only Oracle home
to switch back to the previous Oracle home as part of a rollback operation
to switch the Oracle Database home when using a centralized Rapid Home Provisioning server
to switch to a patched Oracle Database home

Answer(s): C,E

Reveal Solution Next Question

Oracle 1z0-083 Exam (page: 8)
Oracle Database Administration II
Updated on: 01-Sep-2025

QUESTION: 36

QUESTION: 37

QUESTION: 38

QUESTION: 39

QUESTION: 40

Oracle 1z0-083 Exam (page: 8) Oracle Database Administration II Updated on: 01-Sep-2025

QUESTION: 36

QUESTION: 37

QUESTION: 38

QUESTION: 39

QUESTION: 40

Oracle 1z0-083 Exam (page: 8)
Oracle Database Administration II
Updated on: 01-Sep-2025