Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / guest

Answers were Sorted based on User's Feedback



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

Answer / gurudatt nayak

it is called as a heap table

Is This Answer Correct ?    15 Yes 2 No

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

Answer / debasish nanda

Unindexed table or Heap. Microsoft Press Books and Book on
Line (BOL) refers it as Heap. A heap is a table that does
not have a clustered index and, therefore, the pages are not
linked by pointers. The IAM pages are the only structures
that link the pages in a table together. Unindexed tables
are good for fast storing of data. Many times it is better
to drop all indexes from table and then do bulk of inserts
and to restore those indexes after that.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 Answers  

How to write a query with a full outer join in ms sql server?

0 Answers  

Do you know what is bit data type and whats the information that can be stored inside a bit column?

0 Answers  

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 Answers  

What is RAID and what are different types of RAID configurations?

8 Answers   Wipro,

What is a database in ms sql server?

0 Answers  

Explain important index characteristics?

0 Answers  

Explain what are the database objects? : SQL Server Architecture

0 Answers  

What is log shipping?

0 Answers  

What is a periodical index?

0 Answers  

Can you type more than one query in the query editor screen at the same time?

0 Answers  

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,

For more SQL Server Interview Questions Click Here
Categories