View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables.

The CUSTOMERS table contains the current location of all currently active customers. The CUST_HISTORY table stores historical details relating to any changes in the location of all current as well as previous customers who are no longer active with the company.
You need to find those customers who have never changed their address.
Which SET operator would you use to get the required output?

Examine this partial command:

Which two clauses are required for this command to execute successfully? (Choose two.)

Examine the structure of the INVOICEtable.

Which two SQL statements would execute successfully?
SELECT inv_no, NVL2(inv_date, 'Pending', 'Incomplete')

Which three statements are true? (Choose three.)

Examine the description of the PRODUCT_STATUStable:

The STATUScolumn contains the values 'IN STOCK'or 'OUT OF STOCK'for each row.
Which two queries will execute successfully? (Choose two.)