1.GROUP BY, ORDER BY can  be used in WHERE clause.

1. true
   
2. false
   

ans:B

5).How many joins required to avod cartesian product?

ans: n-1 joins for n tables

6).Which of these are set operators?

1. union
   
2. union all
   
3. intersect
   
4. minus
   
5. all of the above
   

ans :E

7).A single row subquery may return many values.

1. true
   
2. false
   

ans :B

8).select regionid,regioname as region from regions order by 1,regions group by regionid;

      Will the above statement successfully execute?

1. true
   
2. false
   

ans:B

9).Which statement resists the high water mark?

1. truncate
   
2. delete
   
3. drop
   
4. none of the above
   

ans :A