| Other Oracle General Interview Questions |
|| Asked @
|how many triggers we can create on a table
|What does a Control file Contain ?
|what is candidate key & super key
|SELECT * FROM
(SELECT TITLE FROM MOVIE ORDER BY RANK DESC)
WHERE ROWNUM > 4;
when i run the above query .it produces output as NO ROWS
SELECTED.why ?plz any one help me
|What is Trace File ?
|What is the effect of setting the value "CHOOSE" for
OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
|What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
|Is it possible to join two tables, that are in two different
users (e.g. SCOTT and HR etc.),but im same database
If yes, then how it is possible?
Explain with step by step procedure.
|how to get the second max val for every group in a table
|What is cluster Key ?
|what are the different types of cursors? explain?
|Q) How to Find Max Date from each Group? (Asked in Infosys
|For more Oracle General Interview Questions Click Here |