Upload Button Icon Add office photos

Filter interviews by

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

Interview Questionnaire 

3 Questions

  • Q1. Based on API coding Round
  • Q2. Designing + project
  • Q3. HR

Interview Preparation Tips

Round: Test
Experience: 30 MCQ questions testing basic logical reasoning, quantitative aptitude, analytical skills.
2 coding questions --I skipped 1st that was a mistake as it was the easiest. Basic array adhoc question.
2nd-greedy algorithm based find number of platforms for a train schedule.
1 API coding on trie data structure. Functions were all there. Problem--Given a word with a letter missing...find and print possible words from the dictionary. for example--
Input- dristisofts 5
Output- drishtisofts
drisetisofts
1 debugging question-toughest of them all for me...2d-matrix find the rectangle with largest sum.
Tips: Basic Level of Questions for me. I never explicitly prepared for those. Doable.
Try both 1st and 2nd...they will be easy...C and java are only possible languages given so can't use stl.
API will be easy only lengthy...don't panic...
If you have time, you will try 4th.

Duration: 180 minutes
Total Questions: 34

Round: Test
Experience: Completely networking based problem. based on TCP protocol. packets are being dropped and changed find a way to stop it. I was able to pass all test cases. (they were having some internal problems with there test cases).
Tips: Exciting round. Use re-transmission and sequence id and hash coding. Focus on everything. Interviews will be based on these.
Duration: 60 minutes
Total Questions: 1

Round: Test
Experience: N=4. find errors and generalise for N.
Tips: Easy-peasy.
Duration: 60 minutes
Total Questions: 1

Round: Technical Interview
Experience: Lovely experience. Duration -2hours. Interviewer was a chill guy. Interview started with some light moments and we discussed about my experience with the company I did my internship with. Then there was questioning about what I did in my API coding round. I was asked to explain point by point about how I understood the problem and how I solved it. Then he started grilling me on questions based on it. One by one questions were put in some way that I had to revisit everything what I learnt in my 2nd year about transmission protocol. Everything, starting with what was the hash code used to how the window size is decided and how to reduce traffic by sending cumulative ack.
Tips: Better prepare networking before coming. Everything, every exception.

Round: Technical Interview
Experience: I was asked to tell any two of my projects. And this is where I think I got an edge over others. My resume was filled with many projects and we discussed two of my most recent projects. I had learnt about Oauth protocol and RESTful APIs so we discussed about it. Then there was this problem about a company visiting for campus recruiting wanting to conduct a test on Hackerearth + what if lights went off and students want to continue where they had left --the problem was to design a databse based on these conditions and then some questions were asked on the database I had made. Finally there was an interview scheduling problem.50 students. 3 rounds(1->P1,P2 2->P2,P3 3->P4). design an algorithm to conduct the interviews taking minimum time to process all 50 students.
Tips: Prepare your projects and DBMS as well. Be confident, build approaches to tackle problems and try finding loopholes in it and then work on those. They will be focussing more on how you will tackle a general problem and not the solution.

Round: HR Interview
Experience: Introductions with family background. Psychometric test. and then I was told to ask about the company. Interviewer was very cool.
Tips: Easy - peasy.

General Tips: Do away with any nervousness. The interviewers will be extremely friendly. Just do your best. If you know it, it isn't that hard. Hints would be given. They just test your approach and knowledge of the subject.
Skill Tips: TCP concepts and socket programming. Projects on that would be lovely.
Skills: Networking, DBMS
College Name: NIT Jalandhar
Funny Moments: The interview was held in guest rooms lying down on bed. I was even asked to take rest and sleep for an hour before interviews alongside their bed.

Interview Preparation Tips

Round: Test
Experience: The online test had two sections. First had simple objective aptitude questions.
The other section had coding problems.
There were 4 questions.
Two were adhoc problems.
In the other two we had to add code to solve the problem.

I did well in the objective section and did 3 of the coding problems.
Duration: 180 minutes

Round: Test
Experience: We were given code of n-queen problem which had some errors in it.

We were given the task to correct the code and explain it.

I did it well in time.
Duration: 30 minutes

Round: Test
Experience: In this round we were given a problem statement.
What we had to do was to implement a client and server side.
Basic code was given.

What we had to do was to implement code that could detect message alteration or if there was a packet drop.

Round: Technical Interview
Experience: This round went for almost 2 hours.
It was more of a discussion. It was on the developer's coding round. The interviewer was very cool. He tested all my knowledge about networking. The discussion on the software model went on and he kept on giving me more and more exception conditions which I had to solve for the problem.

Round: Technical Interview
Experience: This round also went for another 2 hours.
The interviewer asked me to pick any 2 of my projects and explain it to him.
After I explained the projects he gave me a question on DP.
It was also more of a discussion. I wasn't able to give him the correct answer in the end.

Round: HR Interview
Experience: It was a very cool round. He asked me to fill in a form and asked me if I had any queries about the company.
Then he asked me some basic HR questions. This round was like a formality not a elimination round.

Skills:
College Name: NIT Jalandhar

Interview Questionnaire 

2 Questions

  • Q1. What do you want to do in future?
  • Ans. 

    I want to become a technical lead and work on innovative projects.

    • I plan to gain more experience in software development and project management.

    • I want to learn new technologies and keep up with industry trends.

    • I hope to mentor and guide junior developers to help them grow in their careers.

    • I aspire to work on projects that have a positive impact on society.

  • Answered by AI
  • Q2. Where do you see yourself in the next 10 years?
  • Ans. 

    In 10 years, I see myself as a senior software developer leading a team of developers to create innovative solutions.

    • Leading a team of developers to create innovative solutions

    • Continuing to learn and stay up-to-date with new technologies

    • Mentoring junior developers

    • Contributing to open-source projects

    • Attending and speaking at tech conferences

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Moderate stuff was there, not very difficult to crack.
Tips: Just try to stay cool and solve the questions.
Duration: 90 min minutes
Total Questions: 50-60

Round: Test
Experience: There were 3 coding questions.
One of them was from linked-list (a simple one)
And another was from the tree (to be solved by recursion and this one was also easy)
And the last question was from Dynamic Programming (moderate difficulty)
Tips: Solve the two easy questions with the best possible algorithm that you can.
And if you are able to solve the last one then its ok otherwise don't leave it, atleast write some lines of code.
And I would like to suggest geeksforgeeks for the preparation of this coding round.
Duration: 90 min minutes
Total Questions: 3

Round: Test
Experience: I was given 2 questions with their codes (one of them was of 100 lines and another code was about 250 lines).
Both the codes were having some errors and we have to rectify them.
First of all I was asked to understand the given codes and draw a flow chart describing the algorithm of the code.
And then I was asked to find out the errors in the given code.
Tips: Just stick to the code.
This round was not that much easy as the previous ones.
You have to stick to the code till the last.
Duration: 3 hours minutes
Total Questions: 2

Round: Test
Experience: I was given some APIs of a server and I have to write a client program that uses these APIs to design a game for knight-moves in a 8X8 chess board.
Tips: The main issue was there in synchronising the client requests to the server.
You must have the basic knowledge of server-client programs.
Duration: 3 hours minutes
Total Questions: 1

Round: Technical Interview
Experience: I don't remember the questions but this round was not so difficult as the last two rounds.
There were simple technical questions related to what you have done in your internship and basic OS,DBMS.
Tips: Stay calm and look relaxed.

Round: HR Interview
Experience: Most of the questions were about my family background.
Tips: Just keep calm and smiling.
Don't try to over-react and the most important thing is be yourself.

General Tips: 1: Be Confident.
2: Keep Smiling.
3: Do not be Panic.
4: Remember they are here to hire you but not reject you.
5: Do not loose hope.
6: Believe at yourself.
7: Start preparing early.
8: Do demo interviews with your friend.
Skill Tips: Follow geeksforgeeks and do practise the server-client programs.
Skills: Coding, Client-Server Programs, Aptitude , OS basics, OOPs, DBMS, Reasoning skills
College Name: NIT DURGAPUR
Motivation: Every body joins a comapny for making a software or earning money. But I was always motivated to MAKE MONEY. I have taken this job because they have very extensive work in Share Market and they have lots of MBA from IIM's, Lots of CAs, CS. Thats why i have choosen Edelweiss. I have rejected epic System USA for this profile.

I appeared for an interview before Apr 2021.

Round 1 - Coding Test 

(2 Questions)

Round duration - 60 minutes
Round difficulty - Easy

The second round is also written but you need to write programming based on their concept.

  • Q1. 

    Prime Numbers Identification

    Given a positive integer N, your task is to identify all prime numbers less than or equal to N.

    Explanation:

    A prime number is a natural number greater than 1 that has no po...

  • Ans. 

    Identify all prime numbers less than or equal to a given positive integer N.

    • Iterate from 2 to N and check if each number is prime

    • Use the Sieve of Eratosthenes algorithm for better efficiency

    • Optimize by only checking up to the square root of N for divisors

  • Answered by AI
  • Q2. 

    Palindrome String Validation

    Determine if a given string 'S' is a palindrome, considering only alphanumeric characters and ignoring spaces and symbols.

    Note:
    The string 'S' should be evaluated in a case...
  • Ans. 

    Check if a given string is a palindrome after removing special characters, spaces, and converting to lowercase.

    • Remove special characters and spaces from the string

    • Convert the string to lowercase

    • Check if the modified string is a palindrome by comparing characters from start and end

  • Answered by AI
Round 2 - Face to Face 

(6 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Technical round with questions mainly on Java and OOPS concepts.

  • Q1. What is the difference between static methods and instance methods in Java?
  • Ans. 

    Static methods belong to the class itself, while instance methods belong to individual objects of the class.

    • Static methods are called using the class name, while instance methods are called using object references.

    • Static methods cannot access instance variables directly, while instance methods can access both static and instance variables.

    • Static methods are shared among all instances of the class, while instance method...

  • Answered by AI
  • Q2. What is the difference between an abstract class and an interface in Java?
  • Ans. 

    Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.

    • Abstract class can have constructors, member variables, and methods with implementation.

    • Interface can only have abstract methods and constants.

    • A class can implement multiple interfaces but can only extend one abstract class.

    • Example: Abstract class - Animal with abstract method 'eat', Interface - Flyable with m

  • Answered by AI
  • Q3. What is the difference between ClassNotFoundException and NoClassDefFoundError in Java?
  • Ans. 

    ClassNotFoundException occurs when a class is not found during runtime, while NoClassDefFoundError occurs when a class was found during compilation but not during runtime.

    • ClassNotFoundException is a checked exception, while NoClassDefFoundError is an Error.

    • ClassNotFoundException occurs when a class is not found at runtime, usually due to a missing classpath or incorrect class name.

    • NoClassDefFoundError occurs when a cla...

  • Answered by AI
  • Q4. What is the difference between an Error and an Exception in Java?
  • Ans. 

    Error is a serious issue that cannot be handled at runtime, while Exception is a recoverable issue that can be caught and handled.

    • Error is a subclass of Throwable and is usually caused by the environment or system, such as running out of memory or stack overflow.

    • Exception is also a subclass of Throwable but is caused by the application code, such as invalid input or file not found.

    • Errors are unchecked and are not meant...

  • Answered by AI
  • Q5. What is SerialVersionUID in Java?
  • Ans. 

    SerialVersionUID is a unique identifier used by Java to ensure the compatibility of serialized objects.

    • SerialVersionUID is a static final long variable in a class that implements Serializable interface.

    • It is used to ensure that the serialized object can be deserialized correctly even if the class definition has changed.

    • If the SerialVersionUID of the serialized object does not match the one in the class, an InvalidClass...

  • Answered by AI
  • Q6. What are the requirements for creating an immutable class in Java?
  • Ans. 

    Requirements for creating an immutable class in Java

    • Make the class final so it cannot be extended

    • Make all fields private and final

    • Do not provide setter methods, only getter methods

    • Ensure that mutable objects are not returned in getter methods

    • Override equals() and hashCode() methods for proper comparison

    • Consider making defensive copies of mutable fields in constructor or getter methods

  • Answered by AI

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPAYodlee interview preparation:Topics to prepare for the interview - Data Structures, Algorithms, System Design, Aptitude, OOPSTime required to prepare for the interview - 4 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

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

2 DSA questions Both are from DP

Round 2 - Technical 

(2 Questions)

  • Q1. 2 Questions , 1 is DSA
  • Q2. Second question is Puzzle

Interview Preparation Tips

Interview preparation tips for other job seekers - Practise DSA more and give more and more interviews.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jan 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Oops? .net core features
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Explain basics of c#
  • Ans. 

    C# is a programming language developed by Microsoft for building a wide range of applications on the .NET framework.

    • C# is an object-oriented language with features like classes, inheritance, and polymorphism.

    • It is strongly typed, meaning variables must be declared with a specific data type.

    • C# supports modern programming concepts like async/await for asynchronous programming.

    • It is commonly used for developing desktop, w...

  • Answered by AI
  • Q2. C# basics oops sql server

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare basics

Skills evaluated in this interview

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

2 question 1 on string and 2 on array , easy level

Round 2 - HR 

(1 Question)

  • Q1. Salary discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Good company for senior level
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - Coding Test 

Implement tail -f command

Round 2 - Technical 

(2 Questions)

  • Q1. Kafka partitions
  • Q2. Elasticsearch queries
Round 3 - HR 

(2 Questions)

  • Q1. Why Browserstack?
  • Ans. 

    Browserstack is a popular cloud-based cross-browser testing tool used by developers worldwide.

    • Provides access to a wide range of browsers and devices for testing

    • Allows for parallel testing to save time and increase efficiency

    • Integrates with popular testing frameworks like Selenium and Appium

    • Offers features like screenshots, video recordings, and debugging tools

    • Used by companies like Microsoft, Twitter, and Airbnb for t

  • Answered by AI
  • Q2. Any challenge you faced at current company?
  • Ans. 

    Yes, I faced a challenge in integrating a new third-party API with our existing system.

    • Had to understand the documentation of the API thoroughly

    • Encountered compatibility issues with our system

    • Worked closely with the API provider to troubleshoot and resolve issues

  • Answered by AI

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

Tell us how to improve this page.

Decimal Technologies SQL Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

BrowserStack Interview Questions
3.6
 • 48 Interviews
Fleetx.io Interview Questions
3.7
 • 28 Interviews
ZIGRAM Interview Questions
3.2
 • 26 Interviews
RGBSI Interview Questions
3.4
 • 24 Interviews
Fingent Interview Questions
4.4
 • 22 Interviews
Ameyo Interview Questions
3.4
 • 18 Interviews
Soroco Interview Questions
2.8
 • 18 Interviews
Yodlee Interview Questions
3.8
 • 17 Interviews
View all
Decimal Technologies SQL Developer Salary
based on 4 salaries
₹3.3 L/yr - ₹5.1 L/yr
9% less than the average SQL Developer Salary in India
View more details
Associate Software Engineer
97 salaries
unlock blur

₹3 L/yr - ₹9.2 L/yr

Software Engineer
74 salaries
unlock blur

₹4 L/yr - ₹10.9 L/yr

Software Developer
67 salaries
unlock blur

₹3 L/yr - ₹10 L/yr

Database Developer
32 salaries
unlock blur

₹3 L/yr - ₹9 L/yr

Data Analyst
29 salaries
unlock blur

₹4 L/yr - ₹9 L/yr

Explore more salaries
Compare Decimal Technologies with

Aurigo

4.7
Compare

Prime Focus Technologies

3.3
Compare

Peel-works

3.6
Compare

Yodlee

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