Virtusa Consulting Services Interview Questions, Process, and Tips

Q1. Javscript question , let , const, var difference ?
Add your answer

Q1. Basic ios development questions
Add your answer
Q2. Core data or any other data base
Add your answer

Q1. Validation technique in MVC?
Ans. 
Validation in MVC ensures data entered by user meets specified criteria before processing.
• Validation can be done using data annotations in model classes.

• Validation can also be performed using ModelState.IsValid in controller actions.

• Client-side validation can be implemented using JavaScript libraries like jQuery Validate.
Answered by AI
Add your answer
Q2. Difference between partial and render partial in MVC?
Ans. 
Partial is used to render a specific portion of a view, while render partial is used to render a partial view within another view in MVC.
• Partial is used to render a specific portion of a view in MVC.

• Render partial is used to render a partial view within another view in MVC.

• Partial can be used to render a reusable piece of code in multiple views.

• Render partial is useful for rendering common elements like headers or foot...read more
Answered by AI
Add your answer

Program to find Power of number by passing base number and power number

Q1. Diff between abstract class and interface
Ans. 
Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.
• Abstract class can have constructor, fields, and methods, while interface cannot have any of these.

• A class can extend only one abstract class, but can implement multiple interfaces.

• Abstract classes are used to define a common behavior among subclasses, while interfaces are used to define a contract for classes...read more
Answered by AI
Add your answer
Q2. Explain about handler methods
Ans. 
Handler methods in Java are methods that are responsible for handling incoming requests and generating responses.
• Handler methods are typically defined in classes annotated with @Controller or @RestController.

• These methods are mapped to specific URLs using @RequestMapping or other mapping annotations.

• Handler methods can have parameters such as HttpServletRequest, HttpServletResponse, or model attributes.

• The return value...read more
Answered by AI
Add your answer

Q1. Java 8, exception handling for method overriding, collections basic on HashMap , hash set, blocking queue. Transient volatile
Add your answer

Q1. Tell me about the project you have worked recently?
Add your answer
Q2. Any challenges faced recently?
Add your answer
Q3. What is difference between union and union all
Ans. 
UNION combines the result sets of two or more SELECT statements, while UNION ALL does the same but includes duplicate rows.
• UNION removes duplicate rows from the result set, while UNION ALL includes all rows

• UNION is slower than UNION ALL because it has to perform a distinct operation

• UNION requires that all SELECT statements have the same number of columns with compatible data types
Answered by AI
Add your answer

Q1. How do you approach performance tuning of a stored procedure?
Ans. 
I approach performance tuning of a stored procedure by analyzing query execution plans, optimizing indexes, and rewriting inefficient code.
• Analyze query execution plans to identify bottlenecks

• Optimize indexes to improve data retrieval speed

• Rewrite inefficient code to reduce unnecessary processing

• Consider parameter sniffing and data distribution for optimal performance
Answered by AI
Add your answer
Q2. What is recursive CTE
Ans. 
A recursive CTE (Common Table Expression) is a query that references itself within the query definition.
• Allows for hierarchical data querying

• Uses a base case and recursive member in the query

• Example: querying a table with parent-child relationship using recursive CTE
Answered by AI
Add your answer

Q1. Are you flexible on timing
Add your answer