Add office photos
Filter interviews by
SphereGen SQL Developer Interview Questions and Answers
SphereGen SQL Developer Interview Experiences
1 interview 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
Interview questions from similar companies
(2 Questions)
- Q1. How do you reverse a list in Python?
- Ans.
To reverse a list in Python, you can use the built-in reverse() method or slicing technique.
Use the reverse() method to reverse the list in place: list.reverse()
Use slicing to create a new reversed list: reversed_list = list[::-1]
- Q2. Use the reverse method()
- Ans.
The reverse method() is used to reverse the order of elements in an array.
Use the reverse() method on an array to reverse the order of its elements.
Example: $arr = [1, 2, 3]; reverse($arr); // Output: [3, 2, 1]
Interview Preparation Tips
Front end Developer Interview Questions & Answers
CodeCraft Technologies
Anonymous
posted on 14 Sep 2024
Coder byte round
2 questions were given in coder byte platform to solve
(2 Questions)
- Q1. Polyfills were asked?
- Q2. Closures were asked?
Interview Preparation Tips
Junior Software Developer Interview Questions & Answers
MulticoreWare
Anonymous
posted on 18 Jul 2024
I applied via Campus Placement and was interviewed in Jun 2024. There were 2 interview rounds.
Hard questions,its difficult to think and solve,
Very hard logical questions,which made hard to think logically
Interview Preparation Tips
Software Developer Intern Interview Questions & Answers
Codingmart Technologies
SWATHI M
posted on 31 May 2024
Dsa predict the output
One medium problem. Based on that the students are selected. And modifications in code has been asked
(1 Question)
- Q1. Coding related questions
I applied via Naukri.com and was interviewed in Nov 2023. There was 1 interview round.
Very simple questions from the javascript
Interview Preparation Tips
I applied via Walk-in and was interviewed in Jan 2023. There were 3 interview rounds.
(2 Questions)
- Q1. Javascript framework names?
- Ans.
Popular JavaScript frameworks used for backend development.
Express.js
Node.js
Koa.js
Hapi.js
Sails.js
- Q2. Django knowledge with UI libraries
(4 Questions)
- Q1. Tell me about yourself
- Q2. Why would you like to join
- Q3. How long would you work with us
- Q4. How was your day today
Interview Preparation Tips
Skills evaluated in this interview
(2 Questions)
- Q1. What is the difference between GET AND POST methods in HTTPS?
- Ans.
GET method is used to request data from a server, while POST method is used to submit data to a server in HTTPS.
GET requests data from a specified resource, while POST submits data to be processed to a specified resource.
GET requests can be cached and remain in the browser history, while POST requests are not cached and do not remain in the browser history.
GET requests have length restrictions on the amount of data tha...
- Q2. GET is Retrieves and POST is Sends data.
- Ans.
GET is used to retrieve data from a server, while POST is used to send data to a server.
GET requests are used to retrieve data from a specified resource. For example, fetching a list of products from an online store.
POST requests are used to submit data to be processed by a server. For example, submitting a form with user information to create a new account.
GET requests are idempotent, meaning they can be repeated mult...
Interview Preparation Tips
Selection sort,oops concepts,python datatype interview que
I applied via Approached by Company and was interviewed before Jun 2021. There were 3 interview rounds.
(2 Questions)
- Q1. Display inline block
- Q2. Rem em used for, position,
- Ans.
rem em is used for defining font size relative to the root element. It helps in creating responsive designs.
rem em is used to define font size relative to the root element
It helps in creating responsive designs as the font size adjusts according to the screen size
For example, if the root element font size is 16px, 1rem is equal to 16px
rem em is also used for defining position and spacing in CSS
Home page design with responsive
Interview Preparation Tips
- Selector
- CSS3
- Scss
- HTML
- W3C Standards
SphereGen Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Front end Developer Interview Questions
- Web Developer Interview Questions
- Backend Developer Interview Questions
- Software Developer Intern Interview Questions
- Junior Software Developer Interview Questions
- Full Stack Software Developer Interview Questions
- PHP Developer Interview Questions
- UI Developer Interview Questions
- Show more
People are getting interviews through
Interview Questions from Similar Companies
|
Software Developer
9
salaries
|  ₹5.8 L/yr - ₹10 L/yr |
|
Senior Software Developer
5
salaries
| ₹9.4 L/yr - ₹13.8 L/yr |
|
DOT NET Developer
4
salaries
| ₹3.8 L/yr - ₹11 L/yr |
|
HR & Administration Executive
3
salaries
| ₹4 L/yr - ₹4.8 L/yr |
Northcorp Software
XenonStack
Zebra Technologies
Navigators Software
Calculate your in-hand salary
- Home >
- Interviews >
- SphereGen Interview Questions >
- SphereGen SQL Developer Interview Questions
