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

Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 19c? (Choose four.)

• A. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.
• B. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.
• C. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility.
• D. The oracle home environment variable must be set to the Grid Infrastructure home directory in the installation owner's environment.
• E. The oracle SID environment variable must be set to the SID of the ASM instance in the installation owner's environment.
• F. The upgrade must be done in-place.
• G. The upgrade must be done out-of-place.

You want to create a tablespace, SALES, with these requirements:
1. Its data file has an alias name sales.dbf.
2. Its data file is stored in the directory CURRENT_YR in the disk group DATA.
Examine this command:
SQL> CREATE TABLESPACE sales;
Which two tasks must you perform to meet these requirements? (Choose two.)

• A. Add the DATAFILE '+DATA/CURRENT YR/sales.dbf clause to the command.
• B. Create the current yr directory in the +data disk group.
• C. Create the current yr directory in the root directory (+).
• D. lAdd the DATAFILE '/CURRENT YR/sales.dbf clause to the command.
• E. Add the autoextend on clause to the command.

Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)

• A. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.
• B. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
• C. There is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
• D. The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.
• E. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor

Examine the output of this command:

The ACFS disk group is a normal redundancy disk group with 5 GB of free space.
To increase the size of the ACFS file system, you execute this command as the root user:
$ /sbin/acfsutil size +200M /u01/app/grid/acfsmount
Which two statements are true regarding the outcome of this command? (Choose two.)

• A. It fails to resize the filesystem because it must be unmounted before resizing.
• B. It fails to resize voli because it must be executed as a user belonging to the sysasm group.
• C. It succeeds but leaves the file system unmounted.
• D. It resizes the filesystem mounted on /u01/app/grid/acfsmount.
• E. It resizes voli.

Which three statements are true about services and load balancing for Oracle 19c clients connecting to Oracle 19c RAC database instances? (Choose three.)

• A. Services support the balancing of client connections across RAC database instances.
• B. Load balancing can be done by the client or the listener, but not both, for any one connection request.
• C. Load balancing can be done by the client, the listener, or both, for any one connection request.
• D. Client-side connect-time load balancing can balance connection requests across SCAN listeners.
• E. In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.