Oracle
1Z0-047 · Question #234
1Z0-047 Question #234: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #234. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the data in the PRODUCT_INFORMATION table. There are some products listed in the PRODUCT_INFORMATION table that have no value in the LIST_PRICE column. You issued the following SQL statement to find out the PRODUCT_NAME for these products: SELECT product_name, list_price FROM product_information WHERE list_price = NULL; The query returns no rows. What changes would you make in the statement to get the desired result?
Exhibit
Options
- AChange the WHERE clause to WHERE list_price = 0
- BChange the WHERE clause to WHERE list_price = ''.
- CChange the WHERE clause to WHERE list_price IS NULL.
- DIn the WHERE clause, enclose NULL within single quotation marks.
- EIn the WHERE clause, enclose NULL within double quotation marks.
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.