Which table is called Heap table in SQL Server.
1) Table without any indexes
2) Table without any clustered index (Correct Answer)
3) Table without any non clustered Index
4) None of the above
Many people attempted this question and mostly gives the correct answer. The correct answer is option 2 ( Table without any clustered index). Heap table in SQL Server is defined as the table which do not have any clustered index defined on it.
Thanks to all who attempted this question.