AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
SphereGen Interview Questions and Answers
SphereGen Interview Experiences
2 interviews found
Selected
I applied via Naukri.com and was interviewed in Jan 2024. There were 3 interview rounds.
Find the numeric values from given strong column. For given input find inner join, left join, right join. Dynamic SQL and temp table scenario based question.
(2 Questions)
- Q1. Write a SQL code for me to find Nth maximum salary department wise.
- Ans.
SQL code to find Nth maximum salary department wise.
Use the RANK() function to assign a rank to each salary within each department.
Filter the results to only include the rows where the rank is equal to N.
Group the results by department to get the Nth maximum salary department wise.
- Q2. What is the difference between merge ,merge join, union all in SSIS. What is recursive CTE? What is cross apply? Find me only numeric values from given strong column. What is the output for given data inne...
- Ans.
Merge is a SQL statement used to combine data from two tables, merge join is a join operation in SSIS, union all is used to combine the result sets of two or more SELECT statements. Recursive CTE is a common table expression that references itself, cross apply is used to apply a table-valued function to each row of a table.
Merge: combines data from two tables
Merge join: join operation in SSIS
Union all: combines result ...
(2 Questions)
- Q1. How many function have you used in ssas
- Ans.
I have used multiple functions in SSAS for various purposes.
Some commonly used functions in SSAS include SUM, AVG, COUNT, MIN, MAX, and DISTINCT.
Functions can be used in measures, calculated columns, and calculated tables.
Examples of functions used in SSAS include SUM([Sales Amount]), COUNT([Customer ID]), and AVG([Rating]).
- Q2. Filter, order, top count, downcpunt
Interview Preparation Tips
- SQL
- SSIS
Skills evaluated in this interview
SQL Developer Interview Questions asked at other Companies
I applied via Approached by Company
(1 Question)
- Q1. On first round basic questions related to your fields and projects
(1 Question)
- Q1. You to deep knowledge about your related field
Interview Preparation Tips
Software Developer 1 Interview Questions asked at other Companies
Jobs at SphereGen
Top trending discussions
Interview questions from similar companies
I applied via Campus Placement and was interviewed before Jun 2021. There were 2 interview rounds.
They have an Online Aptitude cum coding test which contains some 20-30 Question to be done in 3Hrs.
20 Questions of Aptitude and 10 Questions of coding(Which includes Display output and correct the program Questions)
Easy Interview lasting about 30-45 Mins
They mostly ask questions based on projects and they like to see some certifications.
DSA questions were easy to medium.
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Sep 2019. There were 5 interview rounds.
Interview Questionnaire
8 Questions
- Q1. What were you stressed last time?
- Q2. Explain C language to a non technical person?
- Ans.
C is a programming language used to create software and operating systems.
C is a low-level language that allows direct access to computer hardware.
It is used to create efficient and fast programs.
C is the foundation for many other programming languages such as C++, Java, and Python.
Examples of C programs include operating systems, device drivers, and video games.
- Q3. Why you want to join XenonStack?
- Q4. Why should we hire your?
- Q5. What are your weekness?
- Q6. Introduce yourself?
- Q7. Asked about project i have done
- Q8. Your Hobbies
- Ans.
My hobbies include hiking, photography, and cooking.
Hiking: I enjoy exploring nature trails and challenging myself physically.
Photography: I love capturing beautiful moments and landscapes through my camera lens.
Cooking: I find joy in experimenting with new recipes and creating delicious meals for my friends and family.
Interview Preparation Tips
Don't lie in any way.
Say no to things ypu don't know about.
Skills evaluated in this interview
Interview Questionnaire
3 Questions
- Q1. 1. Assignment
- Q2. 2. Bunch of python questions.
- Q3. 3. coding questions.
Interview Preparation Tips
Software Developer Interview Questions & Answers
Codingmart Technologies
Bala Kumar
posted on 7 Apr 2024
Technical mcq from basic of dsa
Question from DSA and time will given to solve it
Interview Preparation Tips
Software Developer Interview Questions & Answers
Codingmart Technologies
Anonymous
posted on 25 Jun 2024
I applied via Campus Placement and was interviewed in Dec 2023. There were 3 interview rounds.
Easy to medium level questions were asked
Questions were given asked to explain the concept
(1 Question)
- Q1. Basics of c++,java,oops
Software Developer Interview Questions & Answers
Codingmart Technologies
Anonymous
posted on 18 Jul 2024
I applied via Campus Placement and was interviewed in Jan 2024. There were 2 interview rounds.
DSA MCQ in online platform
Basic closings like lists/array/string
Software Developer Interview Questions & Answers
Codingmart Technologies
Anonymous
posted on 26 Jul 2024
I applied via Campus Placement and was interviewed in Jan 2024. There were 4 interview rounds.
Online MCQs - 15 Questions (Aps, DSA, Output Prediction)
1 Question (with 3 Enhancement)
(2 Questions)
- Q1. Delete Middle Element from a stack of Odd Length
- Ans.
Remove middle element from a stack with odd length
Find the middle index of the stack by dividing the length by 2
Remove the element at the middle index
Adjust the stack by shifting elements if necessary
- Q2. Resume Based Questions
(2 Questions)
- Q1. Self Introduction but without the details in the resume
- Q2. Asked whether ok with the bond
Skills evaluated in this interview
Software Developer Interview Questions & Answers
Codingmart Technologies
Anonymous
posted on 17 Sep 2024
Data structure and aptitude
10 mins given for prepare for the problem and after completing the problem (program ) they asked to explain and asked to upgrade the program by reduce time complexity
(2 Questions)
- Q1. Topic given and want to explain
- Q2. Reverse string without buildin funtion and for loop
- Ans.
Reverse a string without using built-in functions or for loops
Use recursion to reverse the string
Pass the substring excluding the first character to the recursive function
Base case: return the character itself if the length of the string is 1
Concatenate the last character of the string with the result of the recursive call
(2 Questions)
- Q1. Introduce your self
- Ans.
I am a passionate software developer with experience in Java, Python, and web development.
Experienced in Java and Python programming languages
Skilled in web development technologies like HTML, CSS, and JavaScript
Worked on projects involving database management with SQL
- Q2. Are you ok with agreement
- Ans.
Yes, I am okay with agreement.
I am comfortable with signing agreements related to software development projects.
I understand the importance of agreements in protecting both parties involved in a project.
I am willing to review and negotiate agreements to ensure they are fair and reasonable.
Interview Preparation Tips
SphereGen Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
SphereGen Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
|
Software Developer
12
salaries
|  ₹5.8 L/yr - ₹13.5 L/yr |
|
Senior Software Developer
7
salaries
| ₹10.2 L/yr - ₹26 L/yr |
|
DOT NET Developer
4
salaries
| ₹9 L/yr - ₹13 L/yr |
|
HR & Administration Executive
3
salaries
| ₹4 L/yr - ₹4.8 L/yr |
Northcorp Software
Apex CoVantage
Appsierra
Teleindia Networks
- Home >
- Interviews >
- SphereGen Interview Questions
