Answer Posted / c.jagadish
In sqlserver we have two types of indexes (1) Clustered (2)
non clustered indexes.
Indexes may be simple index or composite index.
Index formed based on single column values is called simple
index
index formed based on multiple column values is called
composite index.
Default index is NON CLUSTERED INDEX
When a table contains a primary key column then sqlserver
automatically creates a unique clustered index.
Unique--- automatically creates a non clustered index
so for this reason PRIMARY KEY IS NOT EQUAL TO UNIQUE + NOT
NULL.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
List some major differences between triggers and stored procedures?
What is a ddl statement?
Explain the concept of view and Types of views in SQL server?
What Is Rdbms?
How to concatenate two binary strings together?
What are the different index configurations a table can have?
Explain collation?
What is a trigger and types of a trigger?
Explain the different types of joins?
What are trace files?
Can binary strings be used in arithmetical operations?
what is the difference between count(*) and count(1) ?
What does set rowcount do?
What is 1nf normalization form?
