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 are the disadvantages of not performing database normalization?

0 Answers  

Why cross join is used?

0 Answers  

Does sql*plus have a pl/sql engine?

0 Answers  

How do I remove sql plus from windows 10?

0 Answers  

how many sql ddl commands are supported by 'mysql'? : Sql dba

0 Answers  

IF i write before / after insert / update trigger and i do rollback what will happen?

5 Answers   KPIT,

What is left inner join in sql?

0 Answers  

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

10 Answers   TCS,

What is the maximum database size for sql express?

0 Answers  

Write a sql query to convert all character to uppercase after hypen.

0 Answers  

How do I start sql from command line?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories