Which two statements are true regarding single row functions? (Choose two.)

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?

Evaluate the following query

What is the correct output of the above query?

Examine this list of queries:
1. SELECT ROUND (TRUNC (15, 193, 1)) ''Results'' FROM DUAL;
2. SELECT ROUND (15, 193, 1)) ''Results'' FROM DUAL;
3. SELECT (TRUNC (15, 193, 1)) ''Results'' FROM DUAL;
4. SELECT ROUND (ROUND (15. 193, 1)) ''Results'' FROM DUAL;
Which two statements are true?

View the Exhibit and examine the structure of the CUSTOMERS table.
Using the CUSTOMERS table, you must generate a report that displays a credit limit increase of 15% for all customers.
Customers with no credit limit should have "Not Available" displayed.
Which SQL statement would produce the required result?