A user selects from a sequence and gets back two

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

A user selects from a sequence and gets back two values, his select is:

SELECT pk_seq.nextval FROM dual;
What is the problem?
Level: Intermediate
Expected answer: Somehow two values have been inserted into the dual table. This table is a single row, single column table that should only have one value in it.

(Continued on next question...)

Other Job Interview Questions

• Where in the Oracle directory tree structure are audit traces placed?
• Can you pass data parameters to forms?
• What is a timer?
• What are the two panes that Appear in the design time pl/SQL interpreter?
• How do you reference a parameter indirectly?
• What is pop list?
• What are PL/SQL Cursor Exceptions?
• How can you enable a trace for a session?
• What are parameters?
• What are the types of calculated columns available?
• More...