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



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/Practices.IISWCFWPFWWF
NetworkingAptitudeOthers  All    
 

Interview Questions And Answers

If the rows are more than 2 billion, how can I set the rowcount?

Author: nishithraj          Posted Date: 16/03/2010    Category: Sql Server     Points: 10

Using ROWCOUNT_BIG statement.

What is the maximum number rows can be returned in SqlServer by the @@ROWCOUNT?

Author: nishithraj          Posted Date: 16/03/2010    Category: Sql Server     Points: 10

2 billion rows.

How can we cancel a transaction?

Author: nishithraj          Posted Date: 16/03/2010    Category: Sql Server     Points: 10

Using ROLLBACK TRANSACTION;

What is the syntax of try catch?

Author: nishithraj          Posted Date: 16/03/2010    Category: Sql Server     Points: 10

BEGIN TRY
END TRY
BEGIN CATCH

END CATCH;

What is the purpose of @@LANGUAGE statement?

Author: nishithraj          Posted Date: 16/03/2010    Category: Sql Server     Points: 10

To know the current language used.

What is the use of @@IDLE in Transact-SQL?

Author: nishithraj          Posted Date: 16/03/2010    Category: Sql Server     Points: 10

@@IDLE informs the time that SQL Server has been idle since it was last started

Through Defect Measurement what are all the factors are measured?

Author: nishithraj          Posted Date: 16/03/2010    Category: Others     Points: 10

1) Efficiency of developer
2) Efficiency of tester
3) Whether the progress is in gear?

What is V-Model ?

Author: nishithraj          Posted Date: 16/03/2010    Category: Others     Points: 10

The V-model is a software development process which can be presumed to be the extension of the waterfall model. Instead of moving down in a linear way, the process steps are bent upwards after the coding phase, to form the typical V shape. The V-Model demonstrates the relationships between each phase of the development life cycle and its associated phase of testing.

What is Dual Vee Model?

Author: nishithraj          Posted Date: 16/03/2010    Category: Others     Points: 10

The Dual Vee Model, like the V-Model is a systems development model designed to simplify the understanding of the complexity associated with developing systems. In systems engineering it is used to define a uniform procedure for product or project development.

The model addresses the necessary concurrent development of a system's architecture with the entities of that architecture and illuminates the necessary interactions and sequences recommended for orderly maturation of a system and systems of systems. This article explains the power of the Dual Vee Model when applied as a reminder model for development of complex systems.

What are the phases in the Systems Development Life Cycle?

Author: nishithraj          Posted Date: 16/03/2010    Category: Others     Points: 10

1 Initiation/planning
2 Requirements gathering and analysis
3 Design
4 Implementation
5 Maintenance
« Previous12345678910….142143Next »
 




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