CEI 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

Intermediate aptitude questions .
No negative marking .
Written test held at JMR infotech

Q1. Mcq and coding questions . Mostly from Java and spring . Coding question is from Array and String (Find frequency )
Add your answer

Q1. After the written test, face to face interview on technical and hr will be there .
Add your answer

It was a MCQ + Coding test

Q1. Questions on DSA
Add your answer
Q2. Questions on CS Fundamentals
Add your answer

Q1. Questions on Linux commands
Add your answer
Q2. Questions related to oops and CS is
Add your answer

It was around 2 hrs with 2 coding questions and some mcq questions on fundamentals

Q1. Print some numbers in a tree format
Ans. 
Print numbers in a tree format
• Use recursion to print numbers in a tree structure

• Start with the root node and recursively print child nodes

• Use indentation to represent levels in the tree

• Example: 1 --2 ----3 --4
Answered by AI
Add your answer
Q2. Factorial of a number, both iterative and recursive
Ans. 
Factorial of a number can be calculated using both iterative and recursive methods.
• Iterative method involves using a loop to multiply numbers from 1 to n.

• Recursive method involves calling the function with n-1 until n reaches 1.

• Example: Factorial of 5 using iterative method: 5! = 5*4*3*2*1 = 120

• Example: Factorial of 5 using recursive method: 5! = 5 * 4!

• Example: Factorial of 4 using recursive method: 4! = 4 * 3!
Answered by AI
Add your answer

Medium level questions from all sectors

Technical MCQ and easy coding questions

Q1. According to resume
Add your answer

Artificial intelligence

Q1. Family background
Add your answer

Q1. Why public static use
Ans. 
public static use for accessing methods and variables without creating an object
• Allows access to methods and variables without creating an object

• Useful for utility classes where objects are not needed

• Can be used to create global variables or constants

• Example: Math class in Java has only static methods and constants
Answered by AI
Add your answer
Q2. Why static is use.Pattern question,hshshdhdhxhxhxhxhdhhxjdjdjdjdjnjsjs
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

Medium level leetcode

Q1. Basics of linked list. How to delete without head and address of current node is given?
Add your answer
Q2. Simple join queries on 2 to 3 tables?
Ans. 
Join queries are used to combine data from multiple tables based on a related column between them.
• Use JOIN keyword to combine tables based on a common column

• Specify the columns to select from each table

• Use WHERE clause to specify the join condition
Answered by AI
Add your answer