Valid 1z0-071 Dumps shared by ExamDiscuss.com for Helping Passing 1z0-071 Exam! ExamDiscuss.com now offer the newest 1z0-071 exam dumps, the ExamDiscuss.com 1z0-071 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1z0-071 dumps with Test Engine here:
Which statement will return the last sequence number generated by the EMP_ SEQ sequence?
Correct Answer: B
* A: NEXTVAL is used to increment the sequence and return the next value; it does not give the last number generated. * B: CURRVAL returns the current value of the sequence, which is the last value generated in the user's current session. However, CURRVAL cannot be queried unless NEXTVAL has been called at least once in that session. * C: CURRVAL is used correctly, but the syntax 'sequence.CURRVAL' is not correct in Oracle SQL. * D: NEXTVAL is used to generate the next sequence number, not to retrieve the last one generated.