Upload Button Icon Add office photos
Engaged Employer

i

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

EXL Service Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

EXL Service SQL Developer Interview Questions and Answers

Updated 10 Apr 2024

EXL Service SQL Developer Interview Experiences

1 interview found

SQL Developer Interview Questions & Answers

user image Anonymous

posted on 10 Apr 2024

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Technical 

(3 Questions)

  • Q1. Find 3rd highest salary
  • Ans. 

    Use SQL query with ORDER BY and LIMIT to find 3rd highest salary

    • Use ORDER BY clause to sort salaries in descending order

    • Use LIMIT 2,1 to skip first two highest salaries and get the third highest salary

  • Answered by AI
  • Q2. Pivoting and unpivoting in SQL
  • Ans. 

    Pivoting and unpivoting are techniques used in SQL to transform data from rows to columns and vice versa.

    • Pivoting involves rotating rows into columns, typically used to summarize data.

    • Unpivoting involves rotating columns into rows, typically used to normalize data.

    • Pivoting can be done using the PIVOT keyword in SQL, while unpivoting can be done using the UNPIVOT keyword.

  • Answered by AI
  • Q3. Difference in rank and dense rank
  • Ans. 

    Rank assigns unique rank to each row, while dense rank allows for ties in ranking.

    • Rank leaves gaps in ranking sequence, while dense rank does not

    • Rank(1, 2, 2, 4) = 1, 2, 3, 4

    • Dense Rank(1, 2, 2, 4) = 1, 2, 2, 3

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Ask clearly on the number of rounds , Initially they said there will be two round but later they did 4 rounds , quite unprofessional way of taking interviews they will just call you 1 goir before interview and ask to join stating that it will managerial round but when you will go there you will see actually it's a technical round again

Skills evaluated in this interview

Interview questions from similar companies

I applied via Recruitment Consultant and was interviewed in Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic communication skills were tested. Sone techical questn too. Versant test is mandatory

Interview Preparation Tips

Interview preparation tips for other job seekers - Please never go for these third party vendors. They misguide you regarding profile . I went for this third party vendor named savantis solution and it really misguided me

I applied via Naukri.com and was interviewed before Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Lifecycle methods of Angular
  • Ans. 

    Angular has several lifecycle methods that are called at different stages of a component's life.

    • ngOnInit() - called after the component is initialized

    • ngOnChanges() - called when the component's input properties change

    • ngDoCheck() - called during every change detection cycle

    • ngAfterViewInit() - called after the component's view has been initialized

    • ngOnDestroy() - called just before the component is destroyed

  • Answered by AI
  • Q2. What are pipes in angular?
  • Ans. 

    Pipes are a feature in Angular that allow for data transformation before displaying it in the view.

    • Pipes are used to format data in the view

    • They can be used to filter, sort, and transform data

    • Examples include the date pipe, currency pipe, and uppercase pipe

  • Answered by AI
  • Q3. How to do global error handling in angular?
  • Ans. 

    Global error handling in Angular can be done using ErrorHandler class.

    • Create a class that implements the ErrorHandler interface

    • Override the handleError() method to handle errors globally

    • Provide the ErrorHandler class in the providers array of AppModule

    • Use the error handling service to log errors or display error messages

  • Answered by AI
  • Q4. What are custom directives? What are their types? How to create with general example?
  • Ans. 

    Custom directives are a way to extend HTML with new attributes and functionality.

    • Types of custom directives are attribute, element, and class directives.

    • Attribute directives modify the behavior of existing HTML elements.

    • Element directives create new HTML elements.

    • Class directives modify the behavior of existing HTML elements based on their class.

    • To create a custom directive, use the directive() method of the AngularJS ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - 1. Be confident if you know the answers and frank if you don't.
2. Try to get your basics and core concepts to be clear clear.

Skills evaluated in this interview

I applied via Campus Placement and was interviewed in Nov 2020. There were 6 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. I was asked some journal entries, excel formula and how to run tally software as i was suppose to work on their software. and also basic introduction about myself.so very important to add up some new skill...

Interview Preparation Tips

Interview preparation tips for other job seekers - interview was good, just need to be good in communication skills and please talk in hindi while giving your interview

I applied via Naukri.com and was interviewed in Apr 2021. There were 3 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Oops
  • Q2. WebApi
  • Q3. C#
  • Q4. WCF

Interview Preparation Tips

Interview preparation tips for other job seekers - Nice

I applied via Campus Placement and was interviewed in Mar 2021. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Introduction
  • Q2. Qualification, basic questions about customer service, empathy apology,how to handle angry customer..thats it

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be fluent in English and Hindi ..
Give some good and creative answers that's all..😊.

I applied via Referral and was interviewed before Mar 2021. There were 2 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 Resume tips
Round 2 - Aptitude Test 

Grammar and analytical questions

Interview Preparation Tips

Interview preparation tips for other job seekers - It take more time to declare the interview results

I applied via Naukri.com and was interviewed in Apr 2021. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. What is hana
  • Ans. 

    HANA is an in-memory database and application development platform developed by SAP.

    • HANA stands for High-Performance Analytic Appliance.

    • It allows real-time processing of large amounts of data.

    • It can be used for data warehousing, analytics, and application development.

    • HANA is used by businesses to gain insights from their data and make better decisions.

    • Examples of companies using HANA include Coca-Cola, Nestle, and Merc

  • Answered by AI
  • Q2. Its a DB

Interview Preparation Tips

Interview preparation tips for other job seekers - Good so far

I applied via Referral and was interviewed before Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic questions related to the previous experience

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare all the basic concepts of the technology you are working on

I applied via Naukri.com and was interviewed before May 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Explain me about yourself
  • Q2. Just be brief don't bore them

Interview Preparation Tips

Interview preparation tips for other job seekers - Be bold and confident.
Contribute & help others!
anonymous
You can choose to be anonymous

EXL Service Interview FAQs

How many rounds are there in EXL Service SQL Developer interview?
EXL Service interview process usually has 1 rounds. The most common rounds in the EXL Service interview process are Technical.
How to prepare for EXL Service SQL Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at EXL Service. The most common topics and skills that interviewers at EXL Service expect are SQL Development, SQL Queries, Power Bi, SQL and Analytical skills.
What are the top questions asked in EXL Service SQL Developer interview?

Some of the top questions asked at the EXL Service SQL Developer interview -

  1. Difference in rank and dense r...read more
  2. Find 3rd highest sal...read more
  3. Pivoting and unpivoting in ...read more

Recently Viewed

SALARIES

HGS

SALARIES

Intellect Design Arena

SALARIES

Intellect Design Arena

SALARIES

Intellect Design Arena

INTERVIEWS

EXL Service

No Interviews

SALARIES

HGS

SALARIES

HGS

SALARIES

HGS

SALARIES

HGS

SALARIES

Intellect Design Arena

No Salaries

Tell us how to improve this page.

EXL Service SQL Developer Interview Process

based on 1 interview

Interview experience

1
  
Bad
View more
EXL Service SQL Developer Salary
based on 15 salaries
₹1.8 L/yr - ₹7.5 L/yr
14% less than the average SQL Developer Salary in India
View more details

EXL Service SQL Developer Reviews and Ratings

based on 2 reviews

4.5/5

Rating in categories

4.3

Skill development

4.7

Work-life balance

4.7

Salary

4.5

Job security

4.5

Company culture

4.5

Promotions

4.5

Work satisfaction

Explore 2 Reviews and Ratings
Senior Executive
4.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate
2.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Lead Assistant Manager
1.9k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Executive
1.8k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare EXL Service with

Genpact

3.8
Compare

WNS

3.4
Compare

TCS

3.7
Compare

Infosys

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