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

HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM

3 Answers  


Can procedure in package be overloaded?

0 Answers   EXL,


how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  


which will fire first ? Trigger or Constraint

24 Answers   i2, IBM,


Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

0 Answers  


What is Collation Sensitivity ? What are the various type ?

0 Answers  


what is difference between "Primary key" and "Unique key"?

4 Answers   PreVator,


What is sql used for?

0 Answers  


How do I quit sql?

0 Answers  


What does t sql mean?

0 Answers  


What is join view in sql?

0 Answers  


How will you select unique values from a list of records?

7 Answers   Cap Gemini,


Categories