i
GEMINI SOFTWARE SOLUTIONS
Filter interviews by
Performance tuning
Maintainace work on the db
I applied via Naukri.com and was interviewed before Oct 2023. There was 1 interview round.
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.
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
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;
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
Ds and also were asked in the rounds
Top trending discussions
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.
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
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
posted on 14 May 2022
I applied via Naukri.com and was interviewed before May 2021. There was 1 interview round.
I applied via Walk-in and was interviewed before Apr 2020. There were 5 interview rounds.
I was interviewed before Sep 2020.
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.
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...
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.
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.
I applied via Naukri.com and was interviewed in Jul 2020. There were 4 interview rounds.
I applied via Naukri.com and was interviewed before Apr 2020. There were 5 interview rounds.
based on 3 interviews
Interview experience
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