1:   How many clustered index can you have in one SQL Server Table?
Options:
  1. 256
  2. 1
  3. 1024
  4. 124

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. Discuss this in Forums

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

2:   From Which version COUNT_BIG() function is included in SQL Server
Options:
  1. Version 2000
  2. Version 2005
  3. Version 2008
  4. Version 2012

Answer: Option 2

Explanation:

COUNT_BIG() aggregate function is included in SQL Server version 2005. COUNT_BIG function return the total number records as big integer. Discuss this in Forums

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

3:   What is the use of Count_Big() function in SQL Server
Options:
  1. Return the Boolean value
  2. Return the total number of records in in Int
  3. Return the total number of records in in Big Int
  4. There is no such function in T-SQL

Answer: Option 3

Explanation:

COUNT_BIG() is an aggregate built function in SQL Server which will return the total number of records in a form of Big Integer Discuss this in Forums

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

4:   How to reset the identity column in SQL Server?
Options:
  1. DBCC CHECKIDENT ('tableName', RESEED, 1)
  2. DBCC RESET ('tableName', RESEED, 1)
  3. RESET IDENTITY('tableName', RESEED, 1)
  4. TSQL CHECKIDENT ('tableName', RESEED, 1)

Answer: Option 1

Explanation:

You can reset the identity column using TSQL using below TSQL. DBCC CHECKIDENT ('tableName', RESEED, 1) In above example order is the table name and 1 is the next insert record id Discuss this in Forums

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




Download StudyAlways app from google play





My father told me that it is only a mad man that keeps bushy hairs. I asked him, "what about the great men with bushy hairs?". He replied, "education had made them mad, so study to be wise and sane.
-Michael Bassey Johnson