Virtusa Consulting Services Interview Questions, Process, and Tips

Two code and multiple choice questions

Q1. It was around 45 minutes
Add your answer
Q2. Core java related questions
Add your answer

Q1. Only salary discussion
Add your answer

Q1. How we can achieve load balancing in spring bot
Ans. 
Load balancing in Spring Boot can be achieved using various techniques such as server-side load balancing, client-side load balancing, and using a load balancer.
• Server-side load balancing can be achieved by using technologies like Ribbon or Eureka in Spring Cloud.

• Client-side load balancing can be implemented by using technologies like Feign or RestTemplate in Spring Cloud.

• Using a load balancer like Nginx or Apache in f...read more
Answered by AI
Add your answer
Q2. Write SQL queries with conditional operator
Ans. 
SQL queries with conditional operator
• Use CASE statement for conditional logic in SQL queries

• Syntax: SELECT column_name, CASE WHEN condition THEN value1 ELSE value2 END AS new_column_name FROM table_name

• Example: SELECT employee_name, CASE WHEN salary > 50000 THEN 'High' ELSE 'Low' END AS salary_category FROM employees
Answered by AI
Add your answer

Q1. What is OOps concept
Ans. 
Object-oriented programming paradigm focusing on objects and classes for code organization and reusability.
• Encapsulation: Bundling data and methods that operate on the data into a single unit (object)

• Inheritance: Ability for a class to inherit properties and behavior from another class

• Polymorphism: Ability for objects to be treated as instances of their parent class or their own class

• Abstraction: Hiding complex impleme...read more
Answered by AI
Add your answer
Q2. What is java 8
Ans. 
Java 8 is a major release of the Java programming language with new features like lambda expressions, streams, and functional interfaces.
• Introduced lambda expressions for functional programming

• Added streams API for processing collections

• Included default methods in interfaces for backward compatibility

• Introduced new Date and Time API (java.time package)
Answered by AI
Add your answer

Q1. Asked about general questions
Add your answer

2-D matrix based questions

Q1. Abstract classes and interfaces
Add your answer
Q2. Multithreading, java 8, collections framework
Add your answer

Q1. Basic behavioral questions were asked
Add your answer
Q2. Discussion around my job role
Add your answer

Q1. Js basics question like hoisting, promise, call back.
Add your answer
Q2. Reacts basics like dom, hooks, class components life cycle.
Add your answer

Coding questions, counter app using react redux, array destructure and few js questions.

Q1. How to use Reference cursor in procedure
Ans. 
Reference cursor in procedure is used to return result sets from a stored procedure.
• Declare a cursor variable in the procedure using TYPE keyword

• Open the cursor variable using OPEN keyword

• Fetch data from the cursor using FETCH keyword

• Close the cursor using CLOSE keyword after fetching all data
Answered by AI
Add your answer
Q2. Use of lead ,lag functions
Ans. 
Lead and lag functions are used to access data from a subsequent or previous row in a result set.
• Lead function is used to access data from the next row in the result set.

• Lag function is used to access data from the previous row in the result set.

• Both functions can be used to compare values between rows or calculate differences.
Answered by AI
Add your answer
Q3. Can you update in function
Ans. 
Yes, you can update in a function in Oracle SQL and PLSQL.
• You can use the UPDATE statement within a PLSQL function to update data in a table.

• Make sure to commit the changes using COMMIT statement.

• Example: CREATE OR REPLACE FUNCTION update_employee_salary(emp_id IN NUMBER, new_salary IN NUMBER) RETURN NUMBER IS BEGIN UPDATE employees SET salary = new_salary WHERE employee_id = emp_id; COMMIT; RETURN 1; END;
Answered by AI
Add your answer
Q4. Can you commit in trigger
Ans. 
No, you cannot commit in a trigger as it can cause mutating table errors.
• Triggers cannot contain COMMIT or ROLLBACK statements.

• Committing in a trigger can lead to mutating table errors.

• Instead, use triggers for data validation, not for committing transactions.
Answered by AI
Add your answer
Q5. What is autonomous transaction
Ans. 
Autonomous transaction is a separate transaction that is independent of the main transaction.
• Autonomous transactions are used to perform certain tasks independently of the main transaction.

• They are useful for logging, auditing, or error handling purposes.

• Autonomous transactions are started with the PRAGMA AUTONOMOUS_TRANSACTION statement.

• Changes made in an autonomous transaction are not visible to the main transaction ...read more
Answered by AI
Add your answer