Commdel Consulting Services Senior Associate Engineer Interview Questions and Answers

Q1. Sql is the most important , Focus on Joins ,Sub query and Sql basics
Add your answer
Q2. Joining tables with different joins
Ans. 
Joining tables with different joins in SQL
• Use INNER JOIN to return rows when there is at least one match in both tables

• Use LEFT JOIN to return all rows from the left table and the matched rows from the right table

• Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table

• Use FULL JOIN to return rows when there is a match in one of the tables
Answered by AI
Add your answer

Some basic question of programming

Q1. Takes 40 to 50 minutes
Add your answer
Q2. Basic algo and html tag OOPs
Add your answer

Q1. Basically about what's on resume.
Add your answer

Q1. About the knowledge on the JD provided.
Add your answer

Simply one can get through this if have a good grip solving rs Agrawal reasoning questions.

Q1. Regarding BSP and your work related questions Also deep dive into c took place.
Add your answer

Q1. This was advance version of the second round and was given some problem to make pseudo code and then some test cases logics were asked Overall further deep dive into the first round
Add your answer

Q1. Sort of clarification I was given Nothing else kinda managerial round type
Add your answer

Q1. Oops concepts, core java
Add your answer
Q2. Java 8 stream api and lambda
Add your answer

Q1. Python and SQL related questions
Add your answer