Most Recent Oracle 1Z0-078 Exam Questions & Answers

Prepare for the Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration exam with our extensive collection of questions and answers. These practice Q&A are updated according to the latest syllabus, providing you with the tools needed to review and test your knowledge.

QA4Exam focus on the latest syllabus and exam objectives, our practice Q&A are designed to help you identify key topics and solidify your understanding. By focusing on the core curriculum, These Questions & Answers helps you cover all the essential topics, ensuring you're well-prepared for every section of the exam. Each question comes with a detailed explanation, offering valuable insights and helping you to learn from your mistakes. Whether you're looking to assess your progress or dive deeper into complex topics, our updated Q&A will provide the support you need to confidently approach the Oracle 1Z0-078 exam and achieve success.

The questions for 1Z0-078 were last updated on Dec 21, 2024.

Viewing page 1 out of 15 pages.
Viewing questions 1-5 out of 77 questions

Get All 77 Questions & Answers

Question No. 1

Examine this command:

Which two statements are true about this disk group, created using Grid Infrastructure 19c? (Choose two.)

AAny database instance with the COMPATIBLE parameter set to 12.2 or later can access it.

BIt can contain ASM Dynamic Volume Manager (ADVM) volumes.

CEach disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.

DThe ASM compatible attributes can be changed to 12. l for this disk group.

EFiles created in this disk group always have two copies for each allocation unit: one primary and one secondary.

Show Answer

Correct Answer: A, B

Question No. 2

Which two steps must always be performed to delete node host04 from an Oracle 19c Clusterware cluster that does not use Grid Naming Service (GNS)? (Choose two.)

ARun the crsctl unpin css - host04 command as root on host01, or on either host02 or host03.

BRun the crsctl delete node -n host04 command as root on host04.

CRun the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.

DRun the crsct1 unpin css - host04 command as root on host04.

ERun the rootcrs.pl -deconfig -force command as root on host04.

FRun the rootcrs.pl -deconfig -force command as root on host01, or on either host02 or host03.

Show Answer

Correct Answer: C, E

Question No. 3

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

AThe maximum value of ASM_POWER_LIMIT is 1024.

BThe default value of INSTANCE_TYPE is ASM.

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

DThe ASM_DISKGOUPS parameter is optional.

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

Show Answer

Correct Answer: B, D

Question No. 4

You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1,PDB_2, and PDB_3.

Server pool prod_pool has a cardinality of three and all six hosts of the cluster are up.

Examine these commands executed on HOST01:

Which two statements are true regarding the AR service? (Choose two.)

AAR can fail over to any one of the available CD31 instances.

BAR runs as a singleton service in the server pool prod pool and the AR service is available in each of the CDBl instances.

CAR can fail over to any other available CDBl instance in prod pool.

DAR is available only on the CDBl instance on host01.

EAR is available on any one available CDBl instance in prod pool at any one time.

Show Answer

Correct Answer: C, E

Question No. 5

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

Aan 0/S user to own the Oracle Database installation

Ban O/S group called dba

Can O/S user to own the Grid Infrastructure installation

Dan O/S group to own the software inventory

EA group to own Automatic Storage Management (ASM) Filter Driver-provisioned storage

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

Show Answer

Correct Answer: C, D

Unlock All Questions for Oracle 1Z0-078 Exam

Full Exam Access, Actual Exam Questions, Validated Answers, Anytime Anywhere, No Download Limits, No Practice Limits

Get All 77 Questions & Answers