Add office photos
i
EXL Service
Compare
Filter interviews by
EXL Service SQL Developer Interview Questions and Answers
EXL Service SQL Developer Interview Experiences
1 interview found
Anonymous
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
(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
- 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.
- 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
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
(2 Questions)
- Q1. Html/css based questions.
- Q2. Write css to make a backdrop.
- Ans.
Use CSS to create a backdrop for a webpage.
Use the 'background' property to set the color or image of the backdrop.
Set the 'position' property to 'fixed' to ensure the backdrop covers the entire viewport.
Adjust the 'z-index' property to ensure the backdrop is behind other elements.
Skills evaluated in this interview
I applied via Recruitment Consulltant and was interviewed in May 2024. There was 1 interview round.
(4 Questions)
- Q1. RESTful API Services
- Q2. Questions on ES6 -> Generator, Weakset
- Q3. Knowledge on Testing
- Q4. Basic Angular, CSS questions
I applied via Referral and was interviewed in Aug 2024. There were 2 interview rounds.
120 mins of aptitude test, was good.
Detailed front end assignment
(1 Question)
- Q1. What is event capturing and event bubbling
- Ans.
Event capturing and event bubbling are two phases of event propagation in the DOM.
Event capturing involves the event starting from the top of the DOM tree and trickling down to the target element.
Event bubbling involves the event starting at the target element and bubbling up the DOM tree.
Event capturing is executed first, followed by event bubbling.
Event.stopPropagation() can be used to stop event propagation.
Understa...
Skills evaluated in this interview
EXL Service Interview FAQs
Tell us how to improve this page.
EXL Service Interviews By Designations
- EXL Service Business Analyst Interview Questions
- EXL Service Consultant Interview Questions
- EXL Service Executive Interview Questions
- EXL Service Assistant Manager Interview Questions
- EXL Service Senior Associate Interview Questions
- EXL Service Senior Executive Interview Questions
- EXL Service Data Analyst Interview Questions
- EXL Service Associate 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
SQL Developer Interview Questions from Similar Companies
Fast track your campus placements
EXL Service SQL Developer Reviews and Ratings
based on 2 reviews
Rating in categories
|
Senior Executive
4.3k
salaries
|  ₹0.9 L/yr - ₹7 L/yr |
|
Assistant Manager
2.9k
salaries
| ₹4 L/yr - ₹15 L/yr |
|
Senior Associate
2.4k
salaries
| ₹1.2 L/yr - ₹8 L/yr |
|
Lead Assistant Manager
1.9k
salaries
| ₹6.4 L/yr - ₹22 L/yr |
|
Associate
1.7k
salaries
| ₹1 L/yr - ₹5.5 L/yr |
Genpact
WNS
TCS
Infosys
- Home >
- Interviews >
- EXL Service Interview Questions >
- EXL Service SQL Developer Interview Questions
