Examine the structure of the EMPLOYEEStable:

There is a parent/child relationship between EMPLOYEE_IDand MANAGER_ID.
You want to display the name, joining date, and manager for all employees. Newly hired employees are yet to be assigned a department or a manager. For them, 'No Manager' should be displayed in the MANAGERcolumn.
Which SQL query gets the required output?
SELECT e.last_name, e.hire_date, NVL(m.last_name, 'No Manager') Manager

You need to produce a report where each customer's credit limit has been incremented by $1000. In the output, the customer's last name should have the heading Nameand the incremented credit limit should be labeled New Credit Limit. The column headings should have only the first letter of each word in uppercase.
Which statement would accomplish this requirement?
SELECT cust_last_name AS "Name", cust_credit_limit + 1000

Examine the structure of the BOOKS_TRANSACTIONS table:

You want to display the member IDs, due date, and late fee as $2 for all transactions.
Which SQL statement must you execute?

View the exhibit and examine the structure of the STOREStable.
STORES table
Name Null? Type
----------------- ----- -------------
STORE_ID NUMBER
NAME VARCHAR2(100)
ADDRESS VARCHAR2(200)
CITY VARCHAR2(100)
COUNTRY VARCHAR2(100)
START_DATE DATE
END_DATE DATE
PROPERTY_PRICE NUMBER
You want to display the NAME of the store along with the ADDRESS, START_DATE, PROPERTY_PRICE, and the projected property price, which is 115% of property price.
The stores displayed must have START_DATEin the range of 36 months starting from 01-Jan-2000 and above.
Which SQL statement would get the desired output?

Which three statements are true regarding subqueries? (Choose three.)