> ================================================
> Q Which clause of a SELECT command is most likely to improve performance
> when used with indexed columns?
>     A Connect by clause
>     B Where clause
>     C Group by clause
>     D Order by clause
I think the right answer is B - fields in where clauses can use indexed for
filtering and do INDEX RANGE (UNIQUE) SCAN's instead of FULL SCANs.

> Q If one of the columns in your table will store percentage information to
> almost infinite decimal place,then what is the most suitable datatype that
> you would choose to associate that column.?
>     A Number
>     B Number(14,2)
>     C Long
>     D Raw
>     E Long Raw
I suppose that Number is the most suitable datatype, because in Number(14,2)
you can't store more than 2 numbers after decimal point.

> Q If one of the columns in your table will store calculated information
> which would lead to a result of almost infinite number before the decimal
> place and two digits after the decimal place,then what datatype would you
> choose to associate that column.?
>     A Number
>     B Number(14,2)
>     C Raw
>     D Long
>     E Long Raw
Once again it's Number. You can do simple tests to check it out. I did :)

> Q In SQL*Plus, '!' and HOST command perform the same function.
>  True
>  False
Oops, I don't use SQL*Plus in my everyday work...

With best wishes,
Dmitry Sirotkin.