Exam 1z0-071 topic 1 question 177 discussion

PROMPT Enter table name &&x - The && (double ampersand) ensures that the value for the variable x is stored in the session after it is entered. The PROMPT statement is used to display a message for the user to input the value. SELECT employee_id FROM &x WHERE last_name = 'King'; The &x (single ampersand) refers to the variable x that was already defined by the && mechanism in the previous step. It does not prompt again because the variable is already stored.

C. PROMPT Enter table name &x - SELECT employee_id FROM &&x WHERE last_name = ‘King’; An & prefix to an undefined substitution variable, which is referenced twice in the same query, will prompt for a value twice.

C prompted twice, while D prompted only once.

D, && performs an implicit DEFINE while & doesn't I thought & always prompts, even if there was && before it, but this question just made me realize this, as all other answers are wrong, including C.

D is correct

Test results: A and C: prompted twice B: did not prompt D: prompted once the first time and then no prompt on rerun Best answer: D

C is correct

C is correct

Correct C

C is the right answer tested

D is correct. B will never show a prompt window.

Tested D.