CSG International Software Development Engineer 1 Interview Questions and Answers

Finding all unique pairs of BST

Given stream of numbers , return yes/no - for a series of numbers if each number is present or not

Q1. Fully Optimized SQL Query for some scenario
Add your answer
Q2. Joins vs Subqueries
Ans. 
Joins are used to combine rows from two or more tables based on a related column, while subqueries are nested queries used to return data for the main query.
• Joins are used to retrieve data from multiple tables based on a related column.

• Subqueries are used to return data for the main query by nesting a query within another query.

• Joins are typically more efficient than subqueries for retrieving data from multiple tables.

• ...read more
Answered by AI
Add your answer

Question related to operating system and computer network

Q1. Traverse all child nodes in tree
Ans. 
Traverse all child nodes in a tree data structure
• Use depth-first or breadth-first traversal algorithms

• Recursively visit each child node starting from the root node

• Consider using a stack or queue data structure for traversal

• Example: Traverse all nodes in a binary tree
Answered by AI
Add your answer

Q1. Question related to cloud and oops
Add your answer

Q1. Question related to my background and how web site work
Add your answer

Q1. Basics of oops, .net framework and .net core
Add your answer
Q2. Sql query for student department id
Ans. 
SQL query to retrieve student department id.
• Use SELECT statement to retrieve data

• Specify the columns to be selected, including the department id column

• Specify the table where the student data is stored

• Use WHERE clause to filter the results based on student information
Answered by AI
Add your answer
Q3. Solid principles and design patterns
Add your answer

Q1. Asked to code palindrome
Add your answer
Q2. Code duplicate string from main string and get index of sub string
Ans. 
Code to find index of sub string in main string and duplicate the sub string
• Use a loop to iterate through the main string and check for the sub string

• If sub string is found, duplicate it and store the index

• Return the index of the duplicated sub string
Answered by AI
Add your answer

Q1. Manager asked me to code the count index of substring and sum of substring
Add your answer
Q2. Questions as HR informed, it was worst and all interviews were scheduled at night time.he was more technical than the second round team lead instead of asking manager round
Add your answer

It was nice, it was nice, it was nice

Q1. It was nice, it was nice, it was nice
Add your answer
Q2. It was nice it was nice it was nice
Add your answer
Q3. It was really nice
Add your answer
Q4. It was really great
Add your answer
Q5. It was really awesome
Add your answer

30min duration simple questions

Basic array 2 coding questions

Q1. Introduce yorself
Add your answer
Q2. Explain about final year project
Add your answer
Q3. Github link for project
Add your answer
Q4. What is oops in java
Add your answer
Q5. What is polymorphism explain with examples
Add your answer

In first round 4 coding question like 1 dsa 2 database and one is api and question is very simple . coding round was conducted in hackerrank

Q1. DSA QUESTION LIKE TREE AND GRAPH
Add your answer
Q2. DP AND SORTING APPROACH
Add your answer

Again same but dsa question and oops concept in deep level

Q1. Basic java fundamentals
Add your answer
Q2. Spring boot,sql
Add your answer

Q1. Some technical questions from manager
Add your answer
Q2. Some challenges or scenario based questions
Add your answer

Q1. Salary discussion mostly
Add your answer
Q2. Benifts that they offer with TR
Add your answer