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
Which three factors can influence the rate of redo apply on a physical standby database?
A. the network latency between the primary and standby databases
B. the number of archiver processes on the standby database
C. the number and size of standby redo logs on the primary database
D. the rate of redo generation on the primary database
E. the number and size of standby redo logs on the standby database
A customer asks you to propose the most appropriate solution for this set of requirements:
1.
We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
2.
We want to generate reports from the proposed standby database at the same time that it is used for other purposes.
3.
Developers may need to test occasionally on a copy of the live database.
You have to already confirmed that there are no unsupported data types on the primary database Which two solutions would you recommend?
A. a remote physical standby database with RedoRoutesvia a far sync instance
B. a snapshot standby database with synchronous redo transport
C. a physical standby database with real-time query enabled
D. a logical standby database
E. a read mostly implementation of a physical standby database
You must use a physical standby database file to recover a data file on a primary database in a Data Guard environment.
Which three of these steps must be performed on the primary database after the file has been backed up using RMAN on the physical standby database?
A. Connect to the primary database as the AUXILIARY.
B. Catalog the data file copy for RMAN to use on the primary database for restore.
C. Back up the data file as copy on the standby host to a location on the standby host.
D. Switch to the data file copy using the RMAN SWITCH command.
E. Back up the data file as copy on the standby host to a location on the primary host
F. Connect to the primary database as the TARGET.
Which three statements are true about Far Sync instances?
A. The Data Guard Broker must be used to deploy and manage Far Sync instances.
B. They enable standby database to be configured at remote distances from the primary without impacting performance on the primary.
C. A primary database can ship redo directly to multiple Far Sync instances.
D. They use as spfile, a standby controlfile, and standby redo logs.
E. They work with any protection level.
You administer a Data Guard environment consisting of a primary and three physical standby databases.
One physical standby database is used for disaster recovery, one is used for reporting, and one is used as a replica for testing. The standby database used for testing is occasionally converted into a snapshot standby database and
then converted back to a physical standby.
The physical standby database is the only standby that is a mandatory destination
The broker configuration operates in MAXIMUM PERFORMANCE mode.
Which ARCHIVELOG DELETION POLICY should be set. so that archive logs generated on the primary
database are not deleted before they are consumed appropriately on each of the standby databases, but which allows them to be deleted form the primary as soon as it is safe to do so?
A. CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY
B. CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
C. CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;
D. CONFIGURE ACHIVELOG DELETION POUCY TO SHIPPED TO STANDBY,
E. CONFIGURE ACHIVELOG DELETION POLICY TO NONE;
Which three statements are true about snapshot standby databases?
A. Snapshot standby databases may be used for rolling release upgrades.
B. if datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database.
C. Flashback logs are used to convert a snapshot standby database back into a physical standby database.
D. a snapshot standby database can have Real-Time Query enabled
E. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.
Which three statements are true about standby redo logs in a Data Guard configuration with no Oracle Streams or Goldengate configured?
A. They are required on a logical standby for real-time apply
B. They are required only for synchronous redo transport.
C. Only standby databases can write redo to them.
D. It is recommended to have them on the primary database.
E. They are required on a physical standby for real-time apply.
F. The LGWR process writes to them on a standby database.
Examine the Fast-start configuration
Oracle Error Conditions: (none) Which three are true?
A. The observer will initiate a failover when the primary database is unable to produce local archived redo log files.
B. An automatic failover will be initiated even if the target standby database lags behind the primary
C. The observer is running
D. a failover may occur if the observer has lost connectivity to the primary database, even if the Fast-Start Failover target standby database has a good connection to the primary database
E. The configuration operates in Maximum Availability mode
F. The configuration operates in Maximum Performance mode
The Oracle database 12c 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?
A. Execute only task 5.
B. Execute tasks 1, 3, and 5.
C. Execute tasks 1, 2, 3, 4, and 5.
D. Execute tasks 1 and 5.
