Oracle Exam 1Z0-078 Topic 12 Question 20 Discussion

Actual exam question for Oracle's 1Z0-078 exam

Question #: 20
Topic #: 12

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 Suggested Answer

Suggested Answer: B, C, F

by Laurel at Jun 29, 2024, 06:52 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-078 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Leonora

4 months ago

Ah, the GRD, the bane of every Oracle DBA's existence! I bet the developers who came up with this stuff were having a field day coming up with all these confusing terms.

upvoted 0 times

...

Jacki

4 months ago

I know my stuff when it comes to Oracle RAC, so I'm pretty confident I can nail this one. Let's see, B, C, and G sound like the right choices to me.

upvoted 0 times

Orville

3 months ago

G is correct too, RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.

upvoted 0 times

...

Gertude

4 months ago

I agree, C is also true because Clustered ASM has GRD resources distributed among all ASM instances.

upvoted 0 times

...

Bo

4 months ago

I think B is correct because shadow GRD resources can exist in more than one database instance.

upvoted 0 times

...

Kaitlyn

5 months ago

Haha, this question is like a maze of Oracle jargon! I'm just going to guess and hope for the best. Maybe I'll get lucky and impress the interviewer with my RAC knowledge.

upvoted 0 times

Marg

3 months ago

I'm going with G) RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.

upvoted 0 times

...

Marg

3 months ago

I believe F) RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.

upvoted 0 times

...

Marg

3 months ago

I think B) Shadow GRD resources may exist in more than one database instance for a resource.

upvoted 0 times

...

Levi

3 months ago

I'm going with G) RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.

upvoted 0 times

...

Leatha

4 months ago

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

upvoted 0 times

...

Levi

4 months ago

I believe F) RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.

upvoted 0 times

...

Ashleigh

4 months ago

C) Clustered ASM has GRD resources distributed among all ASM instances.

upvoted 0 times

...

Chan

4 months ago

A) Only one GRD shadow resource may exist for an Enqueue Resource.

upvoted 0 times

...

Levi

4 months ago

I think B) Shadow GRD resources may exist in more than one database instance for a resource.

upvoted 0 times

...

Rodolfo

5 months ago

Interesting, Erin. Can you explain why you think those are true?

upvoted 0 times

...

Erin

5 months ago

I believe A, D, and G are the correct options.

upvoted 0 times

...

Ceola

5 months ago

I think A, C, and F are the correct answers. The GRD is all about resource management in a RAC environment, so it makes sense that the resources are distributed across the instances.

upvoted 0 times