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 query will output the table contents when the value of the string field P_DESCRIPT include the word ‘hammer’?Select one:a.SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE     FROM PRODUCT            WHERE P_DESCRIPT = ‘hammer’;b.SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE     FROM PRODUCT            WHERE P_DESCRIPT = ‘%hammer%’;c.SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE     FROM PRODUCT            WHERE P_DESCRIPT include ‘hammer’;d.SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE     FROM PRODUCT            WHERE P_DESCRIPT like ‘%hammer%’;

Which query will output the rows where the value of P_PRICE is between 50 and 100 (inclusive)?Select one:a.SELECT *        FROM PRODUCT              WHERE P_PRICE >= 50 AND P_PRICE <=100;b.SELECT *        FROM PRODUCT              WHERE P_PRICE >= 50 OR P_PRICE <=100;c.SELECT *        FROM PRODUCT              WHERE P_PRICE <= 50 AND P_PRICE >=100;d.SELECT *        FROM PRODUCT              WHERE P_PRICE <= 50 AND P_PRICE <=100;

Which SQL statement will list the names and phone numbers of vendors who supply any product with price above $100?Select one:a.​SELECT V_NAME, V_PHONE      FROM PRODUCT P JOIN VENDOR V ON P.V_CODE = V.V_CODE              WHERE NOT (P.P_PRICE > 100);​b.​SELECT V_NAME, V_PHONE      FROM PRODUCT P JOIN VENDOR V ON P.V_CODE = V.V_CODE        OR P.P_PRICE > 100;​c.SELECT V_NAME, V_PHONE      FROM PRODUCT P JOIN VENDOR V ON P.V_CODE = V.V_CODE               WHERE P.P_PRICE > 100;d.​SELECT V_NAME, V_PHONE      FROM PRODUCT P JOIN VENDOR V ON P.V_CODE = V.V_CODE              WHERE P.P_PRICE <= 100;

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 to display the products that have the price between RM50 and RM100a.SELECT * FROM Products WHERE Price &lt;50 AND 100&gt;b.SELECT * FROM Products WHERE Price LIKE 50 AND 100c.SELECT * FROM Products WHERE Price BETWEEN 50 OR 100d.SELECT * FROM Products WHERE Price BETWEEN 50 AND 100