Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration - 1z1-078 Free Exam Questions

A. It applies a patch to one database ORACLE home on alll cluster nodes.

B. It applies a patch to all database oracle homes with the same release on all cluster nodes.

C. It applies a patch to all oracle homes with the same release only on the first cluster node.

D. It applies a patch to one oracle home only on the first cluster node.

E. It applies a patch to all database oracle homes with the same release only on the first cluster node.

A. A server pool can have the same attributes defined for different policies in the policy set, when user-defined policy management is used.

B. Servers in a server pool outside the control of the policy set are never affected by policy changes, when user-defined policy management is used.

C. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.

D. All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.

E. A server pool can have different attributes defined for different policies in the policy set, when user-defined policy management is used.

A. A database instance on a node cannot be a client of an ASM instance running on other nodes.

B. An ASM instance and database instances can coexist on the same node.

C. A database instance on a node can be a client of an ASM instance running on any node.

D. A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgroups.

E. A database instance on a node can only be a client of an ASM instance running on the same node.

F. ASM Cluster File System (ACFS) can be deployed on any nodes.

A. Oracle Managed Files must be enabled or PD3 file name convert must be set.

B. It can be executed only by a common user with the create pluggable database system privilege connected to the root container.

C. The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.

D. The source PD3 must be closed on the CDS instance from where the command is executed.

E. All running CDB instances must be open in restricted mode.

F. The source pdb must use a global temporary

A. The oracle home environment variable must be set to the Grid Infrastructure home directory in the installation owner's environment.

B. The oracle SID environment variable must be set to the SID of the ASM instance in the installation owner's environment.

C. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.

D. The upgrade must be done in-place.

E. The upgrade must be done out-of-place.

F. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility.

G. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.

A. All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance.

B. All ASM Disks belonging to a disk group should be of the same size for optimal performance.

C. Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.

D. Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance.

E. To improve performance a database must have two disk groups; one for data and one for the fast recovery area.

A. It is necessary to assign a specific undo tablespace to a specific instance.

B. In a policy-managed RAC database, an undo tablespace may automatically be created if OMF is enabled for the database.

C. A mixture of automatic undo management and manual undo management is supported within a RAC database.

D. You can dynamically assign a newly created undo tablespace to an instance.

E. An instance that performs instance recovery can write to the undo tablespace of a failed instance.

A. Load balancing of connection requests across all six database instances

B. Load balancing of connection requests for CRM across all database instances running on servers in the prod pool

C. Load balancing of connection requests for ERP across all database instances running on servers in the prod pool

D. Load balancing of client connection requests for CRM across four Single Client Access Name (SCAN) listeners

E. High availability for the CRM service

F. Load balancing of client connection requests for ERP across three Single Client Access Name (SCAN) listeners

G. High availability for the ERP service