Free Oracle 1z1-078 Exam Dumps Questions & Answers

You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1,PDB_2, and PDB_3.
Server pool prod_pool has a cardinality of three and all six hosts of the cluster are up.
Examine these commands executed on HOST01:

Which two statements are true regarding the AR service? (Choose two.)

• A.AR is available only on the CDBl instance on host01.
• B.AR can fail over to any one of the available CD31 instances.
• C.AR runs as a singleton service in the server pool prod pool and the AR service is available in each of the CDBl instances.
• D.AR is available on any one available CDBl instance in prod pool at any one time.
• E.AR can fail over to any other available CDBl instance in prod pool.

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 oracle SID environment variable must be set to the SID of the ASM instance in the installation owner's environment.
• C.The oracle home environment variable must be set to the Grid Infrastructure home directory in the installation owner's environment.
• D.The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.
• E.Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility.
• F.The upgrade must be done in-place.
• G.The upgrade must be done out-of-place.

Which three statements are true about the services created when the DBCA is used to create a RAC database? (Choose three.)

• A.A server pool must be created with srvct1 before creating a policy-managed RAC database that uses that server pool for a service.
• B.They can be administrator managed for a multitenant database.
• C.Singleton services are not permitted for multitenant databases.
• D.They can be policy managed for a multitenant database.
• E.Policy-managed services specified for a database allow the creation of a new server pool using dbca.

Which statement is true concerning the installation of an Oracle Grid Infrastructure 19c patchset and its status during the installation?

• A.When performing rolling patches, crsctl query crs softwareversion always displays the earliest version of the software running anywhere in the cluster.
• B.Some Grid Infrastructure patchsets may not be intalled in a rolling fashion.
• C.When performing rolling patches, the vips for the node being patched are relocated to another node.
• D.They can be applied in-place.

Which two statements are true concerning Oracle 19c Clusterware-managed application VIPs? (Choose two.)

• A.An application VIP is created on the interconnect network by the crsccl utility.
• B.Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.
• C.An application VIP is created on the default network by the appvipcfg utility.
• D.An application VIP can be created with the crsccl utility.
• E.If an application sends messages to be displayed and sets the display variable, then an application VIP is required.