View the Exhibit and examine the details of the ORDER_ITEMS table.

Evaluate the following SQL statements:
Statement 1:
SELECT MAX(unit_price*quantity) "Maximum Order"
FROM order_items;
Statement 2:
SELECT MAX(unit_price*quantity) "Maximum Order"
FROM order_items
GROUP BY order_id;
Which statements are true regarding the output of these SQL statements? (Choose all that apply.)

• A.Statement 1 would return only one row of output.
• B.Both statements would ignore NULL values for the UNIT_PRICE and QUANTITY columns.
• C.Statement 1 would not return give the same output.
• D.Both the statements would give the same output.
• E.Statement 2 would return multiple rows of output.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the ORDER_ITEMS table.

You must select the ORDER_ID of the order that has the highest total value among all the orders in the ORDER_ITEMS table.
Which query would produce the desired result?

• A.SELECT order_id
  FROM order_items
  WHERE(unit_price*quantity) = MAX(unit_price*quantity)
  GROUP BY order_id;
• B.SELECT order_id
  FROM order_items
  WHERE (unit_price*quantity) = (SELECT MAX(unit_price*quantity)
  FROM order_items
  GROUP BY order_id)
• C.SELECT order_id
  FROM order_items
  GROUP BY order_id
  HAVING SUM(unit_price*quantity) = (SELECT MAX(SUM(unit_price*quantity)) FROM order_items GROUP BY order_id);
• D.SELECT order_id
  FROM order_items
  WHERE(unit_price*quantity) = (SELECT MAX(unit_price*quantity)
  FROM order_items)
  GROUP BY order_id;

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 WHEN clauses regardless of the results of the evaluation of any other WHEN clause.
• B.They are evaluated by the first WHEN clause. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses.
• C.They are evaluated by the first WHEN clause. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses.
• D.The insert statement would give an error because the ELSE clause is not present for support in case none of WHEN clauses are true.

Comment: *

Name: *

Email: *

Verification: *

Examine this description of the PRODUCTStable:

Rows exist in this table with data in all the columns. You put the PRODUCTStable in read-only mode.
Which three commands execute successfully on PRODUCTS?

• A.ALTER TABLE products DROP COLUMN expiry_date;
• B.ALTER TABLE products SET UNUSED (expiry_date);
• C.TRUNCATE TABLE products;
• D.CREATE INDEX price_idx ON products (price);
• E.DROP TABLE products;
• F.ALTER TABLE products DROP UNUSED COLUMNS;

Comment: *

Name: *

Email: *

Verification: *

Which three statements are correct regarding indexes? (Choose three.)

• A.A non-deferrable PRIMARY KEYor UNIQUE KEYconstraint in a table automatically attempts to create a unique index.
• B.Indexes should be created on columns that are frequently referenced as part of any expression.
• C.When a table is dropped, the corresponding indexes are automatically dropped.
• D.For each DML operation performed, the corresponding indexes are automatically updated.

Comment: *

Name: *

Email: *

Verification: *