Recommended For You

 

Top 50 Best Interview Question and answer on Oracle Pl/Sql
Top 50 Best Interview Question and answer on Sql
Top 10 Way To Handle Performance Tunning Of Sql Query
Top 25 oracle Pl/sql interview questions and answer by companies
Top 10 Way To Handle Performance Tunning of Procedure and Function
Top 100 Pl/Sql objective type question and answer
Top 5 way to make money at home

5 simple ways to save more money

How To Get Six Pack Abs in Just 30 Days

Top 10 battery tips for your smartphone or tablet

Booking.com Booking.com

 

 

Top 25 oracle interview questions and answer by L & T Infotech, Tcs, Infosys

 

 

Try below basic query,Execute it and check the output.

1. What is the role in current/last project?

 

Common for experience people.
First explain Name of your project, client location, nature of your project.
Now what is your role whether your were involved in development or in support and maintenance or
any documentation related work if you were in support project, then explain how you provide support to client issue.
what was your analysis way and how you prepared document related with support issue, on what basis you created that document.
In this you need to explain to whom you reporting and how many resource under you ,had you review any technical code or functional document at any time.

 

 

 

2. How you handle performance issue?

 

Top 10 Way To Handle Performance Tunning Of Sql Query

 

Top 10 Way To Handle Performance Tunning of Procedure and Function

 

 

 

3.What is the sequence in handling performance issues?

 

Top 10 Way To Handle Performance Tunning Of Sql Query

 

Top 10 Way To Handle Performance Tunning of Procedure and Function

 

 

 

4. What performance issue you faced how you handled it ?

 

Explain any performance related issue you faced such as related with any report or any procedure or package.
Fellow above question,may be it help you.

 

5. What are the features in 11g?

 

Below are new features in oracle 11g

Sequence assign
Regexp_count
Compound trigger
follow/precede trigger
read only table,read write table
function call
simple_integer
listagg function
pivot and unpivot
reference partition
virtual column
invisible index
continue statement
named notation in sql
result cache

 

 

Page-2