Online Access Free 1z1-078 Practice Test

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

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

Your four-node cluster runs Oracle 19c Clusterware and supports a mix of RAC databases from Oracle 10g Release 2 to Oracle 19c.
All databases have one or more services defined.
The Oracle 10g Release 2 database clients connect to the database instances using the public VIP.
The Oracle 11g Release 2, 12c Release 1, and 19c clients connect to the database instances using the Single Client Access Name (SCAN).
You must change the public VIPs.
Which three actions must be performed to change the VIPs on host01, the first node in the cluster? (Choose three.)

• A.Use oifcfg setif to start the VIP on host01.
• B.Use oifcfg setif to stop the VIP on host01.
• C.Use srvctl modify nodeapps to change the VIP on host01.
• D.Use srvctl stop vip to stop the VIP on host01.
• E.Use srvctl start vip to start the VIP on host01.

Which two statements are true regarding ASM when installing Oracle Grid Infrastructure 19c? (Choose two.)

• A.ASM disk groups used for voting files and OCR files require a quorum failqroup.
• B.The Installer permits the creation of a disk group for use by the voting disks and OCR file.
• C.If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.
• D.If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.
• E.The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.

Which two benefits are obtained by using Affinity to reduce global resource contention? (Choose two.)

• A.Oracle RAC affinity for partitioned tables routes all database requests for a partition tables to a single Oracle RAC instance leading to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings of the partition tables.
• B.To enhance the performance of distributed transactions with applications server that provides XA affinity, you can direct all branches of a distributed transaction to a single instance in the cluster to improve cache locality and reduce internode synchronization and block pings.
• C.To enhance the performance of distributed transactions with applications server that provides XA affinity, you can automatically spawn new dedicated database RAC instances to isolate distributed transaction.
• D.Oracle RAC affinity for partitioned tables routes database requests to Oracle RAC instances in such a way that each instance always gets requests for a disjoint subset of rows in the database, this affinity leads to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings.
• E.Oracle RAC affinity for partitioned tables routes database requests to all available Oracle RAC instances evenly to create a global affinity in such a way that each instance always gets an even number of requests leading to higher Oracle RAC performance by using a higher levels of available global cache to reduce global resource contention.

You administer a RAC database that currently runs on a four-node cluster but which has three instances.
Which two statements are always true about redo logs for this RAC database? (Choose two.)

• A.A thread of redo must be created before starting a fourth instance if a thread is not already available.
• B.A thread of redo must contain at least two log groups before it can be enabled.
• C.All the instances must have the same number of redo log groups and each group must have the same number of redo log members.
• D.A redo log group added using alter database add logfile without the instance clause is added to each instance.
• E.A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.