22.How many joins required to avod cartesian product?

ans: n-1 joins for n tables

23.Which of these are set operators?

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

ans :E

24.A single row subquery may return many values.

1. true
   
2. false
   

ans :B

25.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

26.Which statement resists the high water mark?

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

ans :A

27.Which statement will not end a transaction?

1. commit
   
2. alter
   
3. insert
   
4. create
   

ans:C

28.Long datatype can appear in

1. order by
   
2. where
   
3. group by
   
4. none of the above
   

ans:D

29.Which datatype stores data outside oracle?

1. long raw
   
2. blob
   
3. bfile
   
4. clob
   

ans:C

30.ALTER statement can rename a column

1. true
   
2. false
   

ans:B