Oracle (SQL) questions

1. #table refers to a local temporary table and is visible to only the user who created it

True/False

2. Which does not eliminate duplicate rows?

union all, minus, intersect, union

3. Transaction rollbacks affect Table variables

True/False

4. What is output?

SELECT Countries.name, Countries.cityID, Cities.cityID, FROM Countries LEFT OUTER JOIN Cities ON (Countries.cityID = Cities.cityID)

All rows from Countries even if no match in Cities, All rows from Cities even if no match in Countries, Cartesian product, Both A and B