Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Initially question was asked to mention the types of indexes.
Then asked about BITMAP INDEX and B-Tree Index

Question Posted / manaswinig

Answers were Sorted based on User's Feedback



Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-..

Answer / slokh

Bitmap index is a type of index created on the basis of the
column having low cardinality like. index created on the
column like 'gender' etc.


B-tree or binary index is created on the column contains
wide range of values like 'name' column.

note:- more than one index is created on the table.

Is This Answer Correct ?    9 Yes 0 No

Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-..

Answer / brajesh kr.

Bitmap:- index is special kind of index that uses bitmap .
it significant space and performance advantage over
structure for such data. it is also useful for unique value
data. it use bit arrays and answer queries by performing
bitmap logical operations on these bitmap.

B-Tree:-databse server uses a b-tree strucruyre to organize
index information shows that afully developed b-treee index
is composed of that following
1.Oneroot nodes
2. Two or more branch nodes.

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More SQL PLSQL Interview Questions

What is the full form of sql?

1 Answers  

What are the parts of a basic sql query?

0 Answers  

what is the difference between trigger and constraint?

3 Answers   HSBC,

What is the difference between cluster and non-cluster index?

0 Answers  

Types of cursors and explanation each of them ?

4 Answers   DELL,

Why we use stored procedure instead of query?

0 Answers  

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

What is the purpose of normalization?

0 Answers  

Is sql developer case sensitive?

0 Answers  

What is mutating sql table?

0 Answers  

How does postgresql compare to mysql?

0 Answers  

What are the new features in Oracle 10g. Compared to Oracle 9i?

1 Answers   Polaris,

For more SQL PLSQL Interview Questions Click Here
Categories