Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
What is a table called, if it has no Cluster Index?
on 9/9/2009 | Category:
Sql Server Interview questions
| Views: 7181
Unindexed table or Heap.
Many Interviews |
< Previous :
What command do we use to rename a db, a table and ...
Next > :
How to get @@ERROR and @@ROWCOUNT at the same time ...
Comments or Responses
Your question is:
What is a table called, if it has neither Cluster nor Non?cluster Index?
Your answer is:
Unindexed table or Heap
A table doesn't have CLUSTERED Index is called
: A table which has Non-Clustered index, will not sort the data Physically.
So the data physically not sorted then it will be called as HEAP structure.
So. The table also called as HEAP even it has Non-Clustered Index.
So, Pl try to change your Question / Answer accordingly. Sorry for this kind of reply.... I am trying to steer right way, not anything else. Pl take it as Optimistic.
Thanks for bringing into notice. I have modified the question.
Login to post response
More Interview Questions by Virendradugar
How to get @@ERROR and @@ROWCOUNT at the same time?
What is the difference between a Local and a Global temporary table?
What is Row_Number()?
Suppose Page_load event is defined in aspx page and same page_load eve ...
Is it possible to create Cluster Index on Unique Key Column?
Can we declare private class in a Namespace?
What is a private constructor? Where will you use it?
Difference between new and override keyword?
Latest Interview Questions
________is one of the new feature added in C# 4.0 ?
How can we access COM object in C#4.0?
________ is new type introduced in C#4.0?
Which is the base class for TypedDataset
Which of the following class does not belong to Collection namespace ?
Which property of textbox cannot be change at run time?
What is the name of base class for .NET
Is it Possible to create more than one machine config file.