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

• A.It allows fast incremental backups to be offloaded to the physical standby database.
• B.It starts the CTWR process on the physical standby database instance.
• C.It allows fast incremental backups to be taken on the primary database.
• D.It starts the RVWR process on the physical standby database instance.
• E.It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database in converted.
• F.It starts the CTWR process on the primary database instance.

Comment: *

Name: *

Email: *

Verification: *

Examine the Fast-start configuration:
DGMGRL> show fast_start failover;
Fast-Start Failover: ENABLED
Threshold : 30 seconds
Target: sheep
Observer : ol7.example.com
Lag Limit: 30 seconds (not in use)
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Observer Reconnect: (none)
Observer Override: FALSE
Configurable Failover Conditions
Health Conditions:
Corrupted Controlfile YES
Corrupted Dictionary YES
Inaccessible Logfile NO
Stuck Archiver YES
Datafile Offline YES
Oracle Error Conditions:
(none)
Which three are true? (Choose three.)

• 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.

Comment: *

Name: *

Email: *

Verification: *

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

• A.Different pluggable databases within a logical standby database may have different guard statuses.
• B.The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation.
• C.The Data Guard broker automatically opens all pluggable databases of a primary database a role change operation.
• D.The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standby database.
• E.A multi-tenant standby database can have fewer pluggable databases than the primary container database.

Comment: *

Name: *

Email: *

Verification: *

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

• A.The sequence is usable on physt1 and physt2.
• B.The sequence is usable on physt1 but not usable on physt2.
• C.The sequence is usable on physt2 if physt1 becomes unavailable, but only if an alternative redo destination has been configured on the primary database.
• D.physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on the primary database.
• E.physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.

Comment: *

Name: *

Email: *

Verification: *

Examine this query and its output:
SQL> select fs_failover_status, fs_failover_current_target,
2 fs_failover_observer_present, fs_failover_oserver_host
3 from v$database:
FS_FAILOVER_STATUS FS_FAILOVER_CURRENT_TARGET
FS_FAILOVER_OBSERVER_PRESENT FS_FAILOVER_OBSERVER_HOST
- -------------- ----------------------- ---------------- ------------------ BYSTANDER cats NO
O17.example.com
Which are true?

• A.The observer is not connected to the database on which the query was executed.
• B.Cats is a bystander database.
• C.The observer is connected to the database on which the query was executed.
• D.The observer is currently running on o17.example.com.
• E.The observer is not running, but should run on o17.example.com.

Comment: *

Name: *

Email: *

Verification: *