Zend
ZF-100-500 · Question #153
ZF-100-500 Question #153: Real Exam Question with Answer & Explanation
Sign in or unlock ZF-100-500 to reveal the answer and full explanation for question #153. The question stem and answer options stay visible for context.
Question
Martin works as a Database Administrator for MTech Inc. He designs a database that has a table named Products. He wants to create a report listing different product categories. He does not want to display any duplicate row in the report. Which o f the following SELECT statements will Martin use to create the report?
Options
- ASELECT Product_No, Prod_Category
- BSELECT DISTINCT Product_No, Prod_Category
- CSELECT Product_No, Prod_Category
- DSELECT Product_No, Prod_Category
Unlock ZF-100-500 to see the answer
You've previewed enough free ZF-100-500 questions. Unlock ZF-100-500 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.