| Other Oracle General Interview Questions |
| |
| Question |
Asked @ |
Answers |
| |
| what is the output of select * from emp where null=null &
select * from emp where 1=1 |
NIIT | 7 |
| what is the syntax of INSERT command? |
| 7 |
| Please explain the difference between outer join and inner
join? With examples would be appreciable..! |
IBM | 5 |
| without using count(*) and rownum how can we count total
record in a table |
HP | 4 |
| Define the terms primary key foreign key and also the
difference between primary and the unique key |
| 2 |
| What is currency type in database ? |
TCS | 3 |
| If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column? |
IBM | 8 |
| What is SAVE POINT ? |
| 5 |
| How to select the name of employee who is getting maximum
sal with out using subquery |
| 15 |
| how to select alphabets in a one column , for this the
table name is PA_TASKS and column name is TASK_NUMBER, In
TASK_NUMBER the data like this
1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For
this i need to disply output as only NN,but not other
alphabets, if NN is thre means i should display , otherwise
leave that blank or empty Its some urgent
requirement ,thanks in advance |
| 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 |
| which is best insttute for teradata,sybase,mysql,oracle in
hyderabad |
| 1 |
| |
| For more Oracle General Interview Questions Click Here |
Site Map
