Create Next App

Exam contains 94 questions

Page 10 of 16

Question 55 🔥

Which three statements are true about an Oracle Database RAC software installation? (Choose three.)

Which database solution meets these requirements?

A. SSH user equivalence for the Oracle user can be set up before the software installation.

Highly voted

B. Fix-up scripts generated during the installation must be run as root on UNIX platforms.

Highly voted

C. The software must be installed into a local file system on each node.

Highly voted

D. The software must be installed into a cluster file system.

Highly voted

E. RAC installations require Oracle Enterprise Edition.

Highly voted

F. The software can be installed into an ACFS file system.

Highly voted

G. The software must be installed on all nodes in the cluster.

Highly voted

Discussion of the question

Question 56 🔥

Which two statements are true about initialization parameters for Clustered ASM instances? (Choose two.)

Which database solution meets these requirements?

A. The maximum value of ASM_POWER_LIMIT is 1024.

Highly voted

B. The default value of INSTANCE_TYPE is ASM.

Highly voted

C. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect.

Highly voted

D. The ASM_DISKGOUPS parameter is optional.

Highly voted

E. ASM_POWER_LIMIT controls the number of RDBMS instances that can access a disk group while it is being rebalanced.

Highly voted

Discussion of the question

Question 57 🔥

Which three statements are true about undo management in a RAC environment? (Choose three.)

Which database solution meets these requirements?

A. You can dynamically assign a newly created undo tablespace to an instance.

Highly voted

B. In a policy-managed RAC database, an undo tablespace may automatically be created if OMF is enabled for the database.

Highly voted

C. An instance that performs instance recovery can write to the undo tablespace of a failed instance.

Highly voted

D. A mixture of automatic undo management and manual undo management is supported within a RAC database.

Highly voted

E. It is necessary to assign a specific undo tablespace to a specific instance.

Highly voted

Discussion of the question

Question 58 🔥

Examine this query and output:Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence.The SEQ1 sequence is incremented from all instances equally and is frequently used.Which two statements should you execute to reduce SQ enqueue contention? (Choose two.)

Which database solution meets these requirements?

B. alter sequence seq1 cache 10000;

Highly voted

C. alter sequence seq1 noorder;

Highly voted

A. exec sys.dbms_shared_pool.keep(‘SEQ1’,’Q’)

Highly voted

D. alter sequence seq1 keep;

Highly voted

E. alter sequence seq1 order;

Highly voted

Discussion of the question

Question 59 🔥

Which three statements are true about Quality of Service Management (QoS)? (Choose three.)

Which database solution meets these requirements?

A. It can manage database services only if they are defined as UNIFORM services.

Highly voted

B. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.

Highly voted

C. A server pool can be managed by QoS even if it does have database instances running on any server in the pool.

Highly voted

D. Databases managed by QoS can be administrator managed or policy managed.

Highly voted

E. It supports multiple databases assigned to the same server pool.

Highly voted

Discussion of the question

Question 60 🔥

Which two statements are true about Transparent Application Continuity in Oracle RAC 19c? (Choose two.)

Which database solution meets these requirements?

A. Transparent Application Continuity is automatically enabled for a session when a database session reaches a safe place (such as a connection test or a known recoverable point) and the transactions are drained at the database.

Highly voted

B. Transparent Application Continuity is enabled when FAILOVER_TYPE=AUTO.

Highly voted

C. Recovery of the user database session is done safely and with no need for a DBA to have any knowledge of the application or make application code changes.

Highly voted

D. Recovery of the user database session is done safely by enabling AUTO_RECOVER within the user database session.

Highly voted

E. Transparent Application Continuity is enabled when FAILOVER_TYPE=ALL.

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