Vitrana Interview Questions and Answers for Freshers

I am a recent computer science graduate with experience in software development and a passion for learning new technologies.

• Graduated with a degree in computer science

• Experience in software development

• Passionate about learning new technologies

The company is a software development firm.

• The company specializes in software development.

• It has a team of experienced software engineers.

• The company has worked on various projects for clients in different industries.

• It is known for delivering high-quality software solutions.

• The company values innovation and creativity in its work.

6 Sigma is a data-driven methodology for improving business processes and reducing defects.

• It aims to achieve a level of quality where the probability of a defect is 3.4 parts per million or less.

• It involves five phases: Define, Measure, Analyze, Improve, and Control (DMAIC).

• It is widely used in industries such as manufacturing, healthcare, and finance.

• It emphasizes on statistical analysis and measurement to identify a...read more

Generic collections are type-safe and can store any type of data. Non-generic collections can only store objects of type 'object'.

• Generic collections are preferred as they provide compile-time type safety.

• Non-generic collections are slower and can cause runtime errors if the wrong type is added.

• Examples of generic collections include List, Dictionary, and Queue.

• Examples of non-generic collections include

Triggers are database objects that automatically execute in response to certain events.

• Triggers can be used to enforce business rules or perform complex calculations.

• Types of triggers include DML triggers, DDL triggers, and logon triggers.

• DML triggers fire in response to data manipulation language (DML) events, such as INSERT, UPDATE, or DELETE statements.

• DDL triggers fire in response to data definition language (DDL) ...read more

Managed code is executed by the CLR while unmanaged code is executed by the operating system.

• Managed code is written in languages like C#, VB.NET, etc. and is compiled into Intermediate Language (IL) code.

• Unmanaged code is written in languages like C, C++, etc. and is compiled into machine code.

• Managed code is executed by the Common Language Runtime (CLR) while unmanaged code is executed by the operating system.

• Managed...read more

In, out and ref are parameter modifiers in C# used to pass arguments to a method.

• In parameters are read-only and used to pass values to a method.

• Out parameters are write-only and used to return values from a method.

• Ref parameters are read-write and used to pass values to and from a method.

• In parameters are passed by value, out and ref parameters are passed by reference.

• In parameters are optional, out and ref parameters

Difference between viewdata, viewbag and tempdata

• ViewData is used to pass data from controller to view

• ViewBag is a dynamic object used to pass data from controller to view

• TempData is used to pass data between controller actions or redirects

Ways to improve performance of stored procedures

• Use SET NOCOUNT ON to reduce network traffic

• Avoid using SELECT *

• Use table variables instead of temporary tables

• Avoid using cursors

• Use appropriate indexes

• Avoid using scalar functions

• Minimize the use of triggers

• Use stored procedures instead of ad hoc queries