Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration

Question 1

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 srvctl modify nodeapps to change the VIP on host01.

B. Use oifcfg setif to stop the VIP on host01.

C. Use oifcfg setif to start 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.

Correct Answer: A,B,D

Question 2

Which statement is true about Oracle Database 19c SGA Management?

A. Oracle RAC Resource Management only allows assignment of the SGA during instance startup.

B. Oracle RAC Resource Runtime Management allows for automatic and runtime adjustment of the SGA.

C. Oracle RAC Resource Management only allows assignment of the SGA during database startup.

D. Oracle RAC Resource Management requires the same SGA value for all the instances of a RAC database which is configured during database startup only.

Correct Answer: B

Question 3

You must deploy several Oracle 19c databases on an Oracle Grid Infrastructure Managed Cluster, and are required to have the ability to perform these actions without down time:
1. Apply a Grid Infrastructure interim patch.
2. Apply a Grid Infrastructure Patch Set Update (PSU).
3. Apply a database on-line patch.
4. Apply a Grid Infrastructure patchset.
5. Apply a database patchset.
6. Upgrade Grid Infrastructure from one release to another.
7. Upgrade databases from one release to another.
Your plan is to perform these tasks:
1. Install and configure Oracle Grid Infrastructure on a local file system.
2. Install Oracle Database software on an ACFS file system.
3. Create several RAC One Node databases.
Which of the seven requirements are met by your plan?

A. 2, 3, 4 and 6.

B. 2, 3, 4, 5 and 6.

C. 1, 2, 3, 4 and 6.

D. 1, 2, 3, 4, 5 and 6.

E. 1, 2, 3 and 4.

F. 1, 2, 3, 4, 5, 6 and 7.

Correct Answer: E

Question 4

Which three statements are true about fully qualified file names in ASM? (Choose three.)

A. They can be created only if OMF is enabled.

B. They are system Generated at the time of ASM file creation.

C. They can be used to reference existing ASM files.

D. An alias may be created for an existing file by referring to the fully qualified file name.

E. They are the only valid form that can be used for single file creation of a control file.

Correct Answer: B,C,D

Question 5

Examine this command:
SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;
Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)

A. The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.

B. Oracle Managed Files must be enabled or PD3 file name convert must be set.

C. All running CDB instances must be open in restricted mode.

D. The source pdb must use a global temporary

E. The source PD3 must be closed on the CDS instance from where the command is executed.

F. It can be executed only by a common user with the create pluggable database system privilege connected to the root container.

Correct Answer: B,E,F

Question 6

You performed these steps to disable an ADVM volume containing an ACFS file system:
1. Dismount the file system.
2. Disable the volume with the ASMCMD voldisable command.
Which two statements are true regarding the actions performed? (Choose two.)

A. The volume can be enabled and the file system can be mounted back again to access the existing data.

B. The ACFS file system will be permanently removed from the volume only if the file system is empty.

C. The ACFS mount registry with Oracle restart is automatically deleted.

D. The ACFS file system will be permanently removed from the volume.

E. The disabling of volume does not destroy data in the file system.

Correct Answer: A,E

Question 7

Disk group DGRP1 has these attributes:
1. Normal redundancy
2. Two failure groups FG1 and FG2 with two disks each
3. Compatibility settings set to 19.0
The FG1 failure group goes offline due to hardware failure.
Which two statements are true? (Choose two.)

A. Transactions on database objects stored in tablespaces in the dgrpi disk group fail.

B. New allocation units are mirrored in the FG2 failure group until FGl is restored and the disk group resvnchronized-

C. The redundancy is lowered until the FGl failgroup is restored and the disk group resynchronized.

D. New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.

Correct Answer: B,D

Question 8

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

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

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

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

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

E. The upgrade must be done in-place.

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

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

Correct Answer: A,C,D,F

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

Latest Update

Useful Links

Contact Us