Which three statements are true about snapshot standby databases?

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 […]

Read More

FS_FAILOVER_STATUS FS_FAILOVER_CURRENT_TARGET FS_FAILOVER_OBSERVER_PRESENT

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 […]

Read More

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

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. […]

Read More