exam questions

Exam 1z0-066 All Questions

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

Exam 1z0-066 topic 1 question 8 discussion

Actual exam question from Oracle's 1z0-066
Question #: 8
Topic #: 1
[All 1z0-066 Questions]

Your Data Guard environment has one physical standby database using Real-Time Query.
Two sentences have been created by these SQL statements:
create sequence a global;
create sequence b session;
Neither sequence has been used since being created.
Session 1 connects to the primary database instance and issues these two SQL statements:
SELECT a.nextval FROM DUAL;
SELECT b.nextval FROM DUAL;
Then session 2 connects to the physical standby database instance and issues the same SQL statements.
What output will be seen for session 2?

  • A. Option A
  • B. Option B
  • C. Option C
  • D. Option D
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
ScottL
1 year, 3 months ago
Selected Answer: A
A - read Kamaelk answer
upvoted 1 times
...
JESUSBB
2 years, 5 months ago
Answer: A
upvoted 1 times
...
SaguSe7en
5 years, 2 months ago
How is A the correct answer. The sequence was created without cache parameter hence it will start from 1 so if session 2 connects, it will give 1 as the output
upvoted 1 times
Kamaelk
5 years ago
Session 1 SQL> create sequence a global; Sequence created. SQL> create sequence b session; Sequence created. SQL> SELECT a.nextval FROM DUAL; NEXTVAL ---------- 1 SQL> SELECT b.nextval FROM DUAL; NEXTVAL ---------- 1 SQL> exit Session 2 SQL> select database_role, open_mode from v$database; DATABASE_ROLE OPEN_MODE ---------------- -------------------- PHYSICAL STANDBY READ ONLY WITH APPLY SQL> SELECT a.nextval FROM DUAL; NEXTVAL ---------- 21 SQL> SELECT b.nextval FROM DUAL; NEXTVAL ---------- 1
upvoted 1 times
...
Kamaelk
5 years ago
If you omit both CACHE and NOCACHE, then the database caches 20 sequence numbers by default. https://docs.oracle.com/database/121/SQLRF/statements_6017.htm#SQLRF01314 But i will test it to day.
upvoted 2 times
...
...
Kamaelk
5 years, 3 months ago
Right answer is A. Refer to https://docs.oracle.com/database/121/SBYDB/manage_ps.htm#SBYDB5164
upvoted 1 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago