How many clustered index can you have in one SQL Server Table?

Options :
  1. 256
  2. 1
  3. 1024
  4. 124


Answer and Explanation :-

Answer: Option 2

Explanation:

You can have only one clustered index in SQL server. By default when you create primary key in a table than automatically clustered index is been created.

How do you rate this queston?  Very Easy  Easy  Average  Above Average  Tough

Previous Question : From Which version COUNT_BIG() function is included in SQL Server

Next Question : What is the maximum count of column you can have in SQL Server 2012

Click here for free online test on SQL Server

Responses


 (Getemail alerts when others member replies)

More available Categories:








Man is a mystery. It needs to be unravelled, and if you spend your whole life unravelling it, don't say that you've wasted time. I am studying that mystery because I want to be a human being.
-Fyodor Dostoyevsky