Add office photos
i
GEMINI SOFTWARE SOLUTIONS
Compare
Filter interviews by
GEMINI SOFTWARE SOLUTIONS SQL Developer Interview Questions, Process, and Tips
GEMINI SOFTWARE SOLUTIONS SQL Developer Interview Experiences
1 interview found
Selected
I applied via Naukri.com and was interviewed before Oct 2023. There was 1 interview round.
(5 Questions)
- Q1. What is magic table?
- Ans.
Magic table is a virtual table in SQL Server that stores the data affected by DML statements.
Magic table is used in triggers to access the data before and after the triggering DML operation.
In SQL Server, INSERTED and DELETED are examples of magic tables used in triggers.
INSERTED table stores the new data for INSERT and UPDATE operations, while DELETED table stores the old data for UPDATE and DELETE operations.
- Q2. Query tuning in sql?
- Ans.
Query tuning in SQL involves optimizing SQL queries to improve performance.
Identify slow queries using tools like query execution plans
Optimize queries by using indexes, avoiding unnecessary joins, and rewriting complex queries
Consider factors like data volume, indexing, and server resources
Test query performance after tuning to ensure improvements
- Q3. Isnull() in sql?
- Ans.
ISNULL() is a SQL function used to replace NULL values with a specified value.
ISNULL() function is used to replace NULL values with a specified default value.
Syntax: ISNULL(expression, replacement_value)
Example: SELECT ISNULL(column_name, 'N/A') FROM table_name;
- Q4. Project experience?
- Q5. Query writing with joins
- Ans.
Query writing with joins involves combining data from multiple tables based on a common column.
Use JOIN keyword to combine tables based on a common column
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Specify the columns to select from each table and the join condition in the query
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Company Website and was interviewed in Nov 2024. There was 1 interview round.
(1 Question)
- Q1. What is joins and types?
- Ans.
Joins are used to combine rows from two or more tables based on a related column between them.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN returns rows when there is at least one match in both tables.
LEFT JOIN returns all rows from the left table and the matched rows from the right table.
RIGHT JOIN returns all rows from the right table and the matched rows from the left table.
FULL ...
I applied via Campus Placement and was interviewed in Jun 2024. There were 3 interview rounds.
All apptitude and english communication
10 members per gd and 10 minutes provided
(2 Questions)
- Q1. Types of sql commands
- Q2. Explain about projects
Interview Preparation Tips
Android App Developer Interview Questions & Answers
Moveinsync Technology Solutions
Anonymous
posted on 1 Apr 2024
I applied via campus placement at Lovely Professional University (LPU) and was interviewed in Mar 2024. There were 2 interview rounds.
Create a movie app which fetches data from an API
(4 Questions)
- Q1. General questions from Android development.
- Q2. DSA round + project discussion
- Q3. Stock span problem (leetcode)
- Ans.
Stock span problem is a financial problem where we have a series of n daily price quotes for a stock and we need to calculate the span of stock's price for all n days.
Use a stack to keep track of the previous days' prices and their spans.
For each day, pop the stack until a price greater than the current day's price is found, then calculate the span.
Push the current day's price and span onto the stack.
- Q4. Search in a list of strings
- Ans.
Use a loop to search for a specific string in an array of strings.
Iterate through each string in the array
Use a conditional statement to check if the current string matches the search string
Return the index of the matching string or -1 if not found
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Approached by Company and was interviewed in Jul 2024. There was 1 interview round.
(2 Questions)
- Q1. Typewriting knowledge
- Q2. Laptop having or not
Interview Preparation Tips
- Typescript
Front end Developer Interview Questions & Answers
Simplify3x Software
Anonymous
posted on 23 Nov 2024
45min -> react and js coding
Front end Developer Interview Questions & Answers
Pratiti Technologies
Sagar Javir
posted on 21 Sep 2024
I applied via Job Portal and was interviewed in Mar 2024. There were 3 interview rounds.
They discuss the coding capabilities, and personal things discussion so company never face any loss.
Coding related output based questions and answers.
They discuss codding based questions and too much personal things, they project manager will visite to our basic things like house, family, Current financial condition so on...
Interview Preparation Tips
Selected
I applied via LinkedIn and was interviewed in Feb 2024. There was 1 interview round.
(1 Question)
- Q1. 1. what is react 2.create a tab strcture like when u click add css and open that tab
- Ans.
React is a JavaScript library for building user interfaces.
React is a popular JavaScript library for building user interfaces.
To create a tab structure in React, you can use components like Tabs and TabPanels.
When a tab is clicked, you can use state to show or hide the content of that tab.
Interview Preparation Tips
Skills evaluated in this interview
Front end Developer Interview Questions & Answers
Surya Software Systems
Anonymous
posted on 26 Sep 2024
There was aptitude and coding question essy to medium
There was some aptitude question and coding question easy to medium
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
GEMINI SOFTWARE SOLUTIONS 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
GEMINI SOFTWARE SOLUTIONS SQL Developer Interview Process
based on 1 interview
Interview experience
SQL Developer Interview Questions from Similar Companies
|
Senior Software Engineer
16
salaries
|  ₹5.3 L/yr - ₹15.5 L/yr |
|
Service Delivery Executive
10
salaries
| ₹2.4 L/yr - ₹3.3 L/yr |
|
Consultant
10
salaries
| ₹2 L/yr - ₹3.4 L/yr |
|
Software Engineer
8
salaries
| ₹3 L/yr - ₹4.5 L/yr |
|
Service Delivery Engineer
6
salaries
| ₹2.5 L/yr - ₹6.3 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- GEMINI SOFTWARE SOLUTIONS Interview Questions >
- GEMINI SOFTWARE SOLUTIONS SQL Developer Interview Questions
