Interview Questions And Answers

Using ROWCOUNT_BIG statement.

2 billion rows.

Using ROLLBACK TRANSACTION;

BEGIN TRY
END TRY
BEGIN CATCH

END CATCH;

To know the current language used.

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

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

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.

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.

1 Initiation/planning
2 Requirements gathering and analysis
3 Design
4 Implementation
5 Maintenance