Examine this statement:
SELECT student_id, gpa FROM student_grades WHERE gpa > &&value;
You run the statement once, and when prompted you enter a value of 2.0. A report is produced.
What happens when you run the statement a second time?
A. An error is returned.
B. You are prompted to enter a new value.
C. A report is produced that matches the first report produced.
D. You are asked whether you want a new value or if you want to run the report based on the previous value.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
you have to “exit” in order to change the variables
when two && is used, the value is mantained in memory for next execution until you issue “undefine” or exit from session.