Zend Framework Certification 100-500 Question # 53 Topic 6 Discussion

Zend Framework Certification 100-500 Question # 53 Topic 6 Discussion

100-500 Exam Topic 6 Question 53 Discussion:
Question #: 53
Topic #: 6

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 of the following SELECT statements will Martin use to create the report?


A.

SELECT Product_No, Prod_Category

FROM Products;


B.

SELECT DISTINCT Product_No, Prod_Category

FROM Products;


C.

SELECT Product_No, Prod_Category

FROM Products

GROUP BY Product_No;


D.

SELECT Product_No, Prod_Category

FROM Products

GROUP BY Product_No ORDER BY Product_No;


Get Premium 100-500 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.