ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-066 All Questions

View all questions & answers for the 1z0-066 exam
Go to Exam

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

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
ScottL
1 year, 3 months ago
Selected Answer: ABCF
Choosing A,B,C and F
upvoted 1 times
...
JESUSBB
2 years, 5 months ago
Answer: A, B,C and F
upvoted 1 times
...
Yoones
3 years, 7 months ago
G is wrong, Real Application Testing is done by Snapshot Standby database.
upvoted 1 times
...
marpayer
3 years, 9 months ago
I believe is ABCF
upvoted 3 times
Sugar
3 years, 3 months ago
your answer is correct. i have verified it on my book
upvoted 1 times
...
...
FelipeK
4 years, 3 months ago
Correct answer A,C,F,G
upvoted 1 times
Sugar
3 years, 3 months ago
you need to do further reading
upvoted 2 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago