database:

1.

2.

3.

4.

5.

Which query will output all products with their expiration date (one year from the purchase date)? Select one: a. SELECT P_CODE, P_INDATE, ADD_MONTHS(P_INDATE,12) AS EXPDATE FROM PRODUCT ORDER BY P_CODE; Ob. SELECT P_CODE, P_INDATE, ADD_YEARS(P_INDATE,1) AS EXPDATE FROM PRODUCT ORDER BY P_CODE; C. SELECT P_CODE, P_INDATE, TO_DATE(P_INDATE+12,'dd/mm/yyyy') AS EXPDATE FROM PRODUCT ORDER BY P CODE; O d. SELECT P_CODE, P_INDATE, TO_CHAR(P_INDATE+12,'dd/mm/yyyy') AS EXPDATE FROM PRODUCT ORDER BY P_CODE; Which query will output average price of the products provided by each vendor (rounded in 2 decimal place)? Select one: O a. SELECT V_CODE, TO_CHAR(AVG(P_PRICE),'.99') AS AVGPRICE FROM PRODUCT GROUP BY V_CODE; Ob. SELECT V_CODE, ROUND(AVG(P_PRICE),2) AS AVGPRICE FROM PRODUCT GROUP BY V_CODE C. SELECT V_CODE, AVG(P_PRICE,2) AS AVGPRICE FROM PRODUCT GROUP BY V_CODE; d. SELECT V_CODE, ROUND(P_PRICE,2) AS AVGPRICE FROM PRODUCT GROUP BY V_CODE; Which query will output list of employee whose age is above 55 years old? Select one: a. SELECT EMP_LNAME, EMP_FNAME, EMP_DOB, YEARS_BETWEEN(SYSDATE,EMP_DOB) AS AGE FROM EMPLOYEE WHERE YEARS_BETWEEN(SYSDATE,EMP_DOB) > 55 ORDER BY AGE; O b. SELECT EMP_LNAME, EMP_FNAME, EMP_DOB, YEARS_BETWEEN(SYSDATE,EMP_DOB) AS AGE FROM EMPLOYEE WHERE AGE > 55 ORDER BY AGE; C. SELECT EMP_LNAME, EMP_FNAME, EMP_DOB, FLOOR(MONTHS_BETWEEN(SYSDATE,EMP_DOB)/12) AS AGE FROM EMPLOYEE WHERE AGE > 55 ORDER BY AGE; O d. SELECT EMP_LNAME, EMP_FNAME, EMP_DOB, FLOOR(MONTHS_BETWEEN(SYSDATE,EMP_DOB)/12) AS AGE FROM EMPLOYEE WHERE FLOOR(months_between(SYSDATE,EMP_DOB)/12) > 55 ORDER BY AGE; Which query will output the product code, vendor code, and vendor name for all products and include all product rows (products without matching vendors) as well as all vendor rows (vendors without matching products)? Select one: a. SELECT P_CODE, V_CODE, V_NAME FROM PRODUCT PR FULL JOIN VENDOR V ON PR.V_CODE = V.V_CODE; O b. SELECT P_CODE, V_CODE, V_NAME FROM VENDOR FULL JOIN PRODUCT ON V_CODE = V_CODE; C. SELECT P_CODE, V.V_CODE, V_NAME FROM VENDOR V FULL JOIN PRODUCT PR ON V.V_CODE = PR.V_CODE; d. SELECT P_CODE, V.V_CODE, V_NAME FROM PRODUCT PR JOIN VENDOR V ON PR.V_CODE = V.V_CODE; Which query will output product code, vendor code, and vendor name for all products and include those vendors with no matching products? Select one: a. SELECT V_CODE, V_NAME, P_CODE FROM PRODUCT LEFT JOIN VENDOR ON VENDOR.V_CODE = PRODUCT.V_CODE; Ob. SELECT VENDOR.V_CODE, V_NAME, P_CODE FROM VENDOR RIGHT JOIN PRODUCT ON VENDOR.V_CODE = PRODUCT.V_CODE; C. SELECT VENDOR.V_CODE, V_NAME, P_CODE FROM PRODUCT RIGHT JOIN VENDOR ON VENDOR.V_CODE = PRODUCT.V_CODE; d. SELECT VENDOR.V_CODE, V_NAME, P_CODE FROM PRODUCT LEFT JOIN VENDOR ON VENDOR.V_CODE = PRODUCT.V_CODE