SQL Questions on Joins and Set operations:

Answer the following questions:

Please, say True/False. If False, say why?

1. If a table has three rows and another table has four rows, their product will contain seven rows.-----------

2. The common column in two tables must have same name in order to join them.------------

3. You always need at least two different tables for a join.--------------------

4. A table alias is known in the query in which it is created.--------------------------

5. n+1 join conditions are needed to join n tables. -------------------------

6. The set operator UNION ALL does not repeat duplicate rows, but UNION does.-----------

7. TableA MINUS TableB is same as TableB MINUS TableA all the time.---------------------

8. A self join can be performed on any table, because all you need is one table.----------------

9. An outer join usually returns more information than an equijoin on same tables.-----------