Exam 1z0-066 topic 1 question 27 discussion

Actual exam question from Oracle's 1z0-066

Question #: 27
Topic #: 1

[All 1z0-066 Questions]

Which four requirements can be met by deploying a logical standby database?

A. Support for workloads requiring additional indexes.
B. It can be used to create additional schemas.
C. It can be used to create additional tables.
D. It must have the same physical structure as the primary database.
E. it must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.
F. Support for workloads requiring additional materialized views.
G. It can be used for Real Application Testing without affecting the disaster recovery capabilities.

Show Suggested Answer

Suggested Answer: ACEG 🗳️
A: DDL Statements supported by a Logical Standby Database include:

ALTER INDEX -

CREATE INDEX -

DROP INDEX -
C: DDL Statements supported by a Logical Standby Database include:

CREATE TABLE -

DROP TABLE -
Incorrect Answers:
D: The physical organization in a logical standby database is different from that of the primary database, even though the logical standby database is created from a backup copy of the primary database.
F: DDL Statements not supported by a Logical Standby Database include:

CREATE MATERIALIZED VIEW -
References:
https://docs.oracle.com/cd/E11882_01/server.112/e41134/create_ls.htm#SBYDB4731 https://docs.oracle.com/cd/B28359_01/server.111/b28294/data_support.htm

by FelipeK at Oct. 22, 2020, 12:43 p.m.