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 Nov 20, 2024.

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

Get All 77 Questions & Answers

Question No. 1

Which three statements are true about the Global Resource Directory (GRD) in Oracle 19c RAC database and in Clustered ASM? (Choose three.)

AOnly one GRD shadow resource may exist for an Enqueue Resource.

BShadow GRD resources may exist in more than one database instance for a resource.

CClustered ASM has GRD resources distributed among all ASM instances.

DAll GRD Enqueue Resource master metadata is held in the large pool of the same database instance.

EAll GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.

FRAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.

GRAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.

Show Answer

Correct Answer: B, C, F

Question No. 2

Examine this command:

Which two statements are required for this command to succeed? (Choose two.)

AThe DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).

Bnewtemplate must be defined for the +DATA disk group.

CExisting data files in TBS1 must also use the same template.

DUser-defined subdirectories ORCL and USERS must already exist.

EThe +DATA disk group should not be part of Flex ASM.

Show Answer

Correct Answer: B, D

Question No. 3

Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy.

Which two statements are true? (Choose two.)

AThe service must be manually started with SRVCTL after a planned restart of the instance hosting the service.

BThe service must be manually restarted with SRVCTL every time the instance hosting the service fails.

CThe service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service.

DClusterware will monitor the service while it is active.

EWhen manually started, the service will always start on one or more available instances rather than on their preferred instances.

Show Answer

Correct Answer: A, D

Question No. 4

You support a RAC database with these characteristics:

1. There are six instances.

2. Server Pool prod has a maximum of four servers.

3. CRM is a policy managed, uniform service using Server Pool prod.

4. ERP is a policy managed, singleton service using Server Pool prod.

5. Grid infrastructure is installed and running in its default configuration.

Which four benefits are provided by this configuration in Oracle 19c? (Choose four.)

AHigh availability for the CRM service

BLoad balancing of connection requests across all six database instances

CHigh availability for the ERP service

DLoad balancing of client connection requests for CRM across four Single Client Access Name (SCAN) listeners

ELoad balancing of connection requests for ERP across all database instances running on servers in the prod pool

FLoad balancing of client connection requests for ERP across three Single Client Access Name (SCAN) listeners

GLoad balancing of connection requests for CRM across all database instances running on servers in the prod pool

Show Answer

Correct Answer: A, C, D, G

Question No. 5

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?

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

B2, 3, 4 and 6.

C1, 2, 3 and 4.

D2, 3, 4, 5 and 6.

E1, 2, 3, 4 and 6.

F1, 2, 3, 4, 5, 6 and 7.

Show Answer

Correct Answer: C

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