Create Next App

Exam contains 94 questions

Page 7 of 16

Question 37 🔥

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

Which database solution meets these requirements?

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.

Highly voted

B. 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.

Highly voted

C. 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.

Highly voted

D. 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.

Highly voted

E. 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.

Highly voted

Discussion of the question

Question 38 🔥

Which method should be used to convert a single-instance Oracle 19c Database to a RAC Database?

Which database solution meets these requirements?

A. Using the rconfig utility to migrate the database to shared storage and then using DBCA to start one or more RAC database instances on the cluster

Highly voted

B. Using DBCA to migrate the database to shared storage and then to start one or more RAC database instances on the cluster

Highly voted

C. Using the rconfig utility to create a template from the single-instance database and then using DBCA to create a RAC database on the cluster using that template

Highly voted

D. Using DBCA to create a template from the single-instance database and then to create a RAC database on the cluster using that template

Highly voted

Discussion of the question

Question 39 🔥

Examine this command and output:Examine this command:Which statement must be true for the successful execution of the second command?

Which database solution meets these requirements?

A. The disk group compatibility attribute for ADVM must be set to 12.1 or higher.

Highly voted

B. The parent snapshot must be read-only.

Highly voted

C. The underlying ADVM volume must be configured with high redundancy.

Highly voted

D. The parent snapshot must be read/write.

Highly voted

Discussion of the question

Question 40 🔥

Which three statements are true about the Oracle Clusterware 19c Flex Cluster architecture? (Choose three.)

Which database solution meets these requirements?

A. Each hub node must be connected to storage shared across all hub nodes.

Highly voted

B. Each leaf node must be connected to storage shared across all cluster nodes.

Highly voted

C. Each leaf node must be connected to storage shared across all leaf nodes.

Highly voted

D. Leaf nodes require direct access to the voting disks.

Highly voted

E. Hub nodes require direct access to the OCR file.

Highly voted

F. Hub nodes require direct access to the voting disks.

Highly voted

Discussion of the question

Question 41 🔥

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

Which database solution meets these requirements?

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

E. The upgrade must be done in-place.

Highly voted

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

Highly voted

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

Highly voted

Discussion of the question

Question 42 🔥

Examine this sequence of commands:The cluster consists of nodes HOST01, HOST02, HOST03 and HOST04, and the clusterware is running on all four nodes.Which three statements are true about the result of the root user running these commands on HOST01? (Choose three.)

Which database solution meets these requirements?

F. The Oracle Clusterware stack is started on all nodes.

Highly voted

A. The Oracle Clusterware stack is stopped on all nodes.

Highly voted

B. The Oracle Clusterware stack is prevented from being automatically started on HOST01.

Highly voted

C. The Oracle Clusterware stack is prevented from being automatically started on all nodes.

Highly voted

D. The Oracle Clusterware stack is stopped on all nodes except HOST01.

Highly voted

E. The Oracle Clusterware stack is started on all nodes except HOST01.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_078

Exam contains 94 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us