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.

6. What are the different type of indexes?

 

 

 

Tpes of indexes

 

B tree index
bitmap index
cluster index
non-cluster index
invisible index
visible index

 

 

 

7. When to use bitmap index / btree index?

 

B-tree Index use with low cardinality values and Bitmap Index use with High Cardinality values.
B-tree Index is useful for OLTP, where as Bitmap Index is useful for Data Warehousing.

 

 

 

8. Any performance issue faced because of index?

 

Top 10 Way To Handle Performance Tunning of Procedure and Function

 

Top 10 Way To Handle Performance Tunning Of Sql Query

 

 

 

9. What are the new type of index in 11g?

 

visible index
invisible index
B-tree index
Bitmap index

 

 

 

10. What is NOCOPY ?where it is used?

 

NOCOPY hint tells the compiler to use pass by reference, so no temporary buffer is needed
and no copy forward and copy back operations happen.
NOCOPY hint doesnt used Pass By Value.

 

 

 

 

11. What are the difference type of parameters in a procedure?

 

Types of parameters
IN
OUT
INOUT

 

 

 

12. What is analytical function?

 

Analytical functions compute an aggregate value based on a group of rows.
Analytical function return multiple rows for each group.


Page-2