AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Decimal Technologies SQL Developer Interview Questions and Answers
Decimal Technologies SQL Developer Interview Experiences
1 interview found
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(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
- 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
- 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.
- Q5. What do you know about JSON?
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Shubham
Interview Questionnaire
3 Questions
- Q1. Based on API coding Round
- Q2. Designing + project
- Q3. HR
Interview Preparation Tips
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
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.
- 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
Interview Preparation Tips
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.
(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 toN.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
- 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
(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...
- 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
- 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...
- 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...
- 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...
- 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
Interview Preparation Tips
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.
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.
Skills evaluated in this interview
2 DSA questions Both are from DP
(2 Questions)
- Q1. 2 Questions , 1 is DSA
- Q2. Second question is Puzzle
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed before Jan 2024. There was 1 interview round.
(1 Question)
- Q1. Oops? .net core features
Software Developer Interview Questions & Answers
Prime Focus Technologies
Anonymous
posted on 30 Oct 2023
(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...
- Q2. C# basics oops sql server
Interview Preparation Tips
Skills evaluated in this interview
2 question 1 on string and 2 on array , easy level
(1 Question)
- Q1. Salary discussion
Interview Preparation Tips
I applied via Referral and was interviewed in Feb 2024. There were 3 interview rounds.
Implement tail -f command
(2 Questions)
- Q1. Kafka partitions
- Q2. Elasticsearch queries
(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
- 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
Decimal Technologies Interview FAQs
Tell us how to improve this page.
Decimal Technologies Interviews By Designations
- Decimal Technologies Graduate Trainee Interview Questions
- Decimal Technologies Angular Developer Interview Questions
- Decimal Technologies Software Developer Interview Questions
- Decimal Technologies QA QC Engineer Interview Questions
- Decimal Technologies Associate Software Engineer Interview Questions
- Decimal Technologies Application Developer Interview Questions
- Decimal Technologies Senior Associate Interview Questions
- Decimal Technologies Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Front end Developer Interview Questions
- Web Developer Interview Questions
- Backend Developer Interview Questions
- Software Developer Intern Interview Questions
- Junior Software Developer Interview Questions
- Full Stack Software Developer Interview Questions
- PHP Developer Interview Questions
- UI Developer Interview Questions
- Show more
Decimal Technologies SQL Developer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Associate Software Engineer
97
salaries
|  ₹3 L/yr - ₹9.2 L/yr |
|
Software Engineer
74
salaries
| ₹4 L/yr - ₹10.9 L/yr |
|
Software Developer
67
salaries
| ₹3 L/yr - ₹10 L/yr |
|
Database Developer
32
salaries
| ₹3 L/yr - ₹9 L/yr |
|
Data Analyst
29
salaries
| ₹4 L/yr - ₹9 L/yr |
Aurigo
Prime Focus Technologies
Peel-works
Yodlee
- Home >
- Interviews >
- Decimal Technologies Interview Questions >
- Decimal Technologies SQL Developer Interview Questions
