Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Celebal Technologies Team. If you also belong to the team, you can get access from here

Celebal Technologies Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Celebal Technologies SQL Developer Interview Questions and Answers

Updated 7 Sep 2024

Celebal Technologies SQL Developer Interview Experiences

5 interviews found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via LinkedIn and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Array , LL , string, dp, binary tree, binary search tree, heaps

Round 2 - Assignment 

Array question , string, dp, binary search tree, heaps

SQL Developer Interview Questions & Answers

user image Anonymous

posted on 25 Jun 2024

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

I applied via campus placement at National Institute of Technology,(NIT), Delhi and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Verbal and quantitative

Round 2 - Coding Test 

One string and one array

SQL Developer Interview Questions Asked at Other Companies

asked in BNP Paribas
Q1. How is a change request in application serviced by development te ... read more
asked in BNP Paribas
Q2. Write down a procedure to return a certain series (99, 96, 93, .. ... read more
asked in BNP Paribas
Q3. Given sample data on two tables, write down the result sets of al ... read more
asked in Capgemini
Q4. 2. Query optimization techniques? 3. Types of schemas and differe ... read more
asked in Accenture
Q5. What is Database Management System?

SQL Developer Interview Questions & Answers

user image Anonymous

posted on 20 Oct 2023

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
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 - Coding Test 

Dsa Coding questions and sql queries were asked.

Round 3 - Technical 

(1 Question)

  • Q1. Face 2 Face online technical interview

SQL Developer Interview Questions & Answers

user image piyush agarwal

posted on 27 Feb 2024

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via campus placement at Jaipur Engineering College & Research Centre, Jaipur and was interviewed before Feb 2023. There were 2 interview rounds.

Round 1 - Coding Test 

One section is of Aptitude, two section are of coding, two section are of sql

Round 2 - HR 

(1 Question)

  • Q1. Normal Discussion

Celebal Technologies interview questions for designations

 SQL Database Administrator

 (1)

 Java Developer

 (2)

 Software Developer

 (1)

 React Developer

 (1)

 Javascript Developer

 (1)

 Cloud Developer

 (1)

 RPA Developer

 (1)

 Power BI Developer

 (3)

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Referral and was interviewed before Apr 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Basic SQL questions like Joins,Group by,Select,Delete,Truncate difference
  • Ans. You need to have basic understanding of SQL concepts
  • Answered Anonymously
  • Q2. Triggers,Stored Procedure,ACID properties

Interview Preparation Tips

Interview preparation tips for other job seekers - Just revise all basic concepts for technical rounds and keep it to the point.

Interview questions from similar companies

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

I applied via campus placement at Dayananda Sagar College of Engineering, Bangalore and was interviewed in Oct 2024. There were 4 interview rounds.

Round 1 - Coding Test 

3 coding dsa question
Difficulty is On your luck
My friends got easy level
I got medium level
Some got hard questions as well

Round 2 - Aptitude Test 

Ssh round , quant and logical
Tip: bring your calculator

Round 3 - Technical 

(3 Questions)

  • Q1. Two Puzzle : bulb switching and candle
  • Q2. Dsa questions such as string reverse, binary search
  • Q3. Dbms and os core subject questions
Round 4 - HR 

(2 Questions)

  • Q1. How are you better than others
  • Q2. Why should we hire you

Interview Preparation Tips

Interview preparation tips for other job seekers - If you are a girl, the interview rounds will be much easier for you as this company promotes diversity hiring.
The main differing factor is technical round interview which totally depends on the interviewer's mood .
Girls do get priority in this round, they are asked easier questions and will be selected if able to answer 60-70% of the questions.
Note:- it's not like they will hire any girl but a bit easier comparatively
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Basic Questions, Data types, Promises
  • Q2. Event loop, and other js concepts
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Campus Placement and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Group Discussion 

Maintain a good communication to the hr

Round 2 - Technical 

(5 Questions)

  • Q1. Questions from your resume and projects
  • Q2. Difference between elements and tags
  • Ans. 

    Elements are individual components of a web page, while tags are used to define the structure of elements in HTML.

    • Elements are the actual components on a web page, such as headings, paragraphs, images, etc.

    • Tags are used to define the structure of elements in HTML, such as

      for a heading or

      for a paragraph.

    • Elements can have attributes that provide additional information or functionality, while tags do not.

Answered by AI
  • Q3. Uses of functions in js
  • Ans. 

    Functions in JavaScript are used to define reusable blocks of code that can be called multiple times.

    • Functions can be used to perform specific tasks or calculations.

    • Functions can be passed as arguments to other functions.

    • Functions can be assigned to variables or properties of objects.

    • Functions can be used to create closures for encapsulating data.

    • Functions can be used to create custom methods for objects.

  • Answered by AI
  • Q4. Uses of get elementbyId in js
  • Ans. 

    getElementById is used in JavaScript to access and manipulate an element in the DOM by its unique ID.

    • Used to retrieve a specific element from the DOM by its ID

    • Allows for manipulation of the element's properties, styles, and content

    • Commonly used in event handling and dynamic content updates

  • Answered by AI
  • Q5. Typesof cssess ?
  • Ans. 

    There are three types of CSS: inline, internal, and external.

    • Inline CSS is applied directly to an HTML element using the style attribute.

    • Internal CSS is defined within the head section of an HTML document using the style tag.

    • External CSS is stored in a separate file and linked to the HTML document using the link tag.

  • Answered by AI

    Interview Preparation Tips

    Interview preparation tips for other job seekers - Be confident at what you have

    Skills evaluated in this interview

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

    (1 Question)

    • Q1. I don't Remember the question1
    Round 2 - Technical 

    (2 Questions)

    • Q1. I don't remember the question2
    • Q2. I don't remember the question
    Interview experience
    5
    Excellent
    Difficulty level
    Moderate
    Process Duration
    Less than 2 weeks
    Result
    Not Selected

    I applied via Campus Placement and was interviewed in Sep 2023. There were 3 interview rounds.

    Round 1 - Coding Test 

    Coding and aptitude and logical reasoning three sections were there.In Coding you have 4 language to choose from and you must select 2 languages and in each language you have to solve 2 questions. It was relatively easy .

    Round 2 - Technical 

    (3 Questions)

    • Q1. They ask you to do programming for questions. If you are a thief and you have an array of houses you cannot rob the beside houses of the house you ribbed. Maximise the loot.
    • Q2. Insert node at middle in linked list
    • Ans. 

      To insert a node at the middle of a linked list, find the middle node and adjust pointers accordingly.

      • Find the middle node using slow and fast pointers

      • Insert the new node after the middle node

      • Adjust pointers to link the new node correctly

    • Answered by AI
    • Q3. Find number of Perfect subarrays of the given array .A perfects subarray has odd value at odd place and even value at even position.
    • Ans. 

      Count the number of perfect subarrays in an array where odd values are at odd positions and even values are at even positions.

      • Iterate through the array and keep track of the count of odd and even numbers encountered so far.

      • If the count of odd and even numbers at the current index matches the index itself, increment the count of perfect subarrays.

      • Example: For array [2, 1, 3, 4], there are 3 perfect subarrays: [2, 1], [1

    • Answered by AI
    Round 3 - Technical 

    (3 Questions)

    • Q1. They give you direct leetcode sums and ask to solve
    • Q2. Find if a number is there in a sorted array or not and if its not there where shoud it be inserted in log(n) time
    • Ans. 

      Binary search can be used to find the number in a sorted array in log(n) time.

      • Implement binary search algorithm to find the number in the sorted array.

      • If the number is not found, return the index where it should be inserted.

      • Time complexity of binary search is O(log n).

    • Answered by AI
    • Q3. You are given parallel bars selecting two bars you can make a container .Maximise area.Find the slution in o(n)
    • Ans. 

      To maximize the area of a container formed by two parallel bars, use the two-pointer approach in O(n) time complexity.

      • Use the two-pointer approach to iterate from both ends towards the center of the array.

      • Calculate the area formed by the two bars at each step and update the maximum area found so far.

      • Move the pointer with the smaller height towards the center to potentially find a larger area.

      • Repeat the process until th

    • Answered by AI

    Interview Preparation Tips

    Interview preparation tips for other job seekers - Do leetcode questions daily.Do medium and easy questions daily.
    I heard last round contained them asking questions from other big coding platforms such as geekforgeeks ,CodeChef etc

    Skills evaluated in this interview

    Celebal Technologies Interview FAQs

    How many rounds are there in Celebal Technologies SQL Developer interview?
    Celebal Technologies interview process usually has 2-3 rounds. The most common rounds in the Celebal Technologies interview process are Coding Test, Resume Shortlist and Technical.
    What are the top questions asked in Celebal Technologies SQL Developer interview?

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

    1. Basic SQL questions like Joins,Group by,Select,Delete,Truncate differe...read more
    2. Triggers,Stored Procedure,ACID propert...read more
    3. Face 2 Face online technical interv...read more

    Tell us how to improve this page.

    Celebal Technologies SQL Developer Interview Process

    based on 6 interviews

    Interview experience

    4.3
      
    Good
    View more

    SQL Developer Interview Questions from Similar Companies

    View all
    Celebal Technologies SQL Developer Salary
    based on 8 salaries
    ₹5 L/yr - ₹6.5 L/yr
    23% more than the average SQL Developer Salary in India
    View more details

    Celebal Technologies SQL Developer Reviews and Ratings

    based on 4 reviews

    4.5/5

    Rating in categories

    4.6

    Skill development

    4.3

    Work-life balance

    4.5

    Salary

    4.2

    Job security

    4.3

    Company culture

    4.2

    Promotions

    4.3

    Work satisfaction

    Explore 4 Reviews and Ratings
    Data Engineer
    373 salaries
    unlock blur

    ₹4 L/yr - ₹12 L/yr

    Associate
    246 salaries
    unlock blur

    ₹4 L/yr - ₹10 L/yr

    Associate Data Engineer
    157 salaries
    unlock blur

    ₹2.5 L/yr - ₹11 L/yr

    Associate Consultant
    156 salaries
    unlock blur

    ₹5 L/yr - ₹16.4 L/yr

    Data Scientist
    124 salaries
    unlock blur

    ₹4.5 L/yr - ₹16.5 L/yr

    Explore more salaries
    Compare Celebal 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