Oracle Exam 1Z0-908 Topic 11 Question 86 Discussion

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

Question #: 86
Topic #: 11

[All 1Z0-908 Questions]

Four nodes are configured to use circular replication.

Examine these configuration parameters for each node:

Which statement is true?

AEach slave thread is responsible for updating a specific database.

BCross-database constraints can cause database inconsistency.

CIncreasing slave_parallel_workers will improve high availability.

DSetting slave_preserve_commit_order to on will improve data consistency.

ESetting slave_parallel_type=DATABASE won't work for circular replication; it should be set to LOGICAL_CLOCK.

FSetting transaction_allow_batching to on will improve data consistency.

Show Suggested Answer

Suggested Answer: D

by Natalie at Aug 24, 2024, 11:18 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Santos

8 months ago

I agree with Corinne, D seems like the best option for data consistency.

upvoted 0 times

...

Corinne

8 months ago

But setting slave_preserve_commit_order to on will ensure data consistency.

upvoted 0 times

...

Kenny

8 months ago

I disagree, I believe the correct answer is E.

upvoted 0 times

...

Audry

8 months ago

Haha, imagine setting transaction_allow_batching to on and then wondering why your data is a complete mess. That's like trying to untangle a plate of spaghetti.

upvoted 0 times

...

Viki

8 months ago

Hmm, I'm not sure about option C. Increasing the number of parallel workers doesn't necessarily improve high availability. It's more about fault tolerance.

upvoted 0 times

...

Patti

8 months ago

I'm gonna go with option B. Cross-database constraints can definitely cause issues in a circular replication environment.

upvoted 0 times

...

Dana

8 months ago

Option E sounds right to me. Circular replication requires slave_parallel_type to be set to LOGICAL_CLOCK, not DATABASE.

upvoted 0 times

Elfriede

7 months ago

Thanks for clarifying that. It's important to have the correct configuration for circular replication.

upvoted 0 times

...

Richelle

7 months ago

Option E is correct. Circular replication needs slave_parallel_type set to LOGICAL_CLOCK.

upvoted 0 times

...

Corinne

8 months ago

I think the correct answer is D.

upvoted 0 times

...

Alita

8 months ago

I think option D is the correct answer. Setting slave_preserve_commit_order to on will help maintain data consistency in a circular replication setup.

upvoted 0 times