What is Library Cache in Oracle?
What is set verify off in oracle?
Differentiate between function and procedure in oracle.
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)
what is view?
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
Explain what are synonyms used for?
Can group functions be used in the order by clause in oracle?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is the scope of a local variable?
how to find the n'th highest salary from emp ?
What is a dead lock in oracle?
List the various oracle database objects?