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...


Types of indexes. What is the default key created when a
primary key is created in a table ?

Answers were Sorted based on User's Feedback



Types of indexes. What is the default key created when a primary key is created in a table ?..

Answer / mahesh

Major indexes are B-tree and Bitmap indexes

When ever we create a primary key, B-tree index will be
created

Is This Answer Correct ?    15 Yes 3 No

Types of indexes. What is the default key created when a primary key is created in a table ?..

Answer / sdp

A unique index is created when a primary key is created in
a table.

Is This Answer Correct ?    10 Yes 3 No

Types of indexes. What is the default key created when a primary key is created in a table ?..

Answer / suren

while creating primary by default a unique index is created

Is This Answer Correct ?    4 Yes 0 No

Types of indexes. What is the default key created when a primary key is created in a table ?..

Answer / manish_patil

There are main two types of indexes,
B-tree index
Bitmap index.

While creating Primary key by default cluster index get
crated.

Is This Answer Correct ?    7 Yes 5 No

Types of indexes. What is the default key created when a primary key is created in a table ?..

Answer / thirupathi

default index will be created

Is This Answer Correct ?    2 Yes 5 No

Post New Answer

More SQL PLSQL Interview Questions

What is insert command in sql?

0 Answers  


Wat is SGA ?

3 Answers   ABB,


I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On

6 Answers   DELL, HCL, Oracle,


Why we use joins in sql?

0 Answers  


What are the possible values that can be stored in a boolean data field?

0 Answers  


How can we implement rollback or commit statement in a trigger?

0 Answers  


There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,


What is procedure explain with example?

0 Answers  


What is the difference between left join and left outer join?

1 Answers  


what is the output of this query selet * from employee where 1=2 ??

11 Answers  


Which are the different case manipulation functions in sql?

0 Answers  


What is the difference between an inner join and an outer join?

0 Answers  


Categories