Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration (1z1-078) Free Practice Test

Question 1

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

A. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.

B. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.

C. The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.

D. The Installer permits the creation of a disk group for use by the voting disks and OCR file.

E. ASM disk groups used for voting files and OCR files require a quorum failqroup.

Correct Answer: B,D

Question 2

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

A. RAC installations require Oracle Enterprise Edition.

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

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

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

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

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

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

Correct Answer: A,D,G

Question 3

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

A. alter sequence seql noorder;

B. alter sequence seql keep;

C. alter sequence seql order;

D. alter sequence seal cache 10000;

E. exec sys.dbms shared pool.keep('SEQ1','Q'>

Correct Answer: A,D

Question 4

A Java application using thick JDBC connections will soon be deployed, and you must configure a RAC database to support highly available connections.
Broken connections must be re-established as quickly as possible.
Which feature will support this requirement?

A. Fast Connection Failover (FCF) with Transparent Application Failover (TAF)

B. Transparent Application Failover (TAF)

C. Transparent Application Failover (TAF) using Fast Application Notification (FAN)

D. Fast Connection Failover (FCF)

Correct Answer: D

Question 5

Which two operating system users and groups must be created on each node before installing Oracle Grid Infrastructure 19c? (Choose two.)

A. an O/S group to own the software inventory

B. an O/S user to own the Clusterware installation and a different O/S user own the Automatic Storage Management (ASM) installation

C. an O/S user to own the Grid Infrastructure installation

D. an O/S group called dba

E. A group to own Automatic Storage Management (ASM) Filter Driver-provisioned storage

F. an 0/S user to own the Oracle Database installation

Correct Answer: A,C

Question 6

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

A. The upgrade must be done in-place.

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

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

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

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

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

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

Correct Answer: B,E,F,G

Question 7

For which three entities can the "what-if" command evaluation be used to determine the impact of clusterware management operations in Oracle 19c Clusterware? (Choose three.)

A. Database transactions

B. Administrator-defined resources

C. Pluggable Databases (PDBs)

D. Cluster resources

E. Local resources

Correct Answer: B,D,E

Question 8

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 stop the VIP on host01.

B. Use srvctl stop vip to stop the VIP on host01.

C. Use srvctl start vip to start the VIP on host01.

D. Use srvctl modify nodeapps to change the VIP on host01.

E. Use oifcfg setif to start the VIP on host01.

Correct Answer: A,B,D

Welcome to TestSimulate

Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration (1z1-078) Free Practice Test