Question 46

View the exhibit and examine the data in ORDERS_MASTERand MONTHLY_ORDERStables.

Evaluate the following MERGEstatement:
MERGE_INTO orders_master o
USING monthly_orders m
ON (o.order_id = m.order_id)
WHEN MATCHED THEN
UPDATE SET o.order_total = m.order_total
DELETE WHERE (m.order_total IS NULL)
WHEN NOT MATCHED THEN
INSERT VALUES (m.order_id, m.order_total)
What would be the outcome of the above statement?
  • Question 47

    Which three statements are true about Structured Query Language (SQL)?
  • Question 48

    Which three statements are true reading subqueries? (Choose three.)
  • Question 49

    Examine the description of the transactions table:
    Which two SQL statements execute successfully?
  • Question 50

    Which three are true about privileges and roles? (Choose three.)