Free Oracle 1z0-078 Exam Dumps Questions & Answers

Examine this command:
SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;
Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)

• A.  The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.
• B.  Oracle Managed Files must be enabled or PD3 file name convert must be set.
• C.  The source PD3 must be closed on the CDS instance from where the command is executed.
• D.  All running CDB instances must be open in restricted mode.
• E.  It can be executed only by a common user with the create pluggable database system privilege connected to the root container.
• F.  The source pdb must use a global temporary

Disk group DGRP1 has these attributes:
1. Normal redundancy
2. Two failure groups FG1 and FG2 with two disks each
3. Compatibility settings set to 19.0
The FG1 failure group goes offline due to hardware failure.
Which two statements are true? (Choose two.)

• A.  Transactions on database objects stored in tablespaces in the dgrpi disk group fail.
• B.  The redundancy is lowered until the FGl failgroup is restored and the disk group resynchronized.
• C.  New allocation units are mirrored in the FG2 failure group until FGl is restored and the disk group resvnchronized-
• D.  New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.

Which two commands will stop the Oracle High Availability Services (OHAS) and prevent it from starting automatically at system boot on the local node? (Choose two.)

• A.  crsctl stop crs
• B.  crsctl stop cluster
• C.  crsctl config crs
• D.  crsctl disable crs

Which three statements are true about Quality of Service Management (QoS)? (Choose three.)

• A.  It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.
• B.  A server pool can be managed by QoS even if it does have database instances running on any server in the pool.
• C.  Databases managed by QoS can be administrator managed or policy managed.
• D.  It supports multiple databases assigned to the same server pool.
• E.  It can manage database services only if they are defined as UNIFORM services.

Which two statements are true about v$asm- views in a clustered environment? (Choose two.)

• A.  They exist in both ASM and RDBMS instances, and display the same output.
• B.  Their names can be seen in dice when connected to an ASM instance.
• C.  They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.
• D.  gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.
• E.  Their names can be seen in v$fixed_table when connected to an instance of any type that is started.