Answer Posted / manisha
cluster index sorts the data ,so its affects the physical
arragement,while non clustered does not sorts the data.
a table can have max of 1 clustered index but can have upto
249 non clustered index.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
List out different types of normalizations in sql server and explain each of them?
How do I get to sql server configuration manager?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What xml support does the sql server extend?
What is statement level trigger?
What is report rendering ?
What is a mixed extent?
How do I port a number to sql server?
How to return the top 5 rows from a select query in ms sql server?
what stored procedure would you use to view lock information? : Sql server administration
What is the most common type of join?
Why truncate is ddl command?
How to convert a numeric expression from one data type to another?
What is de-normalization and what are some of the examples of it?
Differentiate between SQL and ORACLE joins and write their syntax.