Examine the ORDER _ITEms table:

Which two queries return rows where QUANTITY is a multiple of ten?

View the exhibit and examine the description of the PRODUCT_INFORMATIONtable.

Which SQL statement would retrieve from the table the number of products having LIST_PRICEas NULL?

Which two statements are true about a full outer join? (Choose two.)

You execute this query:

What is the result?

View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables.

Evaluate the following MERGE statement:
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?