| Other Oracle General Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is the syntax of DELETE command? | | 3 |
| which statement is running fastly ie insert or delete? | Oracle | 7 |
| Differnce between view and index | | 1 |
| Please explain the difference between outer join and inner
join? With examples would be appreciable..! | IBM | 2 |
| what is the syntax of ALTER command? | | 6 |
| How can we manage the gap in a primary key column created
by a sequence?
Ex:a company has empno as primary key generated by a
sequence and some employees leaves in between.What is the
best way to manage this gap? | Infosys | 1 |
| What is the difference between column level constraints and
table level constraints? | IBM | 3 |
| difference between oracle8i and oracle9i | NIIT | 3 |
| What is meant by redo log buffer ? | | 2 |
| What are Schema Objects ? | | 1 |
| how many types of index? | Cap-Gemini | 1 |
| find out the second highest salary? | | 6 |
| which is the best training centre for learning oracle? | | 3 |
| difference between imlicit cursor and explicit cursor ? | Cap-Gemini | 1 |
| What is cluster Key ? | | 1 |
| Write a simple Store procedure and pass parameter to it ? | Keane-India-Ltd | 1 |
| Table Has C1 And C2 Column If Exits any record in c1 then
Update c2 record Otherwise insert new record in the C1 And
C2 (Using Procedure) | Thermotech | 4 |
| Define 'view' advantage ? | AZTEC | 2 |
| what is difference between where clause and having clause? | | 7 |
| what diffrence between function and procedure? | | 3 |
| |
| For more Oracle General Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
