AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
GEMINI SOFTWARE SOLUTIONS
Compare
Filter interviews by
GEMINI SOFTWARE SOLUTIONS Interview Questions, Process, and Tips
Top GEMINI SOFTWARE SOLUTIONS Interview Questions and Answers
- Q1. What is magic table?asked in SQL Developer interview
- Q2. Isnull() in sql?asked in SQL Developer interview
- Q3. Query writing with joinsasked in SQL Developer interview
GEMINI SOFTWARE SOLUTIONS Interview Experiences
3 interviews found
Priviya Paulraj
Performance tuning
Maintainace work on the db
Senior SQL Developer Interview Questions asked at other Companies
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
SQL Developer Interview Questions asked at other Companies
Ds and also were asked in the rounds
Software Engineer Interview Questions asked at other Companies
Jobs at GEMINI SOFTWARE SOLUTIONS
Top trending discussions
Interview questions from similar companies
Selected
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
(1 Question)
- Q1. Hr ask about basic introduction
Selected
I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.
(2 Questions)
- Q1. Why did you selected this job
- Ans.
I selected this job because of my passion for analyzing data and using insights to drive decision-making.
Passion for data analysis
Opportunity to use insights for decision-making
Interest in working with data-driven technologies
- Q2. Why should I select you
- Ans.
I have a strong background in data analysis, excellent problem-solving skills, and a proven track record of delivering actionable insights.
I have a degree in data science and have completed multiple data analysis projects during my studies.
I am proficient in various data analysis tools such as Python, R, and SQL.
I have experience in interpreting complex data sets and presenting findings to stakeholders in a clear and c
Interview Preparation Tips
Senior Software Engineer Interview Questions & Answers
Tech Mahindra
Anonymous
posted on 14 May 2022
I applied via Naukri.com and was interviewed before May 2021. There was 1 interview round.
(1 Question)
- Q1. Discuss 4 case study related to supply chain management.
Interview Preparation Tips
- Supply Chain Management
I applied via Walk-in and was interviewed before Apr 2020. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. What is Excel what is vlookup what is your strength and weakness
Interview Preparation Tips
I was interviewed before Sep 2020.
(1 Question)
Round duration - 140 minutes
Round difficulty - Medium
Test timing was at 2:00 pm , it was conducted in a college and the environment was good for the test. Camera was a primary part of test, so no suspicious activity.
- Q1.
Sum of Two Numbers Represented as Arrays
Given two numbers in the form of two arrays where each element of the array represents a digit, calculate the sum of these two numbers and return this sum as an ar...
- Ans.
Given two numbers represented as arrays, calculate their sum and return the result as an array.
Iterate through the arrays from right to left, adding digits and carrying over if necessary
Handle cases where one array is longer than the other by considering the remaining digits
Ensure the final sum array does not have any leading zeros
Round duration - 20 minutes
Round difficulty - Easy
The round was conducted at around 12 p.m. I was called at the college location and then it was conducted. The interviewer was quite polite and frank.
Round duration - 8 minutes
Round difficulty - Easy
This round was conducted right after finishing and clearing the technical round at the same place and on the same day.
Interview Preparation Tips
Tip 1 : Practice atleast 2-3 Coding problems daily so your logic building becomes stronger.
Tip 2 : Exercise problems based on OOPS concepts and others too.
Tip 3 : If you can have your own project built, then it's the major point and will act as a plus point.
Tip 1 : Your resume should be in standard form, short and simple will be more effective.
Tip 2 : Whatever you have learned, you need to mention it in your resume as that will be your primary source of selection and having project on your resume is important.
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Jul 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. SOLID principals, oops, c# basics, SQL server, azure, design pattern
Interview Preparation Tips
I applied via Naukri.com and was interviewed before Apr 2020. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. Basic questions only ... regarding job and experience
Interview Preparation Tips
GEMINI SOFTWARE SOLUTIONS Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Associate Interview Questions
- Analyst Interview Questions
- Software Engineer Interview Questions
- Software Developer Interview Questions
- Intern Interview Questions
- Consultant Interview Questions
- Associate Software Engineer Interview Questions
- Graduate Engineer Trainee (Get) Interview Questions
- Show more
GEMINI SOFTWARE SOLUTIONS Interview Process
based on 3 interviews
Interview experience
Interview Questions from Similar Companies
GEMINI SOFTWARE SOLUTIONS Reviews and Ratings
based on 28 reviews
Rating in categories
|
Senior Software Engineer
16
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Software Engineer
10
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Service Delivery Executive
10
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Consultant
10
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Service Delivery Engineer
6
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- GEMINI SOFTWARE SOLUTIONS Interview Questions
