Upload Button Icon Add office photos

Filter interviews by

DSoft Infosystem SQL Developer Interview Questions, Process, and Tips

Updated 2 Aug 2023

DSoft Infosystem SQL Developer Interview Experiences

1 interview found

Interview experience
1
Bad
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
-

I applied via AmbitionBox and was interviewed before Aug 2022. There were 3 interview rounds.

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 - Technical 

(4 Questions)

  • Q1. What is stored procedure? what are the types of joins?
  • Ans. 

    A stored procedure is a prepared SQL code that can be saved and reused.

    • Stored procedures are used to perform a specific task or set of tasks in a database.

    • They can accept input parameters and return output parameters.

    • Stored procedures can improve performance by reducing network traffic and improving security.

    • Examples: sp_GetCustomerDetails, sp_InsertEmployee

  • Answered by AI
  • Q2. What is view and explain type
  • Ans. 

    A view in SQL is a virtual table based on the result set of a SELECT query. There are different types of views like simple, complex, indexed, etc.

    • Views are used to simplify complex queries by storing them as a virtual table.

    • Types of views include simple views, complex views, indexed views, etc.

    • Views can be used to restrict access to certain columns or rows of a table.

    • Views can improve performance by pre-computing expen

  • Answered by AI
  • Q3. Difference between function and stored procedure
  • Ans. 

    Functions return a value while stored procedures do not. Functions can be used in SQL statements, while stored procedures cannot.

    • Functions return a single value, while stored procedures do not necessarily return any value.

    • Functions can be used in SQL statements like SELECT, WHERE, etc., while stored procedures cannot be used in such statements.

    • Functions are called using SELECT statement, while stored procedures are cal...

  • Answered by AI
  • Q4. Write a query to display nth highest salary
  • Ans. 

    Query to display nth highest salary in SQL

    • Use the ORDER BY clause to sort salaries in descending order

    • Use the DISTINCT keyword to eliminate duplicates

    • Use the LIMIT clause to specify the nth highest salary

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Current ctc ? how much u expect

Interview Preparation Tips

Topics to prepare for DSoft Infosystem SQL Developer interview:
  • stored procedure,views,indexes
  • joins
Interview preparation tips for other job seekers - confidently talk . nice conversation.

Skills evaluated in this interview

Interview questions from similar companies

I applied via Newspaper Ad and was interviewed before Jun 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 
Round 2 - Technical 

(1 Question)

  • Q1. Basic questions of java.
Round 3 - HR 

(1 Question)

  • Q1. Intro and other hr related questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Cover the basic questions regarding the programming language.

I appeared for an interview before Jun 2016.

Interview Questionnaire 

4 Questions

  • Q1. Tell me something about yourself
  • Ans. 

    I am a passionate software developer with 5 years of experience in web development and a strong background in computer science.

    • 5 years of experience in web development

    • Strong background in computer science

    • Passionate about software development

  • Answered by AI
  • Q2. Questions related to project I have worked on during college days
  • Q3. Core Java concepts
  • Q4. Why do you use two mobile numbers
  • Ans. 

    To separate personal and professional calls, and to ensure availability and accessibility.

    • Separate personal and professional calls

    • Ensure availability and accessibility

    • Maintain work-life balance

    • Avoid mixing personal and work-related contacts

  • Answered by AI

Interview Preparation Tips

Round: Test
Total Questions: 60

College Name: Watumull Institute Of Electronics Engineering And Computer Technology ( WIEECT )

I appeared for an interview in Sep 2016.

Interview Questionnaire 

3 Questions

  • Q1. Tell me about yourself
  • Ans. 

    I am a passionate software developer with experience in Java, Python, and web development.

    • Experienced in Java, Python, and web development technologies

    • Strong problem-solving skills and ability to work in a team

    • Completed multiple projects including a web-based inventory management system

  • Answered by AI
  • Q2. Simple coding questions..Basically pattern.
  • Q3. And also they will ask about your projects.

Interview Preparation Tips

Round: Test
Experience: 60 multiple choice questions so have to manage time carefully.
Tips: Have to give equal importance to all the sections..So try to do well in all section.
Duration: 1 hour 30 minutes
Total Questions: 60

Round: Technical + HR Interview
Experience: Don't panic...Only write those things that you know in your resume.

Skills: Smart Coding
College Name: Jaypee Institute Of Information Technology, Noida

I appeared for an interview in May 2017.

Interview Preparation Tips

Round: Test
Total Questions: 20

Round: Group Discussion
Duration: 1 hour

Skills: Coding Skills And Knowledge On Data Structures

I appeared for an interview in Jun 2017.

Interview Preparation Tips

Round: Test
Duration: 1 hour 30 minutes

Skills: Engineering Basics

I appeared for an interview in May 2017.

Interview Preparation Tips

Round: Group Discussion
Duration: 7 hours

College Name: Andhra university

I appeared for an interview in Aug 2017.

Interview Preparation Tips

Round: Test
Tips: Practice e litmus questions and also give mock tests on placement season
Duration: 2 hours

Round: Technical + HR Interview
Experience: The interviewer asked me questions from the subjects I mentioned in my CV and also asked so many situational questions like what will you do in this situation etc.

Skills: Presence Of Mind, Technical Skill

Interview Preparation Tips

Round: Test
Experience: It included quantitative ability questions and a few subjective coding type questions. Nothing known about cutoff as almost major chunk of people appearing for the test were called for the interview.The criteria for test is mainly on CGs and at timesdepartments too.There are rare companies like BCG, DB who actually refer your resumes for interviews without tests.
Duration: 1 hour minute

Round: Technical Interview
Experience: 2 rounds of interview were there – first the technical interview which included questions on your resume. Detailed questionson every point you have mentioned, cross checking whether you really know aboutit at times asking you for examples. No speed math was included. The interview was purely on all the stuff mentioned in the resume.
Tips: Study the resume thorough with every point mentioned. Questionswere asked about things externally related (not in the resume) to stuffmentioned as part of skills. So while exaggerating any point be aware of everyfact about it.

Round: HR Interview
Experience: The HR interview included personal level questions like tell me about yourself, where you hail from, positives, negatives, why cognizant, why non-core, how do you see yourself after 2-3 years etc.The second stage may depend upon GDs or interviews. In this case it was purely one –on-one interview in both rounds.

Round: Case Study Interview
Experience: Mentioned about R a tool used in analytics and was talked about linear and logistic regression. Questions about Big Data Analysis and hadoop etc were asked.

General Tips: Its better to start from August solving CAT papers which helps a lot. Purefin certifications do help for companies like DB, Futures First, Nomura and all. Read only quantitative and a few previous years’ case studies (googled as per the company). Read one to two cases everyday and discussions related to them on the internet and write relevant points in some notebook at times searching for terms or phrases. Read the newspaper daily be it times or even the economic times – know whats happening in the world. They may ask you questions like – whats happening in the world. Be sure to answer them with what they would like to hear rather than what you would like to talk on.The situation is better for non core companies because majority of them don’t see the word department while recruiting from iit. Both for non-core or core: give your best for every round andeven if you don’t get selected for first round you can try to push your resumein on spot interview calls for companies you really want to be part of.Although it isn’t fair play but that’s what happens from Placemnt season day 2.And if the rest do it there's no point regretting than to be a part of it.
College Name: IIT MADRAS

Interview Preparation Tips

Round: Test
Experience: The testincluded quantitative ability questionsand a few subjective coding type questions. Nothing known about cutoff as almost major chunk of people appearing for the test were called for the interview.
Duration: 60 minutes

Round: Technical Interview
Experience: Technical interview included questions on your resume. Detailed questions on every point you have mentioned, cross checking whether you really know about it at times asking you for examples. No speed math was included. The interview was purely on all the stuff mentioned in the resume.
Tips: Suggestion: study the resume thorough with every point mentioned. Questions were asked about things externally related (not in the resume) to stuff mentioned as part of skills. So while exaggerating any point be aware of every fact about it.

Round: HR Interview
Experience: The HR interview included personal level questions like tell me about yourself, where you hail from, positives, negatives, why cognizant, why non-core, how do you see yourself after 2-3 years etc.

College Name: IIT MADRAS

DSoft Infosystem Interview FAQs

How many rounds are there in DSoft Infosystem SQL Developer interview?
DSoft Infosystem interview process usually has 3 rounds. The most common rounds in the DSoft Infosystem interview process are Resume Shortlist, Technical and HR.
What are the top questions asked in DSoft Infosystem SQL Developer interview?

Some of the top questions asked at the DSoft Infosystem SQL Developer interview -

  1. what is stored procedure? what are the types of joi...read more
  2. difference between function and stored proced...read more
  3. write a query to display nth highest sal...read more

Tell us how to improve this page.

DSoft Infosystem SQL Developer Interview Process

based on 2 interviews

Interview experience

3
  
Average
View more
DSoft Infosystem SQL Developer Salary
based on 16 salaries
₹2.4 L/yr - ₹3.3 L/yr
43% less than the average SQL Developer Salary in India
View more details

DSoft Infosystem SQL Developer Reviews and Ratings

based on 5 reviews

5.0/5

Rating in categories

4.8

Skill development

4.7

Work-life balance

4.0

Salary

4.1

Job security

4.7

Company culture

4.3

Promotions

4.7

Work satisfaction

Explore 5 Reviews and Ratings
Database Developer
34 salaries
unlock blur

₹2.4 L/yr - ₹5.6 L/yr

SQL Developer
16 salaries
unlock blur

₹2.4 L/yr - ₹3.3 L/yr

Software Engineer
3 salaries
unlock blur

₹3 L/yr - ₹3.6 L/yr

Software Developer
3 salaries
unlock blur

₹3 L/yr - ₹3.6 L/yr

Explore more salaries
Compare DSoft Infosystem with

TCS

3.7
Compare

Accenture

3.8
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview