Virtusa Consulting Services Interview Questions, Process, and Tips

Q1. Ddl dml dcl TCL join
Add your answer
Q2. Ddl dml dcl TCL join no multiple questions
Add your answer
Q3. No multiple questions
Add your answer

There around 6 sections 2 is coding sections

Q1. Difference b/w java and c++
Ans. 
Java is platform-independent, object-oriented, and uses automatic memory management, while C++ is platform-dependent, supports multiple paradigms, and requires manual memory management.
• Java is platform-independent, while C++ is platform-dependent.

• Java is object-oriented, while C++ supports multiple paradigms.

• Java uses automatic memory management (garbage collection), while C++ requires manual memory management.

• Java has...read more
Answered by AI
Add your answer
Q2. Real time examples of object and class
Ans. 
Objects are instances of classes in object-oriented programming. Classes define the properties and behaviors of objects.
• An example of a class is 'Car', which defines properties like color, make, and model, and behaviors like drive and stop.

• An object of the class 'Car' could be 'myCar' with properties 'red', 'Toyota', 'Camry' and behaviors 'drive()' and 'stop()'.
Answered by AI
Add your answer
Q3. What is access specifiers define access specifers
Ans. 
Access specifiers define the level of access to classes, methods, and variables in object-oriented programming.
• Access specifiers include public, private, protected, and default.

• Public access specifier allows access from any other class.

• Private access specifier restricts access to only within the same class.

• Protected access specifier allows access within the same package and subclasses.

• Default access specifier (no keywo...read more
Answered by AI
Add your answer
Q4. Difference between truncate and drop
Ans. 
Truncate removes all records from a table, while drop deletes the table itself.
• Truncate is a DDL command, while drop is a DDL command.

• Truncate is faster than drop as it does not log individual row deletions.

• Truncate can be rolled back, while drop cannot be rolled back.

• Truncate resets the identity seed of the table, while drop does not.

• Example: TRUNCATE TABLE TableName; DROP TABLE TableName;
Answered by AI
Add your answer

Q1. Introduce about yourself
Add your answer
Q2. Willing to relocate
Add your answer
Q3. Comfortable with night shights
Ans. 
Yes, I am comfortable with night shifts as I have previous experience working during those hours.
• Have previous experience working night shifts

• Understand the importance of maintaining focus and attention during non-traditional work hours

• Able to adjust sleep schedule accordingly to ensure optimal performance during night shifts
Answered by AI
Add your answer
Q4. Work with any domain
Add your answer

Q1. Basic SQL & .NET MVC
Add your answer

Q1. Advance questions on performance optimisation
Add your answer

Q1. Benefits, Salary perks
Add your answer

Q1. Technical Question on trigger scenario- count of child record to update on parent using trigger. How to bulkify a trigger.
Add your answer

Q1. If more than 50K records are fetched by the SOQL in the trigger. how to handle that.
Ans. 
To handle more than 50K records fetched by SOQL in trigger, use batch apex or pagination.
• Use batch apex to process records in smaller chunks

• Implement pagination to limit the number of records fetched at a time

• Consider using selective SOQL queries to reduce the number of records fetched

• Avoid using SOQL queries inside loops

• Use query optimizer tool to optimize SOQL queries
Answered by AI
Add your answer
Q2. How to improve test coverage of a class.
Ans. 
To improve test coverage of a class, write more test cases to cover all possible scenarios.
• Identify uncovered lines of code using a code coverage tool

• Write test cases for each uncovered line of code

• Write test cases for boundary conditions and edge cases

• Use mock objects to simulate dependencies

• Refactor code to make it more testable
Answered by AI
Add your answer
Q3. How to use current page's Id in LWC
Ans. 
To use current page Id in LWC, we can import '@salesforce/apex' and call Apex method to get the Id.
• Import '@salesforce/apex' in LWC JS file

• Create an Apex method to return current page Id

• Call the Apex method in LWC JS file using '@wire'

• Access the current page Id in LWC HTML file using '{pageId}'
Answered by AI
View 1 more amswer

Basic aptitude questions

Arrays and strings sql,python

Q1. Tell me about yourself
Add your answer
Q2. What was my role in previous organizations?
Add your answer
Q3. How did I approach one of the projects I worked in academics?
Add your answer

Q1. How do you normalize data?
Add your answer
Q2. How do you treat missing values in data?
Add your answer
Q3. How do you treat outliers in the data?
Add your answer
Q4. Difference between recall and precision?
Add your answer
Q5. Discussed about the project in detail.
Add your answer

Q1. What do you want to achieve in your life?
Add your answer
Q2. What are your strengths?
Add your answer
Q3. Why do you think you are a suitable for the role?
Add your answer
Q4. Are you willing to relocate to the job location?
Add your answer