Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?Select one:a.SELECT DISTINCT V_CODEFROM PRODUCT;b.SELECT UNIQUE V_CODEFROM PRODUCT;c.SELECT DIFFERENT V_CODEFROM PRODUCT;d.SELECT ONLY V_CODEFROM PRODUCT;

Which SQL statement is used to return only different values?Select one:a.SELECT DISTINCTb.None of the answers are correctc.SELECT DIFFERENTd.SELECT IDENTICALe.SELECT UNIQUE

How could we choose only unique values in a query?a.SELECT DISTINCTb.SELECT SPECIALc.SELECT UNIQUEd.SELECT NO DUPLICATE

Question 1You have a table that lists products. Because there are different editions, there are duplicate product names in the productName field. You need to create a list of all of the different product names. If there are different editions of the product, you only want to list one record for each product name. What query should you execute? 1 pointSELECT DISTINCT productName FROM productsSELECT UNIQUE productName FROM productsSELECT INDIVIDUAL productName FROM productsSELECT SEPARATE productName FROM products

Which query will output the table contents when the value of V_CODE is NOT equal to 21344?Select one:a.SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE        FROM PRODUCT              WHERE V_CODE <= 21344;b.SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE        FROM PRODUCT              WHERE V_CODE => 21344;c.SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE        FROM PRODUCT              WHERE V_CODE <> 21344;d.SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE        FROM PRODUCT              WHERE V_CODE = 21344;

Which of the following statements are TRUE about DISTINCT keyword? [Choose any TWO]DISTINCT keyword can be used in SELECT and WHERE clausesDISTINCT removes duplicates based on column immediately following DISTINCTDISTINCT removes duplicates based on all the columns in the SELECT clauseUsage of DISTINCT should be avoided as far as possible due to performance issues