Upload Button Icon Add office photos

Filter interviews by

DSoft Infosystem SQL Developer Interview Questions and Answers for Freshers

Updated 2 Aug 2023

DSoft Infosystem SQL Developer Interview Experiences for Freshers

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

Top trending discussions

View All
Interview Tips & Stories
1w
toobluntforu
·
works at
Cvent
Can speak English, can’t deliver in interviews
I feel like I can't speak fluently during interviews. I do know english well and use it daily to communicate, but the moment I'm in an interview, I just get stuck. since it's not my first language, I struggle to express what I actually feel. I know the answer in my head, but I just can’t deliver it properly at that moment. Please guide me
Got a question about DSoft Infosystem?
Ask anonymously on communities.

Interview questions from similar companies

I applied via Company Website and was interviewed before Jun 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

First round was coding as well as aptitude done together went well I guess focusing on codes helps a lot.

Round 2 - Technical 

(1 Question)

  • Q1. 2nd round included tr and mr round went quite enegritic

Interview Preparation Tips

Interview preparation tips for other job seekers - Resume skills matters a lot don't fill resume the technologies you don't even aware of

SQL Developer Interview Questions Asked at Other Companies for Fresher

Q1. What is SQL, SQL command, functions,special operators
Q2. what is stored procedure? what are the types of joins?
Q3. Different types of Join and What is self join
Q4. What is the difference between Oracle Database and ANSI SQL?
Q5. What is the difference between a function and a stored procedure?

Interview Questionnaire 

1 Question

  • Q1. 1)Tmaus? 2 ) why are you lefted previous job? 3) technical skills knowledge 4) work in under pressure? 5) hr round 6) manager round
  • Ans. 

    Interview questions for an Associate position cover various aspects like motivation, skills, and handling pressure.

    • 1) Tmaus: This could refer to a specific term or acronym; clarify its meaning during the interview.

    • 2) Leaving previous job: Focus on seeking new challenges or growth opportunities, not negative experiences.

    • 3) Technical skills: Highlight relevant skills like data analysis, programming languages, or software...

  • Answered by AI

I applied via Campus Placement and was interviewed in Apr 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Are you willing to relocate?
  • Ans. 

    Yes, I am open to relocating for the right opportunity that aligns with my career goals and personal growth.

    • Relocation can provide exposure to new technologies and methodologies.

    • I am excited about the prospect of working in diverse teams and cultures.

    • For example, moving to a tech hub like San Francisco could enhance my career.

    • I understand the challenges of relocating, but I see them as opportunities for growth.

  • Answered by AI
  • Q2. Why should I hire you?
  • Ans. 

    I bring a unique blend of skills, experience, and passion for software development that aligns perfectly with your team's goals.

    • Proven experience in developing scalable applications, such as a recent project where I improved performance by 30%.

    • Strong problem-solving skills demonstrated through my contributions to open-source projects, enhancing functionality and fixing bugs.

    • Excellent teamwork and communication abilitie...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - My technical and Hr interview done at same place. It lasted about 40minutes. The interviewer test both my technical knowledge and communication skills. I tell most of the answer. They check patience level.He stressed on my final year project . Asking about range and specification of compotents which I heve used in my project. Finally ask some HR questions.

I applied via Approached by Company and was interviewed before May 2018. There were 6 interview rounds.

Interview Questionnaire 

5 Questions

  • Q1. This is face to face interview... They are observing our behaviour... Attitude... Etc
  • Q2. Introduce u r self....
  • Ans. 

    I am a dedicated and hardworking individual with a passion for learning and growth.

    • I have a Bachelor's degree in Business Administration from XYZ University.

    • I have 3 years of experience working in marketing and sales roles.

    • I am proficient in Microsoft Office Suite and have strong communication skills.

    • I am a team player and enjoy collaborating with others to achieve common goals.

  • Answered by AI
  • Q3. U r carrier objections
  • Ans. 

    My career objectives focus on continuous growth, contributing to team success, and making a positive impact in my field.

    • Aim to develop expertise in my field, such as becoming a certified project manager.

    • Seek leadership opportunities to guide and mentor junior team members.

    • Aspire to work on innovative projects that challenge my skills and creativity.

    • Desire to contribute to a company's mission, like improving customer sa...

  • Answered by AI
  • Q4. About TCS
  • Q5. Why should u select TCS
  • Ans. 

    TCS is a global leader in IT services with a strong reputation for innovation and client satisfaction.

    • TCS has a proven track record of delivering high-quality services to clients worldwide.

    • TCS offers a wide range of opportunities for career growth and development.

    • TCS values diversity and inclusion, creating a supportive work environment for employees.

    • TCS invests in cutting-edge technologies and training programs to kee...

  • Answered by AI

Interview Preparation Tips

Round: Group Discussion
Experience: Any kind of topic u cn select... Sales, accounts, service

Round: Test
Experience: Aptitude test... Mathematic and problem solving... General knowledge is very important

Round: Telephonic
Experience: This is final round... BH directly interact with us...

General Tips: Be confident... Be clam.... Keep smiling face... That is the way to win
Skills: Communication, Body Language, Leadership, Presentation Skills, Time Management
Duration: <1 week

I applied via Walk-in and was interviewed before Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Indoctrination and asked some accounts

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't get panic. If you are known or not . Just tell they have asked the question.

I applied via Naukri.com and was interviewed before Mar 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Talk about any topic for atleast 3mins
  • Ans. 

    Exploring the impact of technology on education and how it shapes learning experiences for students today.

    • Technology enhances accessibility to educational resources, e.g., online courses from platforms like Coursera.

    • Interactive tools like Kahoot! and Quizlet make learning engaging and fun for students.

    • Virtual classrooms enable remote learning, allowing students to connect globally, especially during the pandemic.

    • Artifi...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with any topic and talk confidently with out stoping.
Are these interview questions helpful?

I applied via LinkedIn and was interviewed before Jul 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Easy logical questions
basic quant

Round 2 - Coding Test 

Easy level coding questions
Counting frequency of alphabets

Interview Preparation Tips

Interview preparation tips for other job seekers - Just go through the basics of javascript
Hoisting

Interview Questionnaire 

1 Question

  • Q1. How to use multiple dispatch in redux?
  • Ans. 

    Multiple dispatch is not a feature of Redux. It can be achieved using middleware or custom logic.

    • Middleware like redux-thunk or redux-saga can be used to dispatch multiple actions based on a single action.

    • Custom logic can be implemented in the reducer to handle multiple actions based on a single action type.

    • For example, a single 'ADD_ITEM' action can trigger multiple actions like 'UPDATE_TOTAL', 'UPDATE_HISTORY', etc.

    • M...

  • Answered by AI

Skills evaluated in this interview

I applied via Naukri.com and was interviewed before Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Asked about my working skills, technical skills... Finance accounting related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident, brief about your CV...

DSoft Infosystem Interview FAQs

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

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

  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.

Overall Interview Experience Rating

1/5

based on 1 interview experience

Difficulty level

Hard 100%

Duration

Less than 2 weeks 100%
View more
DSoft Infosystem SQL Developer Salary
based on 17 salaries
₹2.4 L/yr - ₹3.3 L/yr
45% less than the average SQL Developer Salary in India
View more details

DSoft Infosystem SQL Developer Reviews and Ratings

based on 6 reviews

5.0/5

Rating in categories

4.9

Skill development

4.7

Work-life balance

4.1

Salary

4.2

Job security

4.6

Company culture

4.3

Promotions

4.7

Work satisfaction

Explore 6 Reviews and Ratings
Database Developer
36 salaries
unlock blur

₹2.4 L/yr - ₹5 L/yr

SQL Developer
17 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.6
Compare

Accenture

3.8
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare
write
Share an Interview