Oracle SQL questions

1. what is output of this query

SELECT e.role, j.jobtitle, j.jobname from employee e left outer join jobs j on (e.jobtitle = j.jobtitle)

2. What is the output of this query

select * from table where tableid = null

3. What is the output if subquery returns no rows.

select name, date, job from table where name = (select name from table where name = "David")

4. You can place the subquery in ____ of SELECT statement

where, having, from, all of the above

5. Which is false about single-row functions

accept arguments and return one value per argument, manipulate data items, act on each returned row, can be nested

6. Which is false about group functions

cant use where to restrict group, use having to restrict groups, cant use group functions in where clause

7. What is returned if name column contains Nulls

select name, date, job from table where name NOT IN (select name from table)