Free Preparation Discussions
MENU
Oracle Exam 1Z0-076 Topic 7 Question 13 Discussion
Topic #: 7
Which TWO statements correctly describe the behavior of Automatic Block Media Recovery in a Data Guard environment, for a corrupt block in the example tablespace encountered by a session logged in as the SH user?
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.
Laura
1 months agoAnnmarie
13 days agoCraig
16 days agoHelaine
19 days agoMicaela
1 months agoShaun
6 days agoEssie
11 days agoEugene
18 days agoJohnetta
2 months agoGermaine
1 months agoGearldine
1 months agoTamar
1 months agoBarrett
2 months agoLai
2 days agoMargurite
12 days agoWhitney
19 days agoVallie
20 days agoGoldie
2 months agoBette
1 months agoWhitley
2 months agoMa
2 months agoChu
3 months agoVenita
3 months ago