Free Preparation Discussions
MENU
Oracle Exam 1Z0-076 Topic 11 Question 21 Discussion
Topic #: 11
Which two are true about database roles in an Oracle Data Guard configuration?
In Oracle, a sequence created with the GLOBAL keyword is available and can produce values across all sessions and instances. However, a sequence created with the SESSION keyword is only specific to the session it was created in. When the NEXTVAL is called for a sequence, it will increment according to the sequence's properties set during its creation.
Given the sequence creation statements and the actions performed:
The a sequence is global, which means it is available across the entire database, including the standby database with Real-Time Query enabled. So, when session 2 calls a.nextval, it will get the next value in the sequence, which is 21 since session 1 already retrieved 1.
The b sequence is session-specific, so when session 2 calls b.nextval, it will get the value 1 because for this new session on the standby, this is the first time the sequence is being accessed.
Therefore, the output for session 2 will be a output as 21 and b output as 1, which corresponds to Option C.
Paris
1 months agoSilva
1 months agoQuiana
1 months agoCraig
1 months agoOzell
13 days agoPa
18 days agoHenriette
21 days agoJosphine
22 days agoJovita
1 months agoBarrie
3 days agoStephania
8 days agoKaycee
2 months agoPaola
8 days agoCaitlin
14 days agoMarkus
16 days agoJulian
22 days agoCeola
23 days agoEllen
1 months agoLewis
2 months agoRodolfo
2 months agoEstrella
2 months ago