View the Exhibit and examine the structure of the CUSTOMERStable.

CUSTOMER_VUis a view based on CUSTOMERS_BR1 table which has the same structure as CUSTOMERStable.
CUSTOMERSneed to be updated to reflect the latest information about the customers.
What is the error in the following MERGEstatement?

Evaluate the following two queries:
SQL> SELECT cust_last_name, cust_city
FROM customers
WHERE cust_credit_limit IN (1000, 2000, 3000);
SQL> SELECT cust_last_name, cust_city
FROM customers
WHERE cust_credit_limit = 1000 or cust_credit_limit = 2000 or
cust_credit_limit = 3000
Which statement is true regarding the above two queries?

Which two statements are true about the results of using the intersect operator in compound queries?

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

Examine the following SQL statement:
SELECT order_id, product_id, unit_price
FROM order_items
WHERE unit_price =
(SELECT MAX(unit_price)
FROM order_items
GROUP BY order_id);
You want to display the PRODUCT_ID of the product that has the highest UNIT_PRICE per ORDER_ID. What correction should be made in the above SQL statement to achieve this?

Examine the structure proposed for the TRANSACTIONS table:

Which two statements are true regarding the storage of data in the above table structure? (Choose two.)