.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

Database: State Can an Identity column be index?

Posted By :shankey     Posted Date :July 27, 2011    Points :40   Category :Sql Server 
No, Identity and GUID column do not need to be indexed.

You can also find related Interview Question to Database: State Can an Identity column be index?  below: 

Database: Define Identity Column?

Identity column is a column that automatically generates numeric values. Start and increment value are the two properties of prior importance that need to be set with respect to Identity column. Value of this column is mostly used to identify each row uniquely (More...)

Is it possible to create Cluster Index on Unique Key Column?

Unique key column by default creates a non-cluster index on the column. Primary key creates cluster index on the column. The only difference is Unique key column allows only one null value. So is it possible to have cluster index on Unique key column?

The answer is YES. Though Unique key allows null value but it still maintains the uniqueness of the column. (More...)

More than one IDENTITY column per table can be exist in SQL Server . (True /False)

There can only be one IDENTITY column per table in SQL Server.
Its auto Incremented Column defined by the user. (More...)

To find a particular column name where it exists in a database?

The Query to find the particular column name in a databse is,


Can we insert a value for the identity Column in Sql Server?

Yes, We can insert the value for Identity column




INSERT INTO #Temp(ID, EmpName)
Values(10, 'Alwyn Duraisingh.M')

Database should be created as a SINGLE_USER state Whenever you create a new Database. What should you do ?

1. Normally, when we create a new database, All the properties will be inherited from the Model database.

2. So, Just change the Model database's State to SINGLE_USER.

3. Now onwards, The new database will be created as SINGLE_USER state. (More...)

Database: State whether Trigger is a stored procedure or not?

.Yes, It is a Stored procedure that initiates an action when an event occurs. (More...)

Database: State whether a trigger can be called or executed?

.No, It is called by DBMS automatically whenever any changes are made to the associated table. (More...)

Database: state whether function and Views are similar in some respect?

Yes, Function take parameters and can be used in joins and other row set operations. (More...)

Database:State whether the TCP/IP port can be changed on which SQL Server run

Yes, It can be changed from
1)Network utility TCP/IP properties
2)Port number, both on client and server (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend