Interview Questions

set operators

decode stmt with expression
cursor attributes,
parameterized and ref cursors
diff type of exceptions
how to defin user defined exceptions
pragma exception init
can we use out parameter in function
pass by value and pass by reference
advantage of package over procedure
forward declaration
diff type of triggers
procedure overloading
Bulk Collect and Bulk Bind
Volatile table


Synonym with same table name
Sequence
alter sequence
sequence at threshold
all_sequences/user_sequences
anonymous proc in a package?
functional overloading with return type: same or diff?
rules of overloading, and when it needs name notation of calling?
when a function can be called in a select stmt?
commit or rollback in a function?
ddl in a trigger?
ordering of tow before update trigger.
creating a view on not existing table?
decode vs case.
Exists vs In ... why one is faster.
rollup and cube?