Search

Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
  • Community
+ Contribute
notification
notification
Login
Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by GEMINI SOFTWARE SOLUTIONS Team. If you also belong to the team, you can get access from here

GEMINI SOFTWARE SOLUTIONS Verified Tick

Compare button icon Compare button icon Compare
4.2

based on 28 Reviews

Filter interviews by

GEMINI SOFTWARE SOLUTIONS SQL Developer Interview Questions, Process, and Tips

Updated 16 Oct 2024

GEMINI SOFTWARE SOLUTIONS SQL Developer Interview Experiences

1 interview found

SQL Developer Interview Questions & Answers

user image Priviya Paulraj

posted on 16 Oct 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected

I applied via Naukri.com and was interviewed before Oct 2023. There was 1 interview round.

Round 1 - Technical 

(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.

    • Answered by AI
    Add your answer
  • 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

    • Answered by AI
    Add your answer
  • 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;

    • Answered by AI
    Add your answer
  • Q4. Project experience?
    • Add your answer
  • 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

    • Answered by AI
    Add your answer

Skills evaluated in this interview

Top trending discussions

View All
Salary Discussions, Hike & Promotions
1w
beautifulsunrise
Verified Icon
·
works at
Info Edge
🌟 Expected Salary vs. Market Value for Gen Z in India 🌟
As Gen Z steps into the workforce, there's a noticeable gap between their salary expectations and the current market value. According to recent surveys, Gen Z believes they need an average salary of ₹14 lakhs to feel financially healthy. However, the reality is quite different, with the average Gen Z worker earning around ₹2-7 Lakhs annually. This disparity highlights the challenges and aspirations of the youngest generation in the workforce. While their expectations may seem high, it's essential to understand the factors driving these numbers, such as rising living costs, student debt, and the desire for financial security. Employers need to bridge this gap by offering competitive salaries, growth opportunities, and a supportive work environment. On the other hand, Gen Z should focus on building skills, gaining experience, and understanding market trends to align their expectations with reality. Let's work together to create a balanced and thriving workforce for the future! 💼🌍
Got a question about GEMINI SOFTWARE SOLUTIONS?
Ask anonymously on communities.

Interview questions from similar companies

Software Developer Interview Questions & Answers

Codingmart Technologies user image Bala Kumar

posted on 7 Apr 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Technical mcq from basic of dsa

Round 2 - Coding Test 

Question from DSA and time will given to solve it

Interview Preparation Tips

Interview preparation tips for other job seekers - Technical HR and the next is general HR

Software Developer Interview Questions & Answers

Codingmart Technologies user image Anonymous

posted on 25 Jun 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Campus Placement and was interviewed in Dec 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Easy to medium level questions were asked

Round 2 - Coding Test 

Questions were given asked to explain the concept

Round 3 - Technical 

(1 Question)

  • Q1. Basics of c++,java,oops
    • Add your answer

Software Developer Interview Questions & Answers

Codingmart Technologies user image Anonymous

posted on 18 Jul 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Jan 2024. There were 2 interview rounds.

Round 1 - Assignment 

DSA MCQ in online platform

Round 2 - Coding Test 

Basic closings like lists/array/string

Software Developer Interview Questions & Answers

Codingmart Technologies user image Anonymous

posted on 26 Jul 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Jan 2024. There were 4 interview rounds.

Round 1 - Aptitude Test 

Online MCQs - 15 Questions (Aps, DSA, Output Prediction)

Round 2 - Coding Test 

1 Question (with 3 Enhancement)

Round 3 - Technical 

(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

    • Answered by AI
    Add your answer
  • Q2. Resume Based Questions
    • Add your answer
Round 4 - HR 

(2 Questions)

  • Q1. Self Introduction but without the details in the resume
    • Add your answer
  • Q2. Asked whether ok with the bond
    • Add your answer

Skills evaluated in this interview

Software Developer Interview Questions & Answers

Codingmart Technologies user image Anonymous

posted on 17 Sep 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Data structure and aptitude

Round 2 - Coding Test 

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

Round 3 - Technical 

(2 Questions)

  • Q1. Topic given and want to explain
    • Add your answer
  • 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

    • Answered by AI
    Add your answer
Round 4 - HR 

(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

    • Answered by AI
    Add your answer
  • 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.

    • Answered by AI
    Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - be confidence

Software Developer Interview Questions & Answers

Surya Software Systems user image Anonymous

posted on 20 May 2023

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Nov 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Coding Test 

Six coding questions to be solved within an hour. The coding questions were standard aptitude based and did not include any complex topics like Dynamic Programming or trees in my case.

Round 3 - One-on-one 

(1 Question)

  • Q1. I had to solve a problem. Given an expression involving operators and operands with parentheses, convert it to postfix expression. I used the stack data structure.
    • Add your answer
Round 4 - One-on-one 

(1 Question)

  • Q1. A puzzle question
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Think that it can be done, and lastly with the support of interviewer, it can be done. All the best

Software Developer Interview Questions & Answers

Surya Software Systems user image Anonymous

posted on 29 Apr 2024

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Apr 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Online coding test having basic problems and some aptitude problem.

Round 2 - One-on-one 

(3 Questions)

  • Q1. Interviewer will ask opps and 2 basic coding problem 2 aptitude problem if you mention any technology in resume then ask about technology and projects
    • Add your answer
  • Q2. What is opps ?
  • Ans. 

    OOPs stands for Object-Oriented Programming, a programming paradigm based on the concept of objects.

    • OOPs focuses on creating objects that contain both data and methods to manipulate that data.

    • Encapsulation, inheritance, polymorphism, and abstraction are key principles of OOPs.

    • Examples of OOPs languages include Java, C++, and Python.

    • Answered by AI
    Add your answer
  • Q3. What is singleton class ?
  • Ans. 

    A singleton class is a class that can only have one instance created and provides a global point of access to that instance.

    • Singleton classes are often used for logging, caching, database connections, and thread pools.

    • They typically have a private constructor to prevent instantiation from other classes.

    • They provide a static method to access the single instance, which is created if it doesn't exist yet.

    • Answered by AI
    Add your answer

Interview Preparation Tips

Topics to prepare for Surya Software Systems Software Developer interview:
  • Opps
  • DSA
Interview preparation tips for other job seekers - Focus on learning

Skills evaluated in this interview

Software Developer Interview Questions & Answers

Surya Software Systems user image Anonymous

posted on 22 Jul 2023

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed in Jun 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Aptitude Test 

It has include logical ,reasoning question. Aptitude questions are include mcq type question.

Round 3 - Group Discussion 

Firstly introduce yourself then HR take the one subject then selected candidate discuss on that subject. Subject related talking positive and negative point. Then who candidate speak better these are select in next round.

Interview Preparation Tips

Topics to prepare for Surya Software Systems Software Developer interview:
  • Basic
Interview preparation tips for other job seekers - A job seekers should collect information about the company beforehand. Then do apply these job.

Software Developer Interview Questions & Answers

Sciative Solutions user image 20ECE1008 Anjali Deshpande

posted on 16 Oct 2023

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

2 hrs Python and aptitude

Round 3 - Technical 

(1 Question)

  • Q1. DSA questions with optimized solutions
    • Add your answer
More about working at GEMINI SOFTWARE SOLUTIONS

GEMINI SOFTWARE SOLUTIONS Interview FAQs

How many rounds are there in GEMINI SOFTWARE SOLUTIONS SQL Developer interview?
GEMINI SOFTWARE SOLUTIONS interview process usually has 1 rounds. The most common rounds in the GEMINI SOFTWARE SOLUTIONS interview process are Technical.
How to prepare for GEMINI SOFTWARE SOLUTIONS SQL Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at GEMINI SOFTWARE SOLUTIONS. The most common topics and skills that interviewers at GEMINI SOFTWARE SOLUTIONS expect are SQL Development, C#, SQL Queries, SSIS and Stored Procedures.
What are the top questions asked in GEMINI SOFTWARE SOLUTIONS SQL Developer interview?

Some of the top questions asked at the GEMINI SOFTWARE SOLUTIONS SQL Developer interview -

  1. What is magic tab...read more
  2. Isnull() in s...read more
  3. Query writing with jo...read more

Tell us how to improve this page.

Interview Questions for Popular Designations

GEMINI SOFTWARE SOLUTIONS SQL Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Xtancia Technosoft Interview Questions
4.0
 • 40 Interviews
Moveinsync Technology Solutions Interview Questions
3.4
 • 29 Interviews
Codingmart Technologies Interview Questions
4.2
 • 28 Interviews
Signzy Technologies Interview Questions
2.8
 • 25 Interviews
Sciative Solutions Interview Questions
4.0
 • 25 Interviews
Pratiti Technologies Interview Questions
3.9
 • 25 Interviews
Global Edge Software Interview Questions
3.5
 • 23 Interviews
MyOperator Interview Questions
3.6
 • 22 Interviews
Trawex Technologies Interview Questions
4.5
 • 20 Interviews
Ichhapurti.com Interview Questions
2.3
 • 19 Interviews
View all
GEMINI SOFTWARE SOLUTIONS Salaries in India
Senior Software Engineer
17 salaries
unlock blur

₹5.3 L/yr - ₹16 L/yr

Software Engineer
10 salaries
unlock blur

₹3 L/yr - ₹4.5 L/yr

Service Delivery Executive
10 salaries
unlock blur

₹2.4 L/yr - ₹3.3 L/yr

Consultant
10 salaries
unlock blur

₹2 L/yr - ₹3.4 L/yr

Service Delivery Engineer
6 salaries
unlock blur

₹2.5 L/yr - ₹6.3 L/yr

Explore more salaries
Compare GEMINI SOFTWARE SOLUTIONS with

Yalamanchili Software Exports

3.3
Compare

ScoreMe Solutions

4.3
Compare

Xtancia Technosoft

4.0
Compare

Global Edge Software

3.5
Compare
Popular Calculators
Are you paid fairly?
Monthly In-hand Salary Calculator
Gratuity Calculator
HRA Calculator
Salary Hike Calculator
Did you find this page helpful?
Yes No
write
Share an Interview