Interview Questions and Answers on SQL SERVER Part II

                             Hi friends,in this article i will explain some interview questions on sql server,in previous article i already explained Interview Questions and Answers on SQL SERVER Part I,ASP.NET Interview Questions Part II | .NET interview Questions fot 1-2 years Experience

and  Interview Questions on .NET

Which TCP/IP port does SQL Server run on? How can it be changed?

The default TCP port for Sql Server is 1433 and TCP port for DAC (dedicated admin connection ) is 1434.

You can change the port number SQL server should use through SQL net configuration manager.

 It can be changed from the Network Utility TCP/IP properties –> Port number.both on client and the server.

______________________________________________________________

What are the different index configurations a table can have?

Any typical SQL Server table can consist of these following index configurations:

1.     No indexes at all

2.     A clustered index

3.     A clustered index and many non-clustered indexes

4.     A non-clustered index

5.     Many non-clustered indexes (of course limited to maximum of 999 in SQL Server 2008 R2 and 249 in prior versions

________________________________________________________

What's the difference between a primary key and a unique key?

Simply primary key is always unique and not null but unique key is only unique it can be null.

Primary key:
1) Primary key is nothing but it is uniquely identified each row in Table.
2) Primary key does not Allows Duplicate values and Null values.
3) One table can have only one Primary key.
Unique Key:
1) Unique Key is nothing but it is uniquely identified each row in Table.
2) Unique Key does not Allows Duplicate values but allows only one Null value.

______________________________________________________________

Which command using Query Analyzer will give you the version of SQL server and operating system?

The following command give the version of SQL Server and operating system.

SELECT SERVERPROPERTY ('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition').

_____________________________________________________________

"If you like my blog or articles, you can appreciate by leaving your comments or Liking my Facebook page Aspdotnet-kishore, following on Google+ Aspdotnet-Kishore, Twitter  on AspdotnetKishore, Linked in Aspdotnet-Kishore, stumbling my posts on stumble upon and subscribing on  RSSfeed Aspdotnet-Kishore for free updates directly to your Email inbox . Watch my blog  for more articles"