Upload Button Icon Add office photos

Filter interviews by

Clear (1)

Decimal Technologies SQL Developer Interview Questions and Answers

Updated 24 Nov 2024

Decimal Technologies SQL Developer Interview Experiences

1 interview found

SQL Developer Interview Questions & Answers

user image Anonymous

posted on 24 Nov 2024

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

I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.

Round 1 - One-on-one 

(5 Questions)

  • Q1. Difference between function and stored procedure.
  • Ans. 

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

    • Functions return a value, stored procedures do not

    • Functions can be used in SELECT statements, stored procedures cannot

    • Functions must return a value, stored procedures may or may not

  • Answered by AI
  • Q2. Write a query to find the manager of the employee.
  • Ans. 

    Use a self join to find the manager of the employee.

    • Join the employee table with itself on the manager_id and employee_id columns

    • Select the manager's details based on the employee's manager_id

  • Answered by AI
  • Q3. To write a stored procedure.
  • Q4. What is trigger?
  • Ans. 

    A trigger is a special type of stored procedure that automatically executes when certain events occur in a database.

    • Triggers can be used to enforce business rules, perform data validation, or maintain referential integrity.

    • Examples of trigger events include INSERT, UPDATE, and DELETE operations on a table.

    • Triggers can be defined to execute before or after the triggering event.

  • Answered by AI
  • Q5. What do you know about JSON?

Skills evaluated in this interview

Interview questions from similar companies

I applied via Company Website and was interviewed before Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions on Java,SQL,some trending technologies(IOT,Big data),pattern questions, programming questions with different approaches.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basics of DSA, have knowledge about the databases, some common dml ,ddl statements, programming knowledge of a particular language like C,Java, python,etc...have good command on oops concepts... little bit of frameworks knowledge will also help

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 applied via Referral and was interviewed before Apr 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Puzzles, Psychometric Test

Round 2 - One-on-one 

(1 Question)

  • Q1. Some water in 3 Jars question, you had to measure out 5L correctly

Interview Preparation Tips

Interview preparation tips for other job seekers - Make the interview interactive, I got this input from another Senior. Before i went into the interview room the volunteers were telling all those who goes into Room No 1 is screwed. I was praying i don't get room no 1. But fortunately for me I got room no 1 because when the interviewer gave me the puzzle and handed over pen and paper he went back to relax his posture and when i explained i will fill the 5L Jar first, he immediately came forward to listen to me, at that moment i knew i got the job because i felt the previous candidates never made their interview interactive and that's why he went back to relax his posture.

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

I was interviewed 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 was interviewed 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 was interviewed in Jun 2017.

Interview Preparation Tips

Round: Test
Duration: 1 hour 30 minutes

Skills: Engineering Basics

I was interviewed in May 2017.

Interview Preparation Tips

Round: Group Discussion
Duration: 7 hours

College Name: Andhra university

I was interviewed 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
Contribute & help others!
anonymous
You can choose to be anonymous

Decimal Technologies Interview FAQs

How many rounds are there in Decimal Technologies SQL Developer interview?
Decimal Technologies interview process usually has 1 rounds. The most common rounds in the Decimal Technologies interview process are One-on-one Round.
What are the top questions asked in Decimal Technologies SQL Developer interview?

Some of the top questions asked at the Decimal Technologies SQL Developer interview -

  1. Difference between function and stored procedu...read more
  2. Write a query to find the manager of the employ...read more
  3. What is trigg...read more

Recently Viewed

INTERVIEWS

Amul India

No Interviews

INTERVIEWS

Paytm Payments Bank

No Interviews

INTERVIEWS

Decimal Technologies

10 top interview questions

INTERVIEWS

Tejas Networks

No Interviews

INTERVIEWS

Manikaran Analytics

No Interviews

INTERVIEWS

Pramura Software

No Interviews

INTERVIEWS

Integra Micro Systems

No Interviews

LIST OF COMPANIES

Decimal Technologies

Locations

INTERVIEWS

Paytm Payments Bank

No Interviews

INTERVIEWS

Tejas Networks

No Interviews

Tell us how to improve this page.

Decimal Technologies SQL Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

SQL Developer Interview Questions from Similar Companies

View all
Decimal Technologies SQL Developer Salary
based on 4 salaries
₹3.2 L/yr - ₹5 L/yr
8% less than the average SQL Developer Salary in India
View more details
Associate Software Engineer
103 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
70 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Developer
66 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Database Developer
32 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Analyst
29 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Decimal Technologies with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

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