| Other Oracle General Interview Questions |
| |
| Question |
Asked @ |
Answers |
| |
| what is candidate key & super key |
| 1 |
| what is the difference between primary key & foreign key? |
Sparsh | 57 |
| What are the different approaches used by Optimizer in
choosing an execution plan ? |
| 1 |
| structural difference between bitmap and btree index ? |
Infosys | 1 |
| 1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.
|
| 6 |
|
select to_char('10','10')
from dual
This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL
why? pls help |
| 6 |
| What is a Data Segment ? |
| 2 |
|
hai,
I am searching job on Oracle10g and PL/sql,Unix...
can any one send me resume format.
an suggest me how to prepare..
ann books..
|
| 1 |
| Can we call a trigger inside a function and function inside a
trigger? Give example. |
| 1 |
| i can create a view with two columns from emp table,, later
i need to add one more emp column to existing view.. what is
query
similarly add one more column to existing primary key
constraint.. please give me the solutions |
CGI | 4 |
| 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 |
TCS | 6 |
| What is a Schema ? |
| 5 |
| |
| For more Oracle General Interview Questions Click Here |
Site Map
