NEW QUESTION 1
Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled?

• A. if the CACHE option is set then the size of the cache must be at least 100
• B. Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary
• C. Their usage will always have a performance impact on the primary database.
• D. Their usage may have a performance impact on the physical standby database if the CACHE size is too small
• E. They must have the NOORDER and CACHE options set.

Answer: BDE

NEW QUESTION 2
Which three are always benefits of using a logical standby database?

• A. it can be used for database rolling release upgrades
• B. it can be used to replicate a single pluggable database (PDB) in a multitenant container database.
• C. It can be used as an updatable database for Real Application testing and then converted back to a standby database without affecting the updates.
• D. It can be used for reporting workloads requiring additional indexes or materialized views or both.
• E. It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.
• F. it can be used for testing patches without affecting the primary database.

Answer: CDF

NEW QUESTION 3
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?

• A. Increase the size of the buffer cache on the physical standby database instances.
• B. Increase the number of standby redo log files on the standby databases.
• C. Decrease the redo log file size on the primary database.
• D. Lower DB_BLOCK_CHECKING to MEDIUM or LOW on the standby databases.
• E. Increase the size of standby redo log files on the standby databases.

Answer: AD

NEW QUESTION 4
Which three statements are true about snapshot standby databases?

• A. Tablespaces can be dropped.
• B. Tables can be dropped
• C. The broker may be used to fail over to a snapshot standby database.
• D. A logical standby database can be converted into a snapshot standby database.
• E. Tablespaces can be created.

Answer: ABE

NEW QUESTION 5
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?

• A. Increase the size of the buffer cache on the physical standby database instances.
• B. Increase the number of standby redo log files on the standby databases.
• C. Decrease the redo log file size on the primary database.
• D. Lower DB_BLOCK_CHECKING to MEDIUM or LOW on the standby databases.
• E. Increase the size of standby redo log files on the standby databases.

Answer: AD

NEW QUESTION 6
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?

• A. 5,2.4,3,6,1
• B. 1,5,2,4,6,3
• C. 5,2,4,6,3,1
• D. 4,6,5,2,3,1
• E. 5,2,4,1

Answer: A

NEW QUESTION 7
Your Data Guard environment has two remote physical standby databases
Client applications use the local naming method to connect to the primary database instance.
You want applications to automatically connect to the new primary database instance in case of a switchover or a failover
Which will fulfill this requirement?

• A. Create a database service on each standby database that is started automatically by a trigger, when the database rote is PRIMARY, modify the connection description used by client applications to include all the standby hosts and connect to the database instance using that service name.
• B. Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY, modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.
• C. Set the INSTANCE_NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.
• D. Set the DB_NAME and DB_UNIQUE_NAME identical on all databases, modify the connection descriptors on client applications to include all the standby hosts and connect to the database using that service name.

Answer: A

NEW QUESTION 8
A customer has these requirements for their potential 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:

Which Data Guard broker commands are needed to implement these requirements?

• A. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (pnma: physt2 SYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY
• B. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1 ASYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima physt FASTSYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION
• C. EDIT DATABASE prima SET PROPERY REDOROUTES^' (LOCAL: fs1 SYNC)'; EDIT FAR_SYNCfs1 SET PROPERTY REDORUOTES=' (prima physt ASYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
• D. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1, FASTSYNC)'; EDIT DATABASE prima SET PROPERY REDOROUTES= (LOCAL: fs1. FASTSYNC)'; EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=' (prima: physt2 ASYNC)'; EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

Answer: A

NEW QUESTION 9
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.

• A. Increase the PROCESSES initialization parameter
• B. Increase the value for the MAX_SERVERS SQL apply parameter.
• C. Decrease the number of archiver processes on the standby databas
• D. increase the PARALLEL_MAX_SERVER initialization parameter
• E. Decrease the number of PREPARER processes
• F. Increase the RECOVERY_PARALLEUSM initialization parameter

Answer: BE

NEW QUESTION 10
Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled?

• A. if the CACHE option is set then the size of the cache must be at least 100
• B. Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary
• C. Their usage will always have a performance impact on the primary database.
• D. Their usage may have a performance impact on the physical standby database if the CACHE size is too small
• E. They must have the NOORDER and CACHE options set.

Answer: BDE

NEW QUESTION 11
You must manually reinstate a database using DGMGRL
To which database should you connect with DGMGRL before issuing the REINSTATE command and in which state should the target database be?

• A. The target database should be in NOMOUNT state and DGMGRL should be connected to any database that is a member of the configuration
• B. The target database should be MOUNTED and DGMGRL should be connected to any database that is a member of the configuration
• C. The target database should be MOUNTED and DGMGRL should be connected to the primary database.
• D. The target database should be MOUNTED and DGMGRL should be connected to the target database
• E. The target database should be in NOMOUNT state and DGMGRL should be connected to the primary database

Answer: C

NEW QUESTION 12
Which three are true concerning restoring of RMAN backups to primary and physical standby databases in a Data Guard environment?

• A. Backups of data files taken on the primary database may be restored on a physical standby database.
• B. Backups of control files taken on the primary database may not be restored and used on a physical standby database.
• C. Backups of SPFILEs taken on a physical standby database may not be restored on the primary database.
• D. Backups of control files taken on a physical standby database may be restored on the primary database.
• E. Backups of data files taken on a physical standby database may be restored on a pnmary database.
• F. Backups of SPFILEs taken on the primary database may not be restored and used on a physical standby database.

Answer: CEF

NEW QUESTION 13
A query on the view DBA_LOGSTBY_UNSUPPORTED on your primary database returns no rows
As a result of this, you decide that an upgrade may use logical standby databases. Which two are true about upgrading Data Guard environments consisting of one logical
standby database running on a separate host from the primary?

• A. The upgrade always requires downtown until the upgrade of the logical standby is completed
• B. Using manual upgrade, catctl.pl can be executed in some cases on the primary and standby database simultaneously.
• C. The upgrade always required downtime until the upgrade of the primary is completed
• D. Using manual upgrade, catupgr.sql needs to run on the primary database only.
• E. SQL Apply on the local standby database must be stopped while the primary database is upgraded.
• F. Fast-Start Failover can be used to protect the primary database during the upgrade.

Answer: BE

NEW QUESTION 14
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2 One Physical Standby Database
3. One Logical Standby Database You must meet these requirements:
1. Primary database availability should not be compromised by the availability of the standby databases.
2. Under normal operations, transactions executed on the primary database should not commit before redo is written to disk on both the primary database and at least one standby database.
Which redo transport mode and which protection mode would you configure to meet these requirements?

• A. SYNC AFFIRM and Maximum Protection
• B. SYNC NOAFFIRM and Maximum Protection
• C. SYNC AFFIRM and Maximum Availability
• D. SYNC NOAFFIRM and Maximum Availability
• E. ASYNC and Maximum Performance

Answer: C

NEW QUESTION 15
Which two are true about database roles in an Oracle Data Guard Configuration?

• A. a configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.
• B. A Logical Standby Database can be converted to a Snapshot Standby Database.
• C. A Logical Standby Database can cascade redo to a terminal destination
• D. A Snapshot Standby Database can be a fast-start failover target
• E. A Physical Standby Database can be converted into a Logical Standby Database.

Answer: BE

NEW QUESTION 16
Your Data Guard environment has one physical standby database using Real-Time Query. Two sentences have been created by these SQL statements:
create sequence a global; create sequence b session; Neither sequence has been used since being created
Session 1 connects to the primary database instance and issues these two SQL statements:
SELECT a.nextval FROM DUAL; SELECT b nextval FROM DUAL;
Then session 2 connects to the physical standby database instance and issues the same SQL statements.
What output will be seen for session 2?

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: C

NEW QUESTION 17
You administer a Data Guard environment with a primary and two physical standby databases.
One of the physical standby databases is used for reporting and is on the same host as the primary database.
The other physical standby database is remote, used for disaster recovery and REDO is routed to it via a far sync instance.
Backups are offloaded to the remote physical standby.
Which three are true concerning the management of archive logs in this Data Guard configuration?

• A. Archive logs on the primary database may be deleted once they are applied on all standby databases.
• B. Archive logs on the primary database may be deleted once they are shipped on all standby databases.
• C. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they backed up at least once on the remote physical standby database.
• D. The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they are applied on all standby databases.
• E. Archive logs on the primary database may be deleted once they are archived locally to disk.

Answer: ADE

NEW QUESTION 18
Which two Data Guard features require the use of flashback database by the broker?

• A. Read-Mostly physical standby implementations
• B. Far Sync Instances
• C. Fast-Start Failover
• D. Real Time Query
• E. Snapshot Standby databases

Answer: CE

NEW QUESTION 19
......