what type of indexes physically sort data?

Answer Posted / vikas kant

Clustered Index---It Reorders the way in which the data is
physically stored.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

800


What is onf in normalization form?

768


What does it mean if @@cursor_row returns a negative number?

717


can we have a nested transaction? : Sql server database administration

693


What is the usage of sign function?

774






What is transaction server distributed transaction?

718


On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

844


Differentiate sql server reporting services vs. Crystal reports?

166


What is replication and database mirroring?

788


Explain trigger classes i.e. Instead of and after trigger?

639


What is table level trigger?

760


Can foreign key be duplicate?

801


how to determine the service pack currently installed on sql server? : Sql server database administration

737


What happens if time-only values are provided as date and time literals?

720


which table keeps the locking information? : Sql server administration

704