SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Answer - Objective Question (Which table is called Heap table in SQL Server)


   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.

Vivek's SQL Notes

Vivek johari is currently a Analyst and have more that 5.5 yeras of experience in database. He has Master degree in Computer and also he is Microsoft certified Sql DBA (MCTS)& Microsoft certified SQl BI professional(MCTS). He is also Oracle certified profession(OCP)DBA in ORACLE 10g and ORACLE 9i.He has the experience of working in PL/SQL, T-SQL and SSIS/SSRS. His work basically involved designing and optimization of the Database.He has also published many database articles on his blog Technologies with Vivek Johari.


Leave a comment on the original post [feedproxy.google.com, opens in a new window]

Loading comments...