QUESTION 5 What does the following query return? SELECT P1 PRODNA FROM PRODUCT P1 WHERE 7 (SELECT COUNT() FROM PRODUCT P2 WHERE P1.PRODNR > P2.PRODNF) All product numbers except for the highest product numbers. All product numbers except for the 7 lowest product numbers. All product numbers except for the lowest product numbers. All product numbers except for the 7 highest product numbers. QUESTION 6 Given the following query: SELECT PPRODNR, P.PRODNAME, PAVAILABLE QUANTITY, SUMIL. QUANTITY) AS ORDERED QUANTITY FROM PRODUCT AS P LEFT OUTER JOIN PO_LINE ASL ON (PPHOONROL.PRODNRI GROUP BY P.PROONR Which of the following statements is incorrect? The query retrieves the product number, product name and available quantity of each product thanks to the left outer join. The query retrieves for each product the total ordered quantity The query result can never contain NULL values. If we remove the GROUP BY statement and P.PRODNR, P.PRODNAME, PAVAILABLE QUANTITY from the SELECT statement, the query will result in 1 row containing the total outstanding ordered quantity over all products in column 'ORDERED QUANTITY. QUESTION 7 Which of the following queries gives as a result all suppliers excluding the suppliers from Dallas? SELECT SUPNA FROM SUPPLIER UNION SELECT SUPNA FROM SUPPLIER WHERE SUPCITY'Dallas SELECT SUPNA FROM SUPPLIER INTERSECT SELECT SUPNA FROM SUPPLIER WHERE SUPCITY='Dallas SELECT SUPNA FROM SUPPLIER EXCEPT FROM supplier WHERE SUPCITY='Dallas SELECT SUPNR FROM SUPPLIER UNLESS FROM SUPNR FROM SUPPLIER WHERE SUPCITY='Dalles QUESTION 5 What does the following query return? SELECT P1 PRODNA FROM PRODUCT P1 WHERE 7 (SELECT COUNT() FROM PRODUCT P2 WHERE P1.PRODNR > P2.PRODNF) All product numbers except for the highest product numbers. All product numbers except for the 7 lowest product numbers. All product numbers except for the lowest product numbers. All product numbers except for the 7 highest product numbers. QUESTION 6 Given the following query: SELECT PPRODNR, P.PRODNAME, PAVAILABLE QUANTITY, SUMIL. QUANTITY) AS ORDERED QUANTITY FROM PRODUCT AS P LEFT OUTER JOIN PO_LINE ASL ON (PPHOONROL.PRODNRI GROUP BY P.PROONR Which of the following statements is incorrect? The query retrieves the product number, product name and available quantity of each product thanks to the left outer join. The query retrieves for each product the total ordered quantity The query result can never contain NULL values. If we remove the GROUP BY statement and P.PRODNR, P.PRODNAME, PAVAILABLE QUANTITY from the SELECT statement, the query will result in 1 row containing the total outstanding ordered quantity over all products in column 'ORDERED QUANTITY. QUESTION 7 Which of the following queries gives as a result all suppliers excluding the suppliers from Dallas? SELECT SUPNA FROM SUPPLIER UNION SELECT SUPNA FROM SUPPLIER WHERE SUPCITY'Dallas SELECT SUPNA FROM SUPPLIER INTERSECT SELECT SUPNA FROM SUPPLIER WHERE SUPCITY='Dallas SELECT SUPNA FROM SUPPLIER EXCEPT FROM supplier WHERE SUPCITY='Dallas SELECT SUPNR FROM SUPPLIER UNLESS FROM SUPNR FROM SUPPLIER WHERE SUPCITY='Dalles