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

Question 1

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 2

Examine this command executed on the first node of a four-node cluster:
$ < DATABASE_ORACLE_HOME >/OPatch/opatch apply 33575673
What does this command do?

A. It applies a patch to one database ORACLE home on alll cluster nodes.

B. It applies a patch to one oracle home only on the first cluster node.

C. It applies a patch to all oracle homes with the same release only on the first cluster node.

D. It applies a patch to all database oracle homes with the same release on all cluster nodes.

E. It applies a patch to all database oracle homes with the same release only on the first cluster node.

Correct Answer: B

Question 3

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 4

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

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

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

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

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

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

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

Correct Answer: A,C,E

Question 5

Which three statements are true concerning activation of a user-defined policy in Oracle 19c Clusterware? (Choose three.)

A. An administrator-defined policy may be activated using the srvctl utility.

B. When a policy is first created, it is initially inactive.

C. When a policy is activated, nodes may be reassigned to server pools based on the policy definition.

D. When a policy is activated, resources cannot be automatically started to comply with the policy definition.

E. When a policy is first created, it is initially active.

F. When a policy is activated, resources can be automatically stopped to comply with the policy definition.

Correct Answer: A,B,F

Question 6

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. Cluster resources

B. Administrator-defined resources

C. Database transactions

D. Local resources

E. Pluggable Databases (PDBs)

Correct Answer: A,B,D

Question 7

Which three statements are true about ASM Cloud File System (ACFS) auditing? (Choose three.)

A. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.

B. acfsutil audit init must be run by a system administrator.

C. acfsutil audit archive must be used to archive audit files that are larger than 10 MB.

D. acfsutil audit purge can be run by an audit manager.

E. acfsutil audit read marks audit files to indicate that it is safe to purge them.

Correct Answer: A,B,D

Question 8

Which three statements are true about the services created when the DBCA is used to create a RAC database? (Choose three.)

A. They can be administrator managed for a multitenant database.

B. A server pool must be created with srvct1 before creating a policy-managed RAC database that uses that server pool for a service.

C. They can be policy managed for a multitenant database.

D. Policy-managed services specified for a database allow the creation of a new server pool using dbca.

E. Singleton services are not permitted for multitenant databases.

Correct Answer: A,C,D

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

Latest Update

Useful Links

Contact Us