Oracle Exam 1Z0-888 Topic 3 Question 33 Discussion

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

Question #: 33
Topic #: 3

You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-type is set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented.

Which two facts can be concluded from the given output? (Choose two.)

AThe slave has two intermediate relay slaves connected to it.

BThe slave is configured with slave_parallel_workers = 4

CAt most, two schemas are being updates concurrently.

DTHREAD_ID 21 has stopped running.

EThe slave cannot process the relay log fast enough to use all threads.

FThe server needs more cores to use all slave threads.

Show Suggested Answer

Suggested Answer: B, E

by Salena at May 07, 2022, 10:43 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!