ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam
Go to Exam

Exam 1z0-071 topic 1 question 177 discussion

Actual exam question from Oracle's 1z0-071
Question #: 177
Topic #: 1
[All 1z0-071 Questions]

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

  • A. PROMPT Enter table name &x -
    SELECT employee_id FROM &x WHERE last_name = ‘King’;
  • B. DEFINE x = ‘employees’

    PROMPT Enter table name &x -
    SELECT employee_id FROM &x WHERE last_name = ‘King’;
  • C. PROMPT Enter table name &x -
    SELECT employee_id FROM &&x WHERE last_name = ‘King’;
  • D. PROMPT Enter table name &&x -
    SELECT employee_id FROM &x WHERE last_name = ‘King’;
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by SantiBZ_07032022_1744 at Feb. 18, 2023, 11:36 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Thameur01
3 days, 8 hours ago
Selected Answer: C
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.
upvoted 1 times
...
yaya32
5 months, 3 weeks ago
Selected Answer: D
C prompted twice, while D prompted only once.
upvoted 3 times
...
yanoolthecool
6 months, 1 week ago
Selected Answer: 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.
upvoted 1 times
...
Mcromeo
7 months, 1 week ago
Selected Answer: D
D is correct
upvoted 1 times
...
jm9999
9 months, 2 weeks ago
Selected Answer: 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
upvoted 1 times
...
ESZ
9 months, 3 weeks ago
Selected Answer: C
C is correct
upvoted 1 times
...
ESZ
1 year ago
Selected Answer: C
C is correct
upvoted 2 times
...
WingL
1 year ago
Selected Answer: C
Correct C
upvoted 1 times
...
zouve
1 year ago
Selected Answer: C
C is the right answer tested
upvoted 2 times
...
Darnun
1 year, 3 months ago
Selected Answer: D
D is correct. B will never show a prompt window.
upvoted 1 times
zouve
1 year ago
if you re run D it we will always prompt you to enter a value with C only once will prompt you
upvoted 3 times
...
...
SantiBZ_07032022_1744
1 year, 4 months ago
Tested D.
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago