QUESTION 20
Which three are prerequisites for enabling Fast-Start Failover?

QUESTION 21
You are planning to perform block comparison using the dbms comp package:

Which TWO statements are true?

QUESTION 22
In Oracle Database 19c, you can set the value of database initialization parameters in a database using the EDIT DATABASE… SET PARAMETER Command:
DGMGRL> EDIT DATABASE ‘boston’ SET PARAMETER log_archive_trace – 1;
Which THREE statements are TRUE about the command?

QUESTION 23
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?

QUESTION 24
Which THREE statements are true about snapshot standby databases?

QUESTION 25
You must configure an Oracle Data……….
1. A primary database
2. A physical standby database
Examine these requirements: 1. Data loss is not permitted.
1. Data loss is not permitted.
2. It should be possible to convert the physical standby database to a snapshot standby database.
3. Under normal operations, transactions should commit when redo is written to disk on the primary database and as soon as it has been received by the standby database instance.
4. The availability of the primary database should not be compromised by the availability of the standby database.
5. It should be possible to convert the physical standby database to a logical standby database
6. It should be possible to deploy Real Application Clusters on the primary database.
7. It should be possible to deploy Real Application Clusters on the physical standby database.
You configure SYNC redo transport mode in combination with Maximum Protection mode.

QUESTION 26
Which THREE statements are true…….. open in real time query mode, which becomes a new.

QUESTION 27
Examine this validate command:
DGMGRL> VALIDATE DATABASE VERBOSE “<database name>”;
Which THREE statements are TRUE?

QUESTION 28
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.

QUESTION 29
Which three types of backups offload …….. with the primary database in a data Guard

QUESTION 30
Which three are prerequisites for using Data Guard Broker?

QUESTION 31
A customer asks for your recommendation regarding this requirement:
1. We plan to have a Data Guard Configuration with one primary database and one physical standby database.
2. We want zero data loss in case of a disaster involving the loss of one component.
3. We want to do Real Application Testing occasionally on the Standby Database.
Which solution, if any, satisfies these requirements?

QUESTION 32
You are using Data Guard in conjunction with Global Database Services.
You have a Data Guard Broker configuration called Sales and a GDS pool called Prod.
Which three are true concerning the management of the broker configuration when using GDS?

QUESTION 33
You created a physical standby database prodsbyi from the primary database prod using SQL and RMAN.
Which THREE are prerequisites for creating a Data Guard Broker configuration to manage these databases?

QUESTION 34
Which three statements are true about snapshot standby databases?

QUESTION 35
Which three actions are performed by the START PLAN procedure of the DBMS ROLLING package?

QUESTION 36
Examine this list of possible steps:
1. Raise the compatibility level on both databases.
2. Restart SQL Apply on the upgraded logical standby database.
3. Start SQL Apply on the old primary database.
4. Perform a Switchover to the logical standby database.
5. Upgrade the logical standby database.
6. Upgrade the old primary database.
Which is the minimum number of steps in the correct order, to perform a rolling release upgrade of a data guard environment using an existing logical standby database and to enable the new functionality?

QUESTION 37
Which two statements are true regarding Data Guard environments in an Oracle Muti-tenant architecture?

QUESTION 38
Which TWO are benefits of using Transaction Guard in a Data Guard environment?

QUESTION 39
Which two statements are true regarding asynchronous redo transport in a Data Guard

QUESTION 40
You created two remote physical standby databases using SQL and RMAN.
The primary database is a four-instance RAC database and each physical standby database has two instances.
Roles-based services are used for client connectivity and have been defined in the Grid Infrastructure.
Consider these operational requirements:
* The ability to manage multiple standby databases with a single tool
* The simplification of switchovers, failovers, reinstatements, and conversions to and from snapshot standby databases
* The automation of failovers to a specified target standby database
Which TWO tools can be used to fulfill these requirements7

QUESTION 41
You are licensed to use Oracle Active Data Guard.
Which TWO statements are true after enabling block change tracking on a physical standby database?

QUESTION 42
Which THREE steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?

QUESTION 43
Examine the Data Guard configuration:

What happens if you issue “switchover to sheep;” at the DGMGRL prompt?