- Home
- Oracle
- Oracle Database 12c: Data Guard Administrator
- Oracle.1Z0-066.v2018-04-26.q92
- Question 89
Valid 1Z0-066 Dumps shared by ExamDiscuss.com for Helping Passing 1Z0-066 Exam! ExamDiscuss.com now offer the newest 1Z0-066 exam dumps, the ExamDiscuss.com 1Z0-066 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1Z0-066 dumps with Test Engine here:
Access 1Z0-066 Dumps Premium Version
(112 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 89/92
There are currently 6 APPLIER and 6 PREPARER processes running and no idle APPLIER processes on your logical standby database.
The MAX_SERVERS SQL apply parameter and number of archiver processes are both set to 12.
Identify two changes, each of which would allow you to increase the number of APPLIER processes.
The MAX_SERVERS SQL apply parameter and number of archiver processes are both set to 12.
Identify two changes, each of which would allow you to increase the number of APPLIER processes.
Correct Answer: B,E
Explanation/Reference:
There are three parameters that can be modified to control the number of processes allocated to SQL Apply: MAX_SERVERS, APPLY_SERVERS, and PREPARE_SERVERS. The following relationships must always hold true:
APPLY_SERVERS + PREPARE_SERVERS = MAX_SERVERS - 3
This is because SQL Apply always allocates one process for the READER, BUILDER, and ANALYZER roles.
References: https://docs.oracle.com/cd/B28359_01/server.111/b28294/manage_ls.htm
There are three parameters that can be modified to control the number of processes allocated to SQL Apply: MAX_SERVERS, APPLY_SERVERS, and PREPARE_SERVERS. The following relationships must always hold true:
APPLY_SERVERS + PREPARE_SERVERS = MAX_SERVERS - 3
This is because SQL Apply always allocates one process for the READER, BUILDER, and ANALYZER roles.
References: https://docs.oracle.com/cd/B28359_01/server.111/b28294/manage_ls.htm
- Question List (92q)
- 1 commentQuestion 1: Which two statements are true for Data Guard environments wi...
- Question 2: A customer has these requirements for their potential Data G...
- Question 3: Which three statements are true about standby redo logs in a...
- 1 commentQuestion 4: Examine this query and its output: SQL> select fs_failove...
- Question 5: You must configure an Oracle Data Guard environment consisti...
- 1 commentQuestion 6: Which four requirements can be met by deploying a logical st...
- Question 7: Which two are true about the usage of DBMS_ROLLING?...
- Question 8: Examine the Data Guard configuration: DGMGRL > show confi...
- Question 9: Attempting to start the observer raises an error: DGMGRL>...
- Question 10: Which three statements are true about snapshot standby datab...
- Question 11: Your Data Guard environment has one physical standby databas...
- 2 commentQuestion 12: Which three steps are prerequisites for the creation of a ph...
- Question 13: You must use a physical standby database file to recover a d...
- Question 14: Examine the Data Guard configuration: DGMGRL> show config...
- Question 15: Which three are true concerning Automatic Block Media Recove...
- Question 16: Which two are prerequisites for enabling Automatic Block Med...
- Question 17: Which three are always benefits of using a logical standby d...
- Question 18: A Data Guard environment has this configuration and these at...
- Question 19: Examine the Fast-start configuration: DGMGRL> show fast_s...
- Question 20: A query on the view DBA_LOGSTDBY_UNSUPPORTED on your primary...
- Question 21: Your Data Guard environment consists of these components and...
- Question 22: After converting your physical standby database to a logical...
- Question 23: Which three statements are true about Global Sequences when ...
- Question 24: Which two are true about offloading backups to a physical st...
- Question 25: Attempting to start the observer raises an error: DGMGRL>...
- Question 26: You are licensed to use Oracle Active Data Guard. Which two ...
- Question 27: Which three are true concerning restoring of RMAN backups to...
- Question 28: You must manually reinstate a database using DGMGRL. To whic...
- Question 29: Examine the Data Guard configuration after an accidental swi...
- Question 30: Which statement is true regarding Oracle Net connectivity fo...
- Question 31: Which three statements are true about Far Sync instances?...
- Question 32: Which three are true about using RMAN in a Data Guard enviro...
- Question 33: Which three types of backups taken in which situations may b...
- Question 34: Which two are true about the use of RMAN recovery catalogs w...
- Question 35: Examine this list of possible steps: 1.Raise the compatibili...
- Question 36: Examine the Data Guard configuration: DGMGRL> show config...
- Question 37: You have a Data Guard Broker configuration called 'Somewhere...
- Question 38: You must configure an Oracle Data Guard environment consisti...
- Question 39: Which four database parameters might be affected by or influ...
- Question 40: Which two statements are true for Data Guard environments wi...
- Question 41: A Data Guard environment has this configuration and these at...
- Question 42: Which two statements are true about Real-Time Query?...
- Question 43: Which two are prerequisites for configuring flashback databa...
- Question 44: Which two Data Guard features require the use of flashback d...
- Question 45: Which three factors can influence the rate of redo apply on ...
- Question 46: Which three statements are true about snapshot standby datab...
- Question 47: Your Data Guard environment consists of these components and...
- Question 48: Your Data Guard environment has two remote physical standby ...
- Question 49: Which two are prerequisites for creating a standby database ...
- Question 50: A data file on one of your physical standby databases has be...
- Question 51: Which four are true about DGMGRL show command?...
- Question 52: Which two statements are true regarding Data Guard Broker?...
- Question 53: Your Data Guard environment consists of these components and...
- Question 54: Which two Data Guard monitoring activities may be performed ...
- Question 55: Examine the Data Guard configuration: DGMGRL> show config...
- Question 56: Which three are true concerning database states after a succ...
- Question 57: Which three are benefits of using the Data Guard Broker to m...
- Question 58: Which two are true about database roles in an Oracle Data Gu...
- Question 59: You edit the DGConnectIdentifier database property using the...
- Question 60: In which two cases is it possible to change the protection m...
- Question 61: Examine the Data Guard configuration: DGMGRL > show confi...
- Question 62: Which four statements are true regarding SQL Apply filters f...
- Question 63: You are monitoring your Data Guard broker configuration and ...
- Question 64: You administer a Data Guard environment consisting of a prim...
- Question 65: Your Data Guard environment has two remote physical standby ...
- Question 66: Examine the Data Guard configuration: DGMGRL> show config...
- Question 67: Which two are true about management of a far sync instance w...
- Question 68: Which three are prerequisites for enabling Fast-Start Failov...
- Question 69: Which two are prerequisites for configuring Transaction Guar...
- Question 70: You must propose an Oracle Data Guard configuration for a da...
- Question 71: On your logical standby database, you specified these rules:...
- Question 72: Examine the Data Guard configuration: DGMGRL > show confi...
- Question 73: Which two are true about the creation of a Data Guard Broker...
- Question 74: Which two are true about rolling release upgrades in a Data ...
- Question 75: You are required to change the Data Guard Configuration prot...
- Question 76: Which three are required in order to use Real-Time Query wit...
- Question 77: Which three are among the various tasks performed by the dat...
- Question 78: Examine the Data Guard configuration: DGMGRL> show config...
- Question 79: Examine the Data Guard configuration: DGMGRL> show config...
- Question 80: Which three statements are true about Data Guard configurati...
- Question 81: Examine the Data Guard configuration: DGMGRL> show config...
- Question 82: A customer asks you to propose the most appropriate solution...
- Question 83: Which three are true regarding the Enterprise Manager Cloud ...
- Question 84: Your expertise is requested for these customer requirements:...
- Question 85: You administer a Data Guard environment with a primary and t...
- Question 86: Examine the Data Guard configuration: DGMGRL> show config...
- Question 87: You must configure an Oracle Data Guard environment consisti...
- Question 88: You must design an Oracle Data Guard configuration for an OL...
- Question 89: There are currently 6 APPLIER and 6 PREPARER processes runni...
- Question 90: Which four factors can influence the rate of SQL apply on a ...
- Question 91: You created a physical standby database PRODSBY1 from the pr...
- Question 92: A query on the view DBA_LOGSTBY_UNSUPPORTED on your primary ...
