1z1-061 Free Dumps Study Materials
Question 12: Which SQL statement accepts user input for the columns to be displayed, the table name,
and WHERE condition?
A. SELECT &1, "&2"FROM &3WHERE last_name = '&4';
B. SELECT &1, '&2'FROM &3WHERE '&last_name = '&4' ';
C. SELECT &1, &2FROM &3WHERE last_name = '&4';
D. SELECT &1, '&2'FROM EMPWHERE last_name = '&4';
Correct Answer: C
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
FROM EMPLOYEES
Incorrect Answers :
A: Incorrect use of " symbol
B: Incorrect use of ' symbol
D: No input for table name as EMP has been use in the statement.
Refer: Introduction to Oracle9i: SQL, Oracle University Student Guide, Producing Readable Output
with iSQL*PLUS, p. 7-8