Virtusa Consulting Services Associate Consultant Interview Questions, Process, and Tips

Q1. Questions on DS and Algo
Add your answer
Q2. Questions on the current job
Add your answer

Basic program related to strings and another for Curl request

Q1. Coding questions of programming language and SQL
Add your answer
Q2. Differentiate between Sessions and Cookies
Ans. 
Sessions store data on the server side while cookies store data on the client side.
• Sessions store data on the server side, while cookies store data on the client side

• Sessions are more secure as the data is stored on the server and not visible to the client

• Cookies are stored on the client's browser and can be accessed and modified by the client

• Sessions are typically used to store sensitive information like user credenti...read more
Answered by AI
Add your answer
Q3. When to use GET, POST, PUT, DELETE (Rest methods)
Ans. 
GET for retrieving data, POST for creating data, PUT for updating data, DELETE for deleting data
• GET: Used to retrieve data from a server

• POST: Used to create new data on a server

• PUT: Used to update existing data on a server

• DELETE: Used to delete data on a server

• Example: GET request to fetch user information, POST request to create a new user, PUT request to update user details, DELETE request to delete a user
Answered by AI
Add your answer
Q4. Write SQL query to join 2 tables (inner join)
Ans. 
SQL query to perform inner join on 2 tables
• Use the JOIN keyword to combine rows from two tables based on a related column

• Specify the columns to select from each table

• Use the ON keyword to specify the join condition
Answered by AI
Add your answer
Q5. Write SQL query to get second highest salary
Ans. 
SQL query to retrieve the second highest salary from a table
• Use the ORDER BY clause to sort the salaries in descending order

• Use the LIMIT clause to retrieve the second row
Answered by AI
Add your answer

Q1. For Java Backend Role- Java 11 features, Collections, DSA, SQL
Add your answer

Q1. View, Cluster vs Non cluster Index, Oops concepts, SQL basic Query , Session Default Timeout time, State Management Technique, Query Optimization
Add your answer

Q1. Same as above but in advance
Add your answer