Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition?

The correct answer is C. SELECT &1, &2. In a WHERE clause, date and characters values must be enclosed within single quotation marks. Sample of the correct syntax SELECT EMPLOYEE_ID, &COLUMN_NAME

Basic SQL SELECT Statements

Question

Options

ASELECT &1, "&2"
BSELECT &1, '&2'
CSELECT &1, &2
DSELECT &1, '&2'

How the community answered

(30 responses)

A
7% (2)
B
3% (1)
C
73% (22)
D
17% (5)

Explanation

In a WHERE clause, date and characters values must be enclosed within single quotation marks. Sample of the correct syntax SELECT EMPLOYEE_ID, &COLUMN_NAME

Topics

#substitution variables#SQL*Plus#ampersand#dynamic input

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice