Oracle Exam 1Z0-888 Topic 7 Question 90 Discussion

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

Question #: 90
Topic #: 7

You have created a backup of the 'sales' database with the command:

Which two procedures can be used to restore the 'orders' table from the backup?

ACheck the rate of change in the status value Aborted_connects and compare to the rate of change in Connections.

BCheck the difference between the InnoDB status values ''Log Sequence number'' and ''Last Checkpoint'' positions then compare that to the total size of the redo log.

CCheck the rate of change in the status value Select_scan and compare to the rate of change in Com_select.

DCheck the difference between the InooDB status values ''Trx id counter'' and ''Purge done for'' and compare to the state substatus of the main ''Main thread''

ECheck the rate of change in the statis value Qcache_hits and compare that to the rate of change of Qcache_not_cached.

Show Suggested Answer

Suggested Answer: B, E

by Lillian at Apr 29, 2024, 05:53 PM

Limited Time Offer

25%

7 months ago

This exam question is tricky. I hope it's not too frequent.

upvoted 0 times

...