Intellect Design Arena Associate Consultant Interview Questions and Answers

Game based Aptitude test

Multiple choice questions on OPPS and pseudo codes with 2 questions on java and 2 on sql

Q1. Java collections
Add your answer
Q2. Exception Handling
Add your answer
Q3. Some tricky programs output
Add your answer

Q1. Personal Inquiry
Add your answer
Q2. Location confirmation
Add your answer

Q1. Questions on stream api
Add your answer
Q2. Collection related questions
Add your answer

Q1. Collection related questions
Add your answer
Q2. Mysql questions
Add your answer

Q1. Family background
Add your answer
Q2. Salary negotiations
Add your answer

Easy to medium not much hard

Q1. Normal c++ qustion
Add your answer

Basic coding questions

Given a topic and asked to speak about it. half members are supporting the statement, half are against the statement

Q1. Questions based on resume
Add your answer
Q2. Linked list code
Add your answer
Q3. Sql query for salary of the employee
Ans. 
Use SQL query to retrieve the salary of an employee.
• Use SELECT statement to retrieve the salary column from the employee table.

• Specify the employee's ID or name in the WHERE clause to filter the results.

• Consider joining the employee table with other tables if necessary.

• Use appropriate functions like SUM, AVG, MAX, MIN if needed.

• Example: SELECT salary FROM employee WHERE employee_id = 123;
Answered by AI
Add your answer

Q1. Where do u see your self in 5 years
Add your answer
Q2. Do you think you are a good fit
Add your answer

Q1. One coding question
Add your answer

Q1. Question about spring boot and spring data
Add your answer

Basic aptitude available in YouTube and Google

Q1. Basics and methodologies of software testing
Add your answer