Oracle
1Z0-061 · Question #165
1Z0-061 Question #165: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #165. The question stem and answer options stay visible for context.
Question
See the Exhibit and examine the structure of ORD table: Evaluate the following SQL statements that are executed in a user session in the specified order: CREATE SEQUENCE ord_seq; SELECT ord_seq.nextval FROM dual; INSERT INTO ord VALUES (ord_seq.CURRVAL, '25-jan-2007, 101); UPDATE ord SET ord_no= ord_seq.NEXTVAL WHERE cust_id =101; What would be the outcome of the above statements?
Exhibit
Options
- AAll the statements would execute successfully and the ORD_NO column would contain the value 2
- BThe CREATE SEQUENCE command would not execute because the minimum value and
- CThe CREATE SEQUENCE command would not execute because the starting value of the
- DAll the statements would execute successfully and the ORD_NO column would have the value 20
Unlock 1Z0-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.