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.

About vivekjohari

Database Consultant with more than 11.5 years of experience in database designing & programming and DBA related activities.  Had good experience on different databases like SQL Server, MySQL & Oracle, Azure SQL &  Big Data.
This entry was posted in Interview Questions and tagged . Bookmark the permalink.

31 Responses to Answer – Objective Question (Which table is called Heap table in SQL Server)

  1. Pingback: portable jump starter

  2. Pingback: pirate show lego

  3. Pingback: agencia de viajes en managua

  4. Pingback: istanbul escort

  5. Pingback: judi poker

  6. Pingback: บาคาร่า

  7. Pingback: แหล่ง เงินกู้ ต่าง จังหวัด

  8. Pingback: tree service nashville tn

  9. Pingback: smart iptv, iptv m3u, m3u playlist, iptv kostenlos, iptv anbieter, iptv links, kodi iptv, m3u iptv, iptv playlist, kodi iptv m3u, iptv list, iptv m3u deutsch, iptv sky, iptv m3u playlist deutsch download, smart iptv download, iptv liste, iptv m3u german,

  10. Pingback: Totojitu

  11. Pingback: Togelsumo

  12. Pingback: how to make cornhole boards

  13. Pingback: Real Estate Broker West Bloomfield Michigan Keith Biggs

  14. Pingback: fifaqq

  15. Pingback: didi promo code

  16. Pingback: poker99

  17. Pingback: w88 club

  18. Pingback: inter qq

  19. Pingback: Accountant in Pensacola Florida

  20. Pingback: cutting dies

  21. Pingback: what does cbd oil taste like

  22. Pingback: Dream Market

  23. Pingback: Nachfolger

  24. Pingback: Macau International & Mice Travelers Market New Innovations, Research ,Key Players and Growth Factor

  25. Pingback: Slager hengelo

  26. Pingback: idrpoker

  27. Pingback:

  28. Pingback: The World in 2020 Economist Cover

  29. Pingback: ca cuoc the thao online

  30. Pingback: elangqq

  31. Pingback:

Leave a Reply