Evaluate the following SQL statement:
SQL> select cust_id, cust_last_name "Last name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses either one of which can complete the query. (Choose three.)

View the Exhibit and examine the data in the PROMOTIONS table.

PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr.
You need to produce a report that provides the name, cost, and start date of all promos in the POST category that were launched before January 1, 2000.
Which SQL statement would you use?

You need to display the first names of all customers from the CUSTOMERStable that contain the character 'e' and have the character 'a' in the second last position.
Which query would give the required output?
SELECT cust_first_name

The EMPLOYEES table contains columns EMP_IDof data type NUMBERand HIRE_DATEof data type DATE.
You want to display the date of the first Monday after the completion of six months since hiring.
The NLS_TERRITORYparameter is set to AMERICAin the session and, therefore, Sunday is the first day of the week.
Which query can be used?
SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;

Evaluate the following SQL statement:
SELECT product_name || 'it's not available for order'
FROM product_information
WHERE product_status = 'obsolete';
You received the following error while executing the above query:
ERROR
ORA-01756: quoted string not properly terminated
What would you do to execute the query successfully?