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
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
What is buffer cash in sql server?
How do I edit a procedure in sql server?
Why are views required in the sql server or in any other database?
what are the types of indexes? : Sql server database administration
What are Row versions of DataRow?
Does server sql treat char as a variable-length or fixed-length column?
What new data source types were added in ssrs 2014?
What is set nocount on?
What happens if strings are casted into wrong code pages in ms sql server?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What is named calculation? : sql server analysis services, ssas
Explain about SQLOS?
Describe how to use linked server?
