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?

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 query:

Which two methods should you use to prevent prompting for a hire date value when this query is executed?

View the exhibit and examine the descriptions of the DEPTand LOCATIONStables.

You want to update the CITYcolumn of the DEPTtable for all the rows with the corresponding value in the CITYcolumn of the LOCATIONStable for each department.
Which SQL statement would you execute to accomplish the task?
UPDATE dept d

Examine this SELECT statement and view the Exhibit to see its output: (Choose two.) SELECT constraints_name, constraints_type, search_condition, r_constraints_name, delete_rule, status, FROM user_constraints WHERE table_name = 'ORDERS'; Which two statements are true about the output?