View the Exhibits and examine the structures of the CUSTOMERS, SALES, and COUNTRIES tables.
You need to generate a report that shows all country names, with corresponding customers (if any) and sales details (if any), for all customers.
Which FROM clause gives the required result?

• A. FROM customers LEFT OUTER JOIN sales USING (cust_id) RIGHT OUTER JOIN countries USING (country_id);
• B. FROM sales JOIN customers USING (cust_id) RIGHT OUTER JOIN countries USING (country_id);
• C. FROM customers LEFT OUTER JOIN sales USING (cust_id) LEFT OUTER JOIN countries USING (country_id);
• D. FROM sales JOIN customers USING (cust_id) FULL OUTER JOIN countries USING (country_id);

View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. There is only one customer with the cus_last_name column having value Roberts. Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600?

• A. INSERT INTO orders VALUES (l.'10-mar-2007\ 'direct'. (SELECT customerid FROM customers WHERE cust_last_iiame='Roberts' AND credit_limit=600). 1000);
• B. INSERT INTO orders (order_id.order_date.order_mode.
  (SELECT customer_id
  FROM customers
  WHERE cust_last_iiame='Roberts' AND
  credit_limit=600).order_total)
  VALUES(l.'10-mar-2007\ 'direct'. &customer_id. 1000):
• C. INSERT INTO(SELECT o.order_id. o.order_date.o.order_modex.customer_id.
  o.ordertotal
  FROM orders o. customers c
  WHERE o.customer_id = c.customerid
  AND c.cust_la$t_name-RoberTs' ANDc.credit_liinit=600)
  VALUES (L'10-mar-2007\ 'direct'.( SELECT customer_id
  FROM customers
  WHERE cust_last_iiame='Roberts' AND
  credit_limit=600). 1000);
• D. INSERT INTO orders (order_id.order_date.order_mode. (SELECT customer id FROM customers WHERE cust_last_iiame='Roberts' AND redit_limit=600).order_total)
  VALUES(L'10-mar-2007'. 'direct', &&customer_id, 1000):

The user Sue issues this SQL statement:
GRANT SELECT ON sue.EMP TO alice WITH GRANT OPTION;
The user Alice issues this SQL statement:
GRANT SELECT ON sue.EMP TO reena WITH GRANT OPTION;
The user Reena issues this SQL statement:
GRANT SELECT ON sue.EMP TO timber;
The user Sue issues this SQL statement:
REVOKE select on sue.EMP FROM alice;
For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?

• A. Alice and Reena
• B. Alice only
• C. Sue, Alice, Reena, and Timber
• D. Alice, Reena, and Timber

You issue the following query:
SQL> SELECT AVG(MAX(qty))
FROM ord_items
GROUP BY item_no
HAVING AVG(MAX(qty))>50;
Which statement is true regarding the outcome of this query?

• A. It gives an error because the HAVING clause is not valid.
• B. It executes successfully but does not give the correct output.
• C. It gives an error because the GROUP BY expression is not valid.
• D. It executes successfully and gives the correct output.

Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"?

• A. SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;
• B. SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY), 'fmDdspth "of" Month YYYYfmtHH:HI:SS AM') NEW_DATE FROM dual;
• C. SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;
• D. SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY HH:MI:SS AM') NEW_DATE FROM dual;