1Z0-536 · Question #66
Can you use Active Data Guard effectively between an Oracle Exadata Database Machine and a standard database server?
The correct answer is B. Yes, but tables or paritions that use Hybrid Columnar Compression will not be immediately accessible. The HCC (Hybrid Columnar Compression) compressed columns get actualized on the Standby by Redo Apply - they cannot be accessed by select statements, though. This will compromise the Availability of these tables in case of a failover accordingly - you probably should not go with…
Question
Can you use Active Data Guard effectively between an Oracle Exadata Database Machine and a standard database server?
Options
- AYes, but only If you use Hybrid Columnar Compression.
- BYes, but tables or paritions that use Hybrid Columnar Compression will not be immediately accessible.
- CYes, but only if you do not allow Smart Scans with the Oracle Exadata Database Machine.
- DNo.
How the community answered
(35 responses)- A3% (1)
- B83% (29)
- C3% (1)
- D11% (4)
Explanation
The HCC (Hybrid Columnar Compression) compressed columns get actualized on the Standby by Redo Apply - they cannot be accessed by select statements, though. This will compromise the Availability of these tables in case of a failover accordingly - you probably should not go with that https://uhesse.wordpress.com/2011/01/21/exadata-part-iii-compression/
Topics
Community Discussion
No community discussion yet for this question.