Oracle Exam 1Z0-076 Topic 10 Question 16 Discussion

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

Question #: 16
Topic #: 10

Which two are true about managing and monitoring Oracle container databases in a Data Guard environment using the broker?

AIf the primary database is not a container database, then a standby may be a container database.

BIf the primary database is a container database, then a physical standby may be a non-container database.

CIf the primary database is a container database, then a logical standby may be a non-container database.

DAll broker actions execute at the root container for container databases.

EAfter a role change, the broker opens all Pluggable databases (pdbb) on the new primary.

Show Suggested Answer

Suggested Answer: A, B, C, E

The rate of SQL apply on a logical standby database can be influenced by:

A: The number of PREPARER processes (which seems to be a typographical error and should read as PREPARER or similar) which prepare the redo data for the applier processes.

B: The number of coordinator processes on the standby database instance which coordinate the SQL apply activities.

C: The number of full table scans performed by SQL apply since full table scans can be resource-intensive and slow down the apply rate.

E: The number of applier processes which apply the redo data to the logical standby database.

Option D is incorrect as the size of the undo tablespace on the logical standby database is more likely to affect the SQL apply lag rather than the rate of SQL apply.

Option F is incorrect because the size of the shared pool would typically not influence the rate of SQL apply. The shared pool is more related to the caching of shared SQL and PL/SQL code and control structures.

by Cory at Aug 02, 2024, 07:42 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Elizabeth

28 days ago

A and D seem like the logical choices here. But who knows, maybe Oracle is just trying to trip us up with this one. Time to break out the crystal ball and consult the database gods!

upvoted 0 times

Bulah

22 hours ago

Let's hope we're right, Oracle can be tricky sometimes.

upvoted 0 times

...

Amber

4 days ago

Yeah, those seem like the most logical options.

upvoted 0 times

...

Alison

14 days ago

I think A and D are the correct choices.

upvoted 0 times

...

Felix

30 days ago

This question is a real head-scratcher. I'll just guess and hope for the best. Maybe I'll get lucky and land a job in container gardening instead!

upvoted 0 times

...

Roosevelt

1 months ago

E is definitely not correct. The broker doesn't automatically open all the PDBs on the new primary after a role change. That would be way too much automation, even for Oracle!

upvoted 0 times

...

Leatha

1 months ago

I think B and C are also true. If the primary is a container database, then the physical or logical standby can be a non-container database. Gotta cover all the bases!

upvoted 0 times

Rasheeda

4 days ago

I think it's great that the broker can handle different configurations seamlessly.

upvoted 0 times

...

Carey

5 days ago

Definitely, it's good to have options depending on the setup of the primary database.

upvoted 0 times

...

Jose

15 days ago

I agree, having the flexibility to choose between container and non-container databases for standby is important.

upvoted 0 times

...

Reena

1 months ago

I'm pretty sure the correct answers are A and D. The broker actions execute at the root container, and a physical standby can be a non-container database if the primary is a container database.

upvoted 0 times

Elroy

3 days ago

Yes, that's correct. And if the primary is a container database, the standby can be a non-container database.

upvoted 0 times

...

Gearldine

15 days ago

So the broker actions always execute at the root container?

upvoted 0 times

...

Yuette

26 days ago

I think you're right, A and D are the correct answers.

upvoted 0 times

...

Francine

2 months ago

I'm not sure about option C, but I think option D is true because all broker actions do execute at the root container for container databases.

upvoted 0 times

...

Helene

3 months ago

I agree with you, Bernardo. Option B also seems correct to me because a physical standby can be a non-container database if the primary is a container database.

upvoted 0 times

...

Bernardo

3 months ago

I think option A is true because a standby can be a container database if the primary is not.

upvoted 0 times

...