1Z0-007 · Question #76
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…
The correct answer is C. A report is produced that matches the first report produced. use the double-ampersand if you want to reuse the variable value without prompting the user Incorrect answer: A is not an error B && will not prompt user for second time D && will not ask the user for new value
Question
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?
Options
- AAn error is returned.
- BYou are prompted to enter a new value.
- CA report is produced that matches the first report produced.
- DYou are asked whether you want a new value or if you want to run the report based on the previous value.
How the community answered
(26 responses)- A4% (1)
- B8% (2)
- C85% (22)
- D4% (1)
Explanation
use the double-ampersand if you want to reuse the variable value without prompting the user Incorrect answer: A is not an error B && will not prompt user for second time D && will not ask the user for new value
Topics
Community Discussion
No community discussion yet for this question.