Which three statements are true about multiple row subqueries?

• A.They can contain GROUP BY clauses.
• B.They can return multiple columns.
• C.Two or more values are always returned from the subquery.
• D.They can contain HAVINGclauses.
• E.They cannot contain a subquery.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of ORDER_ITEMSand ORDERStables.

You need to remove from the ORDER_ITEMStable those rows that have an order status of 0 or 1 in the ORDERStable.
Which two DELETEstatements are valid (Choose two.)
DELETE *

• A.FROM (SELECT * FROM order_items I,orders o
  WHERE i.order_id = o.order_id AND order_status IN (0,1));
  DELETE FROM order_items i
• B.WHERE order_id = (SELECT order_id FROM orders o
  WHERE i.order_id = o.order_id AND order_status IN (0,1));
  DELETE
• C.FROM order_items
  WHERE order_id IN (SELECT order_id)
  FROM orders
  WHERE order_status IN (0,1));
  DELETE
• D.FROM order_items
  WHERE order_id IN (SELECT order_id
  FROM orders
  WHERE orders_status in (0,1));

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the MEMBERStable.

Which query can be used to display the last names and city names only for members from the states MO and MI?
SELECT last_name, city FROM members WHERE state ='MO' AND state ='MI';

• A.SELECT DISTINCT last_name, city FROM members WHERE state ='MO' OR state ='MI';
• B.
• C.SELECT last_name, city FROM members WHERE state LIKE 'M%';
• D.SELECT last_name, city FROM members WHERE state IN ('MO', 'MI');

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about selecting related rows from two tables based on entity relationship diagram (ERD)?

• A.Implementing a relationship between two tables might require joining additional tables.
• B.Every relationship between the two tables must be implemented in a Join condition.
• C.Relating data from a table with data from the same table is implemented with a self join.
• D.An inner join relates rows within the same table.
• E.Rows from unrelated tables cannot be joined.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)

• A.The nested query executes after the outer query returns the row.
• B.The nested query executes first and then the outer query executes.
• C.The outer query executes only once for the result returned by the inner query.
• D.Each row returned by the outer query is evaluated for the results returned by the inner query.

Comment: *

Name: *

Email: *

Verification: *