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.
Explanation:
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
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
Correct Ans: A, B, C, F
Wrong Answers:
D – Physical standby will have the same physical structure as primary not logical standby.
E – Though Logical standby can be involved in switchover operations you cannot protect ALL data as there can be some additional objects those are in Logical standby so Physical Standby are the recommended solution in the case of both switchover and failover capabilities.
G – Snapshot Standby database can be used for Real Application Testing as they have the same structure as Primary and can be later converted into Physical Standby after testing.
https://docs.oracle.com/database/121/SBYDB/standby.htm#SBYDB00103
The flexibility of a logical standby database lets you upgrade Oracle Database software (patch sets and new Oracle Database releases) and perform other database maintenance in rolling fashion with almost no downtime.
A key benefit of logical standby is that significant auxiliary structures can be created to optimize the reporting workload; structures that could have a prohibitive impact on the primary’s transactional response time. A logical standby can have its data physically reorganized into a different storage type with different partitioning, have many different indexes, have on-demand refresh materialized views created and maintained, and can be used to drive the creation of data cubes and other OLAP data views.
Benefits of Implementing a Logical Standby Database:
* Provides an efficient use of system resources
* Open, independent, and active production database
* Additional indexes and materialized views can be created for improved query performance
* Reduces workload on the primary database by offloading the following workloads to a logical standby database: – Reporting– Summations – Queries
A,B,C,F