| Other Oracle General Interview Questions |
|| Asked @
|what is the output of select * from emp where null=null &
select * from emp where 1=1
|what is the syntax of INSERT command?
|| ||7 |
|Please explain the difference between outer join and inner
join? With examples would be appreciable..!
|without using count(*) and rownum how can we count total
record in a table
|Define the terms primary key foreign key and also the
difference between primary and the unique key
|| ||2 |
|What is currency type in database ?
|If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?
|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
|| ||1 |
|For more Oracle General Interview Questions Click Here |