Interested to Buy Any Domain ? << Click Here >> for more details...
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
Equi join and non equi join is possible with sql server?
How do you create a clustered index?
Give me any three differences between Truncate and Delete.
Explain how many types of relationship?
Can we write trigger for view?
What are subqueries in sql server?
Can we check locks in database? If so, how can we do this lock check?
How to create an index on a view?
Is resultset an interface?
What is sql server profiler trace data file?
How does index makes search faster?
Difference between DELETE and TRUNCATE?
What are orphan records?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is the difference between a stored procedure and a user defined function?
