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
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 |
Answer / sdp
A unique index is created when a primary key is created in
a table.
Is This Answer Correct ? | 10 Yes | 3 No |
Answer / suren
while creating primary by default a unique index is created
Is This Answer Correct ? | 4 Yes | 0 No |
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 |
How do I copy a table in sql?
how to retrieve the top 3 salaries of the table using rownum
Show the two pl/sql cursor exceptions.
What is trigger in sql? Explain
What is string join?
What is sql injection vulnerability?
What is cursor and why it is required?
Is it possible to create the following trigger: before or after update trigger for each row?
List the differences between plsql - function & procedures
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
Why left join is used in sql?