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

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

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

Question Posted / wgk

5 Answers
14871 Views
TCS, I also Faced
E-Mail Answers

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 delete a trigger?

0 Answers

Why use triggers in sql?

0 Answers

What is minus?

0 Answers

what is the different between unique+not null & primary key,

4 Answers

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers Cap Gemini, TCS,

wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

6 Answers Accenture,

Explain the insert into statements in sql?

0 Answers

how can we destroy the cookie? : Sql dba

0 Answers

1. how to use the check option constraints in sql query..? 2.how to add data in a complex query ? 3.is it possible to use commit or rollback or savepoint in triggers...if not why please explain with examples...? 4.what is the difference between meterialized view and normal view..how to create materialized view and how to use it..? 5.what is varray...? what is the advantage of the varray ? please expalin with a simpel example..i want to load into a table (student no and name and his marks..) please give example.. 6.what are the bulk bind exceptions...how to use bulk bind and how to use bulk collect..please explain with example... 7.what is for update of and where current of ...? 8 what is the use of nowait ? 9.please give an example for nocopy in a simple plsql query 10.create an index in a table...tellme how to use the index in a where clause to do performance tunning...

3 Answers Satyam,

What is difference between mysql and postgresql?

0 Answers

What is compiled query?

0 Answers

Define sql delete statement.

0 Answers

For more SQL PLSQL Interview Questions Click Here