Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 170

Which set of commands will prompt only once for the name of the table to use in the query?

PROMPT Enter table name &x -

SELECT employee_id FROM &x WHERE last_name = ‘King’;

DEFINE x = ‘employees’

PROMPT Enter table name &x -

SELECT employee_id FROM &x WHERE last_name = ‘King’;

PROMPT Enter table name &x -

SELECT employee_id FROM &&x WHERE last_name = ‘King’;

PROMPT Enter table name &&x -

SELECT employee_id FROM &x WHERE last_name = ‘King’;

Correct Answer: D

To prompt only once for the name of the table, the correct approach is to use a double ampersand (&&) before the variable name in the SELECT statement line. The correct set of commands uses 'PROMPT Enter table name &&x - SELECT employee_id FROM &x WHERE last_name = ‘King’;', ensuring that '&x' takes the value entered only once and prevents repeated prompts. Other options either do not prompt or prompt multiple times.

Discussion

SantiBZ_07032022_1744Option: D

Tested D.

yaya32Option: D

C prompted twice, while D prompted only once.

ESZOption: C

C is correct

zouveOption: C

C is the right answer tested

yanoolthecoolOption: D

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.

McromeoOption: D

D is correct

jm9999Option: D

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

ESZOption: C

C is correct

WingLOption: C

Correct C

DarnunOption: D

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

zouve

if you re run D it we will always prompt you to enter a value with C only once will prompt you