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

Is join same as left join?

0 Answers  


Why do we need a foreign key?

0 Answers  


What is mdf ldf and ndf?

0 Answers  


Explain the advantages and disadvantages of stored procedure?

0 Answers  


Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

1 Answers   TCS,






how to convert dates to character strings? : Sql dba

0 Answers  


How many commands are in sql?

0 Answers  


How do I run a pl sql program?

0 Answers  


which types of join is used in sql widely? : Sql dba

0 Answers  


write a query to find 4th max salary

7 Answers  


What is sql and its types?

0 Answers  


What is the use of function "module procedure" in pl/sql?

0 Answers  


Categories