Free Preparation Discussions
MENU
Oracle Exam 1Z0-076 Topic 1 Question 6 Discussion
Topic #: 1
Which THREE statements are TRUE about the supported workload in Active Data Guard standby databases?
In an Oracle Active Data Guard environment:
B: Read-mostly reporting applications that utilize global temporary tables to store session-specific data can be effectively offloaded to an Active Data Guard standby database, reducing the load on the primary database.
C: Sequences can be used with global temporary tables on an Active Data Guard standby database to support certain types of read-mostly applications, though some restrictions on sequence use may apply.
E: In Oracle Database 19c and later, DML redirection allows DML operations performed on an Active Data Guard standby database to be transparently redirected to the primary database. This is part of the DML Redirection feature.
Option A is incorrect because not all PL/SQL blocks run on an Active Data Guard standby database can be redirected to the primary database. Some PL/SQL executions, specifically those that would attempt to make changes to the database, are not supported on the standby.
Option D is incorrect because DDL operations on private temporary tables are not redirected; instead, private temporary tables are session-specific and are not persisted on disk, so they do not generate redo and are not applicable to an Active Data Guard standby.
Mel
10 months agoTyra
10 months agoKathryn
10 months agoMel
10 months agoTyra
10 months agoKathryn
11 months agoDiane
11 months agoHenriette
11 months agoTamar
11 months agoDannie
11 months agoDiane
11 months agoTamar
1 years agoRhea
1 years agoGrover
1 years agoShanda
11 months agoSarah
12 months agoAdelle
12 months agoHermila
1 years agoLeatha
1 years agoLamar
1 years agoDominque
1 years ago