MC What will the following query return?

SELECT SUPNAME
FROM SUPPLIER
WHERE SUPNR IN
(SELECT SUPNR
FROM SUPPLIES
WHERE PRODNR = '0668'
AND PURCHASE_PRICE > ALL
(SELECT PURCHASE_PRICE
FROM SUPPLIES
WHERE PRODNR = '0668')) 0 rows correct the names of the suppliers who charge the highest price for the product withproduct number 0668 incorrect the names of the suppliers who charge the lowest price for the product with productnumber 0668 incorrect the names of all suppliers who can supply product 0668 incorrect MC What does the following query return?

SELECT PRODNR, PRODNAME
FROM PRODUCT P
WHERE NOT EXISTS
(SELECT *
FROM SUPPLIER R
WHERE NOT EXISTS
(SELECT *
FROM SUPPLIES S
WHERE R.SUPNR = S.SUPNR
AND P.PRODNR = S.PRODNR)) The product number, product name of the products that that can be supplied by at least 1 supplier. incorrect The product number, product name of the products that that can be supplied by all suppliers. correct The product number, product name of the products that that can be supplied by at most 1 supplier. incorrect The product number, product name of the products that that cannot be supplied by all suppliers. incorrect MC Which of the following queries gives as a result all suppliers excluding the suppliers from Dallas? SELECT SUPNR
FROM SUPPLIER
INTERSECT
SELECT SUPNR
FROM SUPPLIER
WHERE SUPCITY='Dallas' incorrect SELECT SUPNR
FROM SUPPLIER
UNLESS
FROM SUPNR
FROM SUPPLIER
WHERE SUPCITY='Dallas' incorrect SELECT SUPNR
FROM SUPPLIER
EXCEPT
SELECT SUPNR
FROM supplier
WHERE SUPCITY='Dallas' correct SELECT SUPNR
FROM SUPPLIER
UNION
SELECT SUPNR
FROM SUPPLIER
WHERE SUPCITY='Dallas' incorrect MC Which of the following queries gives as a result all suppliers excluding the suppliers from Dallas? SELECT SUPNR
FROM SUPPLIER
UNION
SELECT SUPNR
FROM SUPPLIER
WHERE SUPCITY='Dallas' incorrect SELECT SUPNR
FROM SUPPLIER
INTERSECT
SELECT SUPNR
FROM SUPPLIER
WHERE SUPCITY='Dallas' incorrect SELECT SUPNR
FROM SUPPLIER
EXCEPT
SELECT SUPNR
FROM supplier
WHERE SUPCITY='Dallas' correct SELECT SUPNR
FROM SUPPLIER
UNLESS
FROM SUPNR
FROM SUPPLIER
WHERE SUPCITY='Dallas' incorrect MC Given following query:

SELECT R.SUPNAME, (SELECT COUNT(PO.PODATE)
FROM PURCHASE_ORDER PO
WHERE R.SUPNR = PO.SUPNR) AS SUMMARY
FROM SUPPLIER R

The query selects: The name and total number of outstanding orders of all suppliers correct The supplier name and order date of each of his/her outstanding orders. If a supplier does not have an outstanding order, s/he will be included in the output with a null value for the "SUMMARY" column. incorrect The name and total number of outstanding orders of all suppliers that have at least one outstanding order incorrect The supplier name and order date of each of his/her outstanding orders incorrect MC Given the following SQL query:

SELECT SUPNAME, SUPADDRESS, SUPCITY
FROM SUPPLIER R
WHERE NOT EXISTS
  (SELECT *
  FROM PRODUCT P
  WHERE EXISTS
    (SELECT *
    FROM SUPPLIES S
    WHERE R.SUPNR = S.SUPNR
    AND P.PRODNR = S.PRODNR));

This query selects: The supplier name, supplier address and supplier city of all suppliers who can supply all products. incorrect The supplier name, supplier address and supplier city of all suppliers who cannot supply all products. incorrect The supplier name, supplier address and supplier city of all suppliers who cannot supply any products. correct The supplier name, supplier address and supplier city of all suppliers who can at least supply 1 product. incorrect MC Compare the following 2 queries:

SELECT COUNT(DISTINCT SUPNR)
FROM PURCHASE_ORDER
SELECT COUNT(SUPNR)
FROM PURCHASE_ORDER

Which of the following statements is correct? Result query 1 is sometimes <= and sometimes >= result query 2 because the result depends on the number of suppliers and the number of purchase orders. incorrect Result query 1 is always = result query 2 because PURCHASE_ORDER contains only unique purchase orders. incorrect Result query 1 is always >= result query 2 because query 1 sums the number of purchase orders per supplier while query 2 sums the number of purchase orders in total. incorrect Result query 1 is always <= result query 2 because the DISTINCT operator counts only unique SUPNRs. correct MC Given the following query:

SELECT P.PRODNR, P.PRODNAME
FROM PRODUCT P
WHERE EXISTS
  (SELECT *
  FROM PO_LINE_POL
  WHERE P.PRODNR = POL.PRODNR
  GROUP BY POL.PRODNR
  HAVING SUM(POL.QUANTITY) > P.AVAILABLE_QUANTITY)

The query retrieves: The name and number of all products that are ordered and do not exceed their available quantity. incorrect The name and number of the product with the highest ordered quantity. incorrect The name and number of all products that are ordered and exceed their available quantity. correct The name and number of the product with the lowest ordered quantity. incorrect MC Given the following query:

SELECT P.PRODNR, P.PRODNAME
FROM PRODUCT P
WHERE EXISTS
  (SELECT *
  FROM PO_LINE_POL
  WHERE P.PRODNR = POL.PRODNR
  GROUP BY POL.PRODNR
  HAVING SUM(POL.QUANTITY) > P.AVAILABLE_QUANTITY)

The query retrieves: The name and number of all products that are ordered and do not exceed their available quantity. incorrect The name and number of the product with the lowest ordered quantity. incorrect The name and number of all products that are ordered and exceed their available quantity. correct The name and number of the product with the highest ordered quantity. incorrect MC Given the following view definition and update statement:

CREATE VIEW TOPPRODUCTS(PRODNR,PRODNAME,QUANTITY) AS
SELECT PRODNR, PRODNAME, AVAILABLE_QUANTITY
FROM PRODUCT WHERE AVAILABLE_QUANTITY>100
WITH CHECK OPTION
UPDATE TOPPRODUCTS
SET QUANTITY=80
WHERE PRODNR=0153

What will be the result of this? The update can be successfully made and both the View and PRODUCT table will be updated. incorrect The update can be successfully made but only the PRODUCT table will be updated. incorrect The update can be successfully made but only the View will be updated. incorrect The update will be halted because of the WITH CHECK OPTION. correct