Exam 1z0-066 topic 1 question 35 discussion

Actual exam question from Oracle's 1z0-066

Question #: 35
Topic #: 1

[All 1z0-066 Questions]

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.

Show Suggested Answer

Suggested Answer: ABE 🗳️
Incorrect Answers:
Not C: A snapshot standby database cannot be the target of a switchover or failover. A snapshot standby database must first be converted back into a physical standby database before performing a role transition to it.
D: A snapshot standby database is a fully updatable standby database that is created by converting a physical standby database into a snapshot standby database.
References:
https://docs.oracle.com/cd/B28359_01/server.111/b28294/manage_ps.htm

by ra2020 at May 17, 2020, 6:07 a.m.

Comments

Submit Cancel

Rockfics

1 year, 3 months ago

Selected Answer: ABE

Answe ABE Every operation DML or DDL are allowed because Flashback Database can undo later

upvoted 1 times

...

ScottL

1 year, 3 months ago

BCE - tablespaces cannot be dropped. C not entirely correct because a snapshot must be converted to a physical standby first. But the following steps can both be done via DGMGRL: 1. conversion to physical 2. failover to the new physical

upvoted 3 times

...

JESUSBB

2 years, 5 months ago

Answer: B, C and E

upvoted 4 times

...

ra2020

4 years, 8 months ago

A is wrong, you cannot drop a tablespace the restore point will generate an ORA-38881. Correct answer: B C E

upvoted 3 times

Sugar

3 years, 3 months ago

Snapshot Standby Databases: Overview A snapshot standby database is a fully updatable standby database that is created by converting a physical standby database to a snapshot standby database. A snapshot standby database receives and archives—but does not apply—redo data from a primary database. Redo data received from the primary database is applied when a snapshot standby database is converted back to a physical standby database, after discarding all local updates to the snapshot standby database.