Question: 1
Which three statements execute successfully?
A)
B)
C)
D)
E)
F)
G)
Question: 2
Examine this statement which returns the name of each employee and their manager:
You want to extend the query to include managers with no employees. What must you add before join to do this?
Question: 3
In your session , the NLS_DATE_FORMAT is DD_MM_YYYY.
There are 86400 seconds in a day.
Examine this result:
Which statement returns this?
Question: 4
Which two statements are true about dropping views?
Question: 5
Examine this statement:
SELECT cust_id, cust^last_ndma "Last Name"
FROM customers
WHERE country_id --- 10 UNION
SELECT cust_ID_CUST_NO, cust_last_name
PROM customers
WHERE country__id = 30
Identify three order by clauses, any one of which will complete the query successfully.
