Free Oracle 1z0-083 Exam Questions (page: 11)

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?

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

Answer(s): A



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.)

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

Answer(s): D,E



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

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

Answer(s): A,B,C



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.)

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

Answer(s): C,E



Viewing page 11 of 71



Post your Comments and Discuss Oracle 1z0-083 exam prep with other Community members:

1z0-083 Exam Discussions & Posts