Argusoft Software Developer Interview Questions and Answers

Q1. Regrading Self join query
Ans. 
A self join query is used to join a table to itself in a SQL query.
• Self join is used when a table needs to be joined with itself to compare rows within the same table.

• It requires aliasing the table with different names to distinguish between the two instances of the same table.

• Commonly used in hierarchical data structures or when comparing related rows in a table.
Answered by AI
Add your answer
Q2. Group by query per catagory
Ans. 
Group by query is used to group data based on a specific category.
• Use the GROUP BY clause in SQL to group data based on a specific column

• Aggregate functions like COUNT, SUM, AVG can be used with GROUP BY to perform calculations on grouped data

• Example: SELECT category, COUNT(*) FROM products GROUP BY category
Answered by AI
Add your answer

Aptitude,English,data structures,os,java and c

Written coding test,basic and intermidiate coding questions

Q1. About sql baisc queries and questions on code written in 2nd round
Add your answer

Q1. When did you become serious in life
Add your answer

Q1. Java related question
Add your answer
Q2. Web services related question
Add your answer

Q1. Project related question
Add your answer

Good and easy most of the question are reapeted

Arrays, string, constructors in basic to medium level

Q1. Questions based on the resume in technical way
Add your answer
Q2. Oops concept dbms string data structures
Add your answer

Q1. General HR questions in easy level
Add your answer

It placed in hackerRank.question difficulty level was medium.

Q1. The difficulty depends upon who is taking your interview. But mostly asked questions were related to string and hashmap.
Add your answer

Q1. It was more like a little bit technical and hr round. Mostly talk about personal profile like education,family background, hobbies and etc.
Add your answer

English test written english vocabulary test

Time duration profit loss average share statistics