Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration - 1z0-078 FREE EXAM DUMPS QUESTIONS & ANSWERS

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

A. Stage the patch on the cluster node where the OPacch utility will be executed. B. Update the path environment variable on each cluster node to point to the 50RACLE HOME/OPacch directory C. Stage the patch on all cluster nodes. D. Update the path environment variable on the node where you will run the OPatch utility to point to the SORacle HOME/OPacch directory.

A. Services support the balancing of client connections across RAC database instances. B. In server-side load balancing, node listener redirects the client to another node listener for connection to an instance. 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. Load balancing can be done by the client or the listener, but not both, for any one connection request.

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

A. File systems contained in ADVM volumes may only contain database files. B. Only one ADVM volume can be created in an ASM disk group. C. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group. D. An ADVM volume is individually named and can contain only one file system. E. To create an ADVM volume, disk group attributes COMPATIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.<.span>.

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 automatically spawn new dedicated database RAC instances to isolate distributed transaction. C. 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. 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.

A. Fix-up scripts generated during the installation must be run as root on UNIX platforms. B. The software can be installed into an ACFS file system. C. The software must be installed on all nodes in the cluster. D. The software must be installed into a cluster file system. E. The software must be installed into a local file system on each node. F. RAC installations require Oracle Enterprise Edition. G. SSH user equivalence for the Oracle user can be set up before the software installation.

A. Load balancing of connection requests across all six database instances B. Load balancing of client connection requests for CRM across four Single Client Access Name (SCAN) listeners C. Load balancing of connection requests for ERP across all database instances running on servers in the prod pool D. High availability for the CRM service E. Load balancing of connection requests for CRM across all database instances running on servers in the prod pool F. High availability for the ERP service G. Load balancing of client connection requests for ERP across three Single Client Access Name (SCAN) listeners