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 do I copy a table in sql?

0 Answers  


how to retrieve the top 3 salaries of the table using rownum

31 Answers   Oracle,


Show the two pl/sql cursor exceptions.

0 Answers  


What is trigger in sql? Explain

0 Answers  


What is string join?

0 Answers  






What is sql injection vulnerability?

0 Answers  


What is cursor and why it is required?

0 Answers  


Is it possible to create the following trigger: before or after update trigger for each row?

0 Answers  


List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,


Query for second maximum salary in each in each department

15 Answers   DST Global Solutions, TCS,


what is the difference between group by and order by in sql? : Sql dba

0 Answers  


Why left join is used in sql?

0 Answers  


Categories