SphereGen SQL Developer Interview Questions and Answers

The first round was DSA round and they gave 2 DSA Questions.

They just gave me an assessment with a few questions to test my subject knowledge

Q1. They asked me all the general questions and a few technical questions
Add your answer

The aptitude test evaluates problem-solving, coding skills, and logical reasoning, offering a fair challenge to showcase technical expertise.

Q1. How do you handle conflicts in a team project?
Ans. 
I address conflicts in team projects by promoting open communication, active listening, and seeking compromise.
• Encourage open communication among team members to address conflicts early on

• Practice active listening to understand all perspectives and concerns

• Seek compromise and find common ground to resolve conflicts effectively
Answered by AI
Add your answer
Q2. What is the difference between an interface and an abstract class?
Add your answer

25 questions of quants and logical and 10 questions of coding, some were debugging some were coding

Q1. Discussion about my resume projects
Add your answer
Q2. Return addition and subtraction of two numbers from the same function
Ans. 
A function that returns the addition and subtraction of two numbers.
• Create a function that takes two numbers as input parameters.

• Inside the function, calculate the sum of the two numbers and store it in a variable.

• Calculate the difference of the two numbers and store it in another variable.

• Return an array of strings containing the sum and difference.
Answered by AI
Add your answer
Q3. Print leaf nodes of binary tree
Ans. 
Print leaf nodes of binary tree
• Traverse the tree recursively

• If node is null, return

• If node is leaf node, print it

• Else, recursively traverse left and right subtrees
Answered by AI
Add your answer
Q4. What is the protocol used for communication over web pages
Ans. 
HTTP is the protocol used for communication over web pages.
• HTTP stands for Hypertext Transfer Protocol

• It is the foundation of data communication on the World Wide Web

• HTTP uses a client-server model where the web browser acts as the client and sends requests to the web server

• The web server responds with the requested data in the form of HTML, images, videos, etc.
Answered by AI
View 1 more answer

So prepare good amout of aptitude , and try to solve at least 15 Questions

It was an Online coding test 2 questions were there. difficulty (Easy and Medium).

The third round was again an coding round but it was a pen and paper test , it was in offline mode they will tell you the center after you will complete 2nd round.
In pen and paper test there are 10 coding questions and from topics array , string , recursion , Bit manipulation , BST , Linked List. so you have to solve at least 6-7 questions.

Q1. Questions on HTML, CSS
Add your answer
Q2. Permutations in string (Can you Backtracking approach). Always try to explain your approach
Ans. 
Generate all permutations of a string using a backtracking approach.
• Backtracking involves exploring all possible configurations and abandoning those that don't meet criteria.

• Start with an empty string and build permutations by adding one character at a time.

• Use a boolean array to track which characters are already included in the current permutation.

• Example: For the string 'abc', the permutations are 'abc', 'acb', 'bac...read more
Answered by AI
Add your answer
Q3. Explain your Project?
Ans. 
Developed a web application for managing inventory and sales for a retail store.
• Used HTML, CSS, and JavaScript for front-end development.

• Implemented backend functionality using Node.js and MongoDB for database management.

• Incorporated user authentication and authorization features for secure access.

• Integrated payment gateway for online transactions.

• Utilized responsive design for mobile compatibility.
Answered by AI
Add your answer

45 min apps and technical question

45 min coding round you can refer net for first 15 min

Q1. 1st round is of Tech MCQ in all domains, its a bit moderate
Add your answer
Q2. A Hard Leetcode Problem you can solve with reference
Add your answer
Q3. Tech Hr with mainly your resume and DSA
Add your answer
Q4. General HR and Culture fit round
Add your answer

The aptitude test mainly covered logical reasoning, quantitative aptitude, and basic programming concepts. Questions were of moderate difficulty, with some time-based problem-solving challenges. Practicing common aptitude topics like puzzles, numerical ability, and coding fundamentals can help in preparation.

The group discussion round focused on general topics related to technology, current affairs, and workplace scenarios. The evaluators were looking for clarity of thought, communication skills, and how well candidates could present their points while engaging with others. Staying confident and actively participating helped in getting selected.