Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION?

• A.Each SELECT statement in the compound query must have its own ORDER BY clause.
• B.Only column names from the first SELECT statement in the compound query are recognized.
• C.Column positions must be used in the ORDER BY clause.
• D.Each SELECT statement in the compound query can have its own ORDER BY clause.
• E.The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the ORDERS table.

The ORDERS table contains data and all orders have been assigned a customer ID. Which statement would add a NOT NULL constraint to the CUSTOMER_ID column?

• A.ALTER TABLE ordersMODIFY customer_id CONSTRAINT orders_cust_nn NOT NULL (customer_id);
• B.ALTER TABLE ordersADD CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);
• C.ALTER TABLE ordersADD customer_id NUMBER(6)CONSTRAINT orders_cust_id_nn NOT NULL;
• D.ALTER TABLE ordersMODIFY CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);

Comment: *

Name: *

Email: *

Verification: *

The sales table has columns prod_id and quantity_sold of data type number. Which two queries execute successfully?

• A.SELECT prod Id FROH sales NHERE quantity sold > 55000 3RODI BY prod_id HAVING COUNT(*) > 10;
• B.SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY prod_id HAVING COUNT(*) > 10;
• C.SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold > 55000;
• D.SELECT COUNT(prod_id) FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;
• E.SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND
  COUNT(*) > 10 GROUP BY COUNT(*) > 10;

Comment: *

Name: *

Email: *

Verification: *

Examine this partial query:
SELECT ch.channel_type, t.month, co.country_code, SUM(s.amount_sold) SALES
FROM sales s, times t, channels ch, countries co
WHERE s.time_ id = t.time id
AND s.country_ id = co. country id
AND s. channel id = ch.channel id
AND ch.channel type IN ('Direct Sales', 'Internet')
AND t.month IN ('2000-09', '2000-10')
AND co.country code IN ('GB', 'US')
Examine this output:

Which GROUP BY clause must be added so the query returns the results shown?

• A.GROUP BY ch.channel_type, t.month, co.country code;
• B.GROUP BY CUBE (ch. channel_ type, t .month, co. country code);
• C.GROUP BY ch.channel_type,ROLLUP (t month, co. country_ code) ;
• D.GROUP BYch. channel_ type, t.month,ROLIUP (co. country_ code) ;

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following statement.
INSERT ALL
WHEN order_total < 10000 THEN
INTO small_orders
WHEN order_total > 10000 AND order_total < 20000 THEN
INTO medium_orders
WHEN order_total > 200000 AND order_total < 20000 THEN
INTO large_orders
SELECT order_id, order_total, customer_id
FROM orders;
Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?

• A.They are evaluated by all the three WHENclauses regardless of the results of the evaluation of any other WHENclause.
• B.They are evaluated by the first WHENclause. If the condition is true, then the row would be evaluated by the subsequent WHENclauses.
• C.They are evaluated by the first WHENclause. If the condition is false, then the row would be evaluated by the subsequent WHENclauses.
• D.The insert statement would give an error because the ELSEclause is not present for support in case none of WHENclauses are true.

Comment: *

Name: *

Email: *

Verification: *