새 질문 47
Examine the fast-start failover configuration:

새로운 질문 48
Which three actions are performed by the START PLAN procedure of the DBMS ROLLING package?

새 질문 49
You notice that the SQL apply lag on your logical standby database has increased but the redo transport lag has not.
Which four could be reasons for the increase in SQL apply lag?

새 질문 50
Which three are prerequisites for using Data Guard Broker?

새 질문 51
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration – Animals
Protection Mode: Max Availability
Databases:
dogs – Primary database sheep
– Physical standby database cats
– Physical standby database
Fast-Start Failover: DISABLED
Configuration Status: SUCCESS
An attempt to enable fast-start failover raises an error:
DGMGRL> enable fast_start failover;
Error: ORA-16693: requirements not met for enabling fast-start failover Failed.
Identify three possible reasons for this error.

새 질문 52
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?

새 질문 53
Your Data Guard configuration consists of these components and settings:
1. A primary database
2. A remote physical standby database
3. Real-time query is enabled
4. Redo transport mode is synchronous
5. Protection mode is maximum availability
6. The Data Guard broker is used
You notice that the standby destination fails to acknowledge reception of redo within net_timeout period of time.
Which is true in this scenario?

새 질문 54
Which FOUR database parameters might be affected by or influence the creation of standby databases?

새 질문 55
Your Data Guard configuration consists of these components and settings:
1. A primary database
2. A remote physical standby database
3. Real-time query is enabled
4. Redo transport mode is synchronous
5. Protection mode is maximum availability
6. The Data Guard broker is used
You notice that the standby destination fails to acknowledge reception of redo within net_timeout period of time.
Which is true in this scenario?

새 질문 56
Which three are true concerning database states after a successful switchover?

새 질문 57
Which four statements are true regarding SQL Apply filters for a logical standby database?

새 질문 58
Which feature is available when monitoring a Data Guard configuration using Enterprise Manager Cloud Control, but is not available using DGMGRL or by using SQL?

새 질문 59
The Oracle database 19c Observer is currently running on host1 and you wish to have it running on host2.
Examine this list of possible steps:
1) Stop the observer on host1
2) Disable Fast-Start Failover
3) Update the broker configuration with the new observer hostname
4) Enable Fast-Start Failover
5) Start the Observer on host2
Which contains the minimum required steps to move the observer to host2?

새 질문 60
You must configure on Oracle Data …….
1. A primary database
2. Three Physical Standby Databases
이러한 요구 사항을 검토하세요:
A designated physical standby database should become the primary database automatically whenever the primary database fails.
2. The chosen protection mode should provide the highest level of protection possible without violating the other requirement.
Which redo transport mode and protection mode would you configure to meet these requirements?

새 질문 61
Which TWO statements are true for Data Guard environments with multi-tenant databases?

새 질문 62
Your expertise is requested for these customer requirements:
The Data Guard environment must be in maximum protection mode.
Reports must be offloaded to a physical standby database.
There must be no lag between the primary and standby databases that affect the reports produced.
The primary database must be resilient in case of a single network failure.
Which solution is correct for these requirements?

새 질문 63
On your logical standby database, you specified these rules:

After completion of the weekend batch cycle you attempt to delete the SQL Apply filters:

Which is TRUE regarding the execution of the UNSKIP procedure?

새 질문 64
You created the PRODSBY1 physical standby database for the PROD primary database using gql and RMAN. You are planning to create a Data Guard Broker configuration. You execute the command:

Which three statements are true regarding the execution of the command?

새 질문 65
Examine the Data Guard configuration: DGMGRL> show configuration;
Configuration – Animals
Protection Mode: MaxPerformance
Databases:
dogs- Primary database
sheep – Physical standby database
cats- Snapshot standby database
Fast-Start Failover: DISABLED
Configuration Status: SUCCESS
You receive an error while attempting to raise the protection mode to Maximum Protection:
DGMGRL> edit configuration set protection mode as maxprotection;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode Failed.
What can you conclude based on this error?