1Z0-076: Oracle Database 19c: Data Guard AdministrationDemo

By Oracle · Question Mode

QuestionQ5

Oracle Data Guard Overview

Which three statements are accurate about snapshot standby databases?

Choose three
  • A A logical standby database can be converted into a snapshot standby database.
  • B Tables can be dropped.
  • C The FAILOVER TO command results in a transition of a snapshot standby database to the primary role.
  • D The SWITCHOVER TO command allows a switchover operation to a snapshot standby database.
  • E Tablespaces can be created.
  • F Tablespaces can be dropped.
Explanation

A snapshot standby database is opened read-write and is fully updatable, permitting operations such as dropping tables and creating tablespaces. It can be the target of a manual FAILOVER TO operation; the broker converts it to a physical standby, applies accumulated redo, and transitions it to the primary role. A switchover to a snapshot standby is not allowed, and a dropped tablespace’s data file cannot be restored by Flashback Database.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!