Free certification test prep

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

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

QUESTION 21
Which three can be done using Data Guard Broker?

QUESTION 22
Which four requirements can be met by deploying a logical standby database?

QUESTION 23
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 24
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 25
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 26
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?

QUESTION 27
Which THREE statements are true about Far Sync instances?

QUESTION 28
Which THREE statements are true about Far Sync instances?

QUESTION 29
Examine the Data Guard configuration after an accidental switchover to Sheep:
DGMGRL> show configuration;
Configuration – Animals
Protection Mode: MaxAvailability
Databases:
sheep – Primary database
dogs – Logical standby database
cats – Physical standby database (disabled)
ORA-16795: the standby database needs to be re-created
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Which three statements will be true after a switchover to Dogs?

QUESTION 30
A customer has these requirements for their proposed Data Guard implementation:
1. Zero data loss must still be guaranteed through the loss of any one configuration component.
2. The primary database must be protected against a regional disaster.
3. Performance overheads on the primary should be minimized as much as possible given these requirements.
4. Downtime on the primary database for any reason must be kept to a minimum.
Components referred to in the broker commands are:

QUESTION 31
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration – Animals
Protection Mode: MaxAvailability
Databases:
dogs – Primary database
sheep – Snapshot standby database
cats – Physical 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.
Which is the minimum statement, or sequence of statements you must execute to enable successful raising of the protection mode to Maximum Protection?

QUESTION 32
Which two are true concerning the configuring of Flashback database in a Data Guard environment?

QUESTION 33
Examine the Data Guard configuration:

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

QUESTION 34
Your Data Guard environment consists of these components and settings:
1. A primary database
2. Two remote physical standby databases
3. The redo transport mode is set to sync
4. Real-time query is enabled for both standby databases
5. The DB_BLOCK_CHECKING parameter is set to TRUE on both standby databases You notice an increase in redo apply lag time on both standby databases.
Which two would you recommend to reduce the redo apply lag on the standby databases?

QUESTION 35
Which THREE are true about using flashback database in a Data Guard environment?

QUESTION 36
Which TWO observations are true about the Far Sync instance?

QUESTION 37
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 38
Which three Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control?

QUESTION 39
Which TWO are TRUE about offloading backups to a physical standby database in a Data Guard environment?

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

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