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


Top 5 Contributors of the Month
Lee Hnetinka
mithun


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


Post New Question Subscribe to Interview Questions
 
Quick Links For Interview Questions Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  OOPs  JQuery  JavaScript/VBScript
BiztalkPatten/PracticesIISWCFWPFWWF
NetworkingAptitudeOthers  All    
 

Sql Server Interview Questions and Answers

What is a Stored Procedure?

Author: Shashi Ray          Posted Date: October 03, 2008    Category: Sql Server     Points: 10

Its nothing but a set of T-SQL statements combined to perform a single task of several tasks. Its basically like a Macro so when you invoke the Stored procedure, you actually run a set of statements.

What is normalization?

Author: Shashi Ray          Posted Date: October 03, 2008    Category: Sql Server     Points: 10

Well a relational database is basically composed of tables that contain related data. So the Process of organizing this data into tables is actually referred to as normalization.

Which authentication mode lets you use both SQL Server logins and Windows logins?

Author: Shashi Ray          Posted Date: September 10, 2008    Category: Sql Server     Points: 10

Mixed Mode authentication mode lets you use both SQL Server logins and Windows logins?

When do you need to specify an external data source by using a linked server?

Author: Shashi Ray          Posted Date: September 10, 2008    Category: Sql Server     Points: 10

When you need to access a different instance.

What do you need to specify to create a linked server?

Author: Shashi Ray          Posted Date: September 10, 2008    Category: Sql Server     Points: 10

OLE DB Data Source

What are the requirements to create a CLR based user-defined type?

Author: Shashi Ray          Posted Date: September 10, 2008    Category: Sql Server     Points: 10

CLR must be enabled for the instance and A class created with a CLR-compatible language.

What is a Index?

Author: Shashi Ray          Posted Date: September 10, 2008    Category: Sql Server     Points: 10

To execute the Quesry faster

Which levels of the index can have multiple pages?

Author: Shashi Ray          Posted Date: September 10, 2008    Category: Sql Server     Points: 10

Leaf

Which type of index physically orders the rows in a table?

Author: Shashi Ray          Posted Date: September 10, 2008    Category: Sql Server     Points: 10

Clustered index

Which index option causes SQL Server to create an index with empty space on
the leaf level of the index?

Author: Shashi Ray          Posted Date: September 10, 2008    Category: Sql Server     Points: 10

FILLFACTOR



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