What is a table called, if it does not have neither Cluster
nor Non-cluster Index?

Answer Posted / gurudatt nayak

it is called as a heap table

Is This Answer Correct ?    15 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is de-normalization in sql database administration? Give examples?

540


What are the types of joins in sql?

563


How to transfer data from a cursor to variables with a "fetch" statement?

586


Differentiate between delete and truncate.

580


What are the different types of collation sensitivity in sql server?

588






What are the different types of stored procedures?

556


How to loop through result set objects using odbc_fetch_row()?

471


Does the unique constraint create an index?

568


What are the properties of sub-query?

585


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1854


What is the use of RDBMS?

591


What is meant by referential integrity?

593


What are the underflow and overflow behaviors on float literals?

580


What is an execution plan? When would you use it?

581


What is plan freezing?

586