1z0-083 Practice Test

1z0-083 Practice Test practice questions, page 4 of 8, with answer review and explanations.

Question 16

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_PDB.CHECK_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.

Question 17

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.

Question 18

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

Question 19

Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

  1. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
  2. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
  3. After the change, only one undo tablespace can exist in CDB$ROOT.
  4. After the change, any user with the required privilege can create an undo tablespace in the PDBs.
  5. Undo tablespaces existing in PDBs must be dropped before the change.
  6. After the change, each existing PDB has to be reopened for the new undo mode to take effect.

Question 20

Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

  1. It is integrated with the SQL Access Advisor.
  2. It predicts the impact of system changes on SQL workload response time.
  3. It provides before and after execution statistics for each SQL statement in the analysis task
  4. It offers fine-grained analysis of all the SQL statements in the analysis task as a group.
  5. SQL statements that were originally run concurrently are run concurrently by SPA.