1Z0-076Preview

Examine this command executed on a physical standby database to transition it to a logical standby database:
SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY prodlgsby;
Which two statements are true regarding the execution of this command? (Choose two.)

Which three are true about the rolling release upgrade method for Data Guard environments using a transient Logical Standby database? (Choose three.)

You must configure an Oracle Data Guard environment consisting of:

1. A primary database
2. Two physical standby databases
   Examine these requirements:
3. Data loss is not permitted.
4. It should be possible to convert either of the physical standby databases to a snapshot standby database.
5. Under normal operations, transactions should not commit before redo is written to disk on both the primary database and at least on one standby database.
6. The availability of the primary database should not be compromised by the availability of the standby databases.
7. It should be possible to enable fast-start failover.
8. It should be possible to deploy Real Application Clusters on all databases.
   You configure FASTSYNC redo transport mode to both standby databases in combination with Maximum Availability mode.
   Which requirements will you meet?

You must configure an Oracle Data Guard environment consisting of:

1. A primary database
2. A physical standby database
   Examine these requirements:
3. Data loss is not permitted.
4. It should be possible to convert the physical standby database to a snapshot standby database.
5. 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.
6. The availability of the primary database should not be compromised by the availability of the standby database.
7. It should be possible to convert the physical standby database to a logical standby database.
8. It should be possible to deploy Real Application Clusters on the primary database.
9. It should be possible to deploy Real Application Clusters on the physical standby database.
   You configure SYNC AFFIRM redo transport mode in combination with Maximum Protection mode.
   Which requirements will you meet?

Which three are true about using Flashback database through role transitions in a Data Guard environment? (Choose three.)

Which TWO statements are true for Data Guard environments with multi-tenant databases? (Choose two.)

You created a physical standby database PRODSBY1 from the primary database PROD using SQL and RMAN.
Which THREE are prerequisites for creating a Data Guard Broker configuration to manage these databases? (Choose three.)

You created the PRODSBY1 physical standby database for the PROD primary database using SQL 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? (Choose three.)

Which three are true concerning database states after a successful switchover? (Choose three.)

You must configure an Oracle Data Guard environment consisting of:

1. A primary database
2. A physical standby database
3. A snapshot standby database
   You must meet these requirements:
4. A primary database availability should not be compromised by the availability of the standby databases.
5. Under normal operations, transactions executed on the primary database should not commit before redo is written to disk on the primary database and on at least one standby database.
   Which redo transport mode and which protection mode would you configure to meet these requirements?

A query on the view DBA_LOGSTDBY_UNSUPPORTED on your primary database returns several rows.
As a result of this, you decide that an upgrade may not use logical standby databases.
Which three are true about upgrading Data Guard environments consisting of one physical standby database running on a separate host from the primary? (Choose three.)

You must propose an Oracle Data Giard configuration for a database supporting an OLTP workload that meets these permanent requirements:

1. Data loss is not permitted.
2. Read-only applications should not connect to the primary database instance.
   Additionally, there are these requirements, only one of which is ever done at any one time:
3. It should be possible to apply and test designed patches with a minimum amount of downtime.
4. Upgrading to a new database release should be performed with the least possible amount of downtime.
5. New application software releases should be tested against an exact up-to-date replica of the production database.
   You propose a primary database with one physical database configured in Maximum Protection mode.
   Which requirements to you meet?

You notice 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? (Choose four.)

You have a Data Guard broker configuration consisting of:

1. A primary database
2. One local physical standby database
3. One far sync instance
4. A remote physical standby database
   The broker configuration was created DGMGRL utility after creating all the databases and the far sync instance with command-line tools.
   What is the correct way to add this configuration to the Enterprise Manager Cloud Control assuming all the nodes have been discovered already as Enterprise Manager targets?

Which THREE statements are true about snapshot standby databases? (Choose three.)

You have a Data Guard Broker configuration called ‘Somewhere’ as shown:

You then run this command:
DGMGRL> SHOW DATABASE 'Nearby' 'InconsistentProperties';
Which two are true about the output of this DGMGRL command? (Choose two.)

On your logical standby database, you specified these rules:

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

Which TRUE regarding the execution of the UNSKIP procedure?

Which two are true about managing and monitoring Oracle container databases in a Data Guard environment using the broker? (Choose two.)

Which TWO statements are true about block media recovery in a Data Guard environment? (Choose two.)

A customer asks for your opinion about possible solutions for this requirement:

1. We plan a Data Guard Configuration with one primary and one standby database to protect against any regional disaster.
2. It is very important that there be no significant performance impact on the primary database.
3. Reports and backups must be offloaded to the standby database.
   Which recommendation would you make?

You 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? (Choose two.)

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

Which two factors can cause an increase in redo transport lag? (Choose two.)

A Data Guard environment has this configuration and these attributes:

1. The primary database prima is in the local region.
2. A physical standby database physt1 is in the local region.
3. A physical standby database physt2 is in a remote region.
4. The primary ships redo to physt1.
5. physt1 ships redo to physt2.
6. physt1 and physt2 have Real-Time Query enabled.
   A sequence has been created with this SQL statement in the primary database:
   CREATE SEQUENCE A NOCACHE SESSION;
   Which TWO statements are TRUE? (Choose two.)