Add office photos
Filter interviews by
HCL Group Plsql Developer Interview Questions and Answers
Updated
25 Sep 2023
1 interview found
Sort by:
Popular
Anonymous
Interview experience
Average
Difficulty level
Moderate
Duration
-
Result
Not Selected
I applied via Naukri.com and was interviewed in Aug 2023.
4 Interview Rounds
1
Resume Shortlist Round
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
2
HR Round (1 Question)
- Q1. Experience,ctc,expected ctc Add Answer
3
Technical Round (1 Question)
- Q1. Plsql concepts , procedure , functions Add Answer
4
Technical Round (1 Question)
- Q1. Plsql advance concepts, procedure , function Add Answer
Interview questions from similar companies
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I was interviewed in Nov 2024.
1 Interview Round
1
Technical Round (4 Questions)
- Q1. Types of partition in sql Add Answer
- Q2. Can we edit data in complex views, will the underlying table be effected? Add Answer
- Q3. How do you do performance tuning? Add Answer
- Q4. Tell about regex Add Answer
Suvham Das
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Factorial of a number View Answers (1)
- Q2. Sql queries including 2nd highest salary and table joins Add Answer
2
Technical Round (2 Questions)
- Q1. Sql question and table joins Add Answer
- Q2. Modelling of schema View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Some sql queries
1 DSA prime no
1 DSA prime no
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Easy
Duration
-
Result
-
I applied via Naukri.com and was interviewed in Apr 2024.
1 Interview Round
1
Technical Round (6 Questions)
- Q1. What is view? Can we update in view? View Answers (1)
- Q2. What is synonym? View Answers (1)
- Q3. What is sequence View Answers (1)
- Q4. What is procedures? View Answers (1)
- Q5. What is difference between procedure and functions View Answers (1)
- Q6. What is partitions? View Answers (1)
Skills evaluated in this interview
Imaya Valli
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
3 Interview Rounds
1
Resume Shortlist Round
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
2
Technical Round (1 Question)
- Q1. 1.How to search a text in all database objects- search in all_source table 2.difference between procedure & function 3.difference between case & decode 4.write ...read more Add Answer
3
One-on-one Round (1 Question)
- Q1. Waiting for round 1 results Add Answer
uma devi
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Aptitude Test Round
It is little bit easy
2
Coding Test Round
2 coding question in python
Interview experience
Average
Difficulty level
Moderate
Duration
2-4 weeks
Result
No response
I applied via Approached by Company and was interviewed in Sep 2023.
3 Interview Rounds
1
Resume Shortlist Round
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
2
Technical Round (1 Question)
- Q1. Window Functions in SQL View Answers (1)
3
Technical Round (1 Question)
- Q1. Uses of Packages in PL/SQL View Answers (1)
Skills evaluated in this interview
Interview experience
Bad
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Not Selected
I was interviewed in Feb 2023.
2 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
2
Technical Round (2 Questions)
- Q1. 1. What are Triggers? Explain and differentiate type of Triggers? 2. What are Views? Materialized View? 3. Explain Job role in the Current Company? 4. What is I...read more Add Answer
- Q2. Reason for Job change Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - I gave the interview as an experienced, Got selected but still I haven't received Offer letter
Venkatesh Ganesh
I applied via Naukri.com and was interviewed in Jun 2022.
2 Interview Rounds
1
Resume Shortlist Round
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
2
One-on-one Round (2 Questions)
- Q1. Triggers ,
procedures ,
exception handling ,
collections,
package Add Answer
- Q2. Type , array, partition, performance tuning, AWR Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - For senior level they will expect knowledge on bulk processing exception handling packages collections
Interview experience
Average
Difficulty level
Moderate
Duration
2-4 weeks
Result
Not Selected
I applied via LinkedIn and was interviewed in Jul 2024.
1 Interview Round
1
Technical Round (7 Questions)
- Q1. How to delete duplicates from same table View Answers (1)
- Q2. Write a query to display 5th max salary View Answers (1)
- Q3. What is cursor and its attributes View Answers (1)
- Q4. What is exception handling and write its syntax View Answers (1)
- Q5. What is performance tuning View Answers (1)
- Q6. Write merge statement in plsql View Answers (1)
- Q7. What are triggers and write its syntax View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - prepare for coding also
Skills evaluated in this interview
HCL Group Interview FAQs
How many rounds are there in HCL Group Plsql Developer interview?
HCL Group interview process usually has 4 rounds. The most common rounds in the HCL Group interview process are Technical, Resume Shortlist and HR.
Tell us how to improve this page.
HCL Group Interviews By Designations
- HCL Group Software Engineer Interview Questions
- HCL Group Analyst Interview Questions
- HCL Group Senior Software Engineer Interview Questions
- HCL Group Technical Lead Interview Questions
- HCL Group Lead Engineer Interview Questions
- HCL Group Software Developer Interview Questions
- HCL Group Softwaretest Engineer Interview Questions
- HCL Group Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- Oracle SQL and PLSQL Developer Interview Questions
- Senior Plsql Developer Interview Questions
- 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
- Show more
People are getting interviews through
based on 1 HCL Group interview
Job Portal
100%
Low
Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Plsql Developer Interview Questions from Similar Companies
Fast track your campus placements
5%
less
than the average Plsql Developer Salary in India
View more details
HCL Group Plsql Developer Reviews and Ratings
based on 5 reviews
Rating in categories
|
Software Engineer
4k
salaries
|  ₹1.9 L/yr - ₹9.6 L/yr |
|
Technical Lead
3.8k
salaries
| ₹7 L/yr - ₹26 L/yr |
|
Senior Software Engineer
3k
salaries
| ₹4 L/yr - ₹15 L/yr |
|
Lead Engineer
2.8k
salaries
| ₹4.3 L/yr - ₹13.5 L/yr |
|
Senior Analyst
2.3k
salaries
| ₹1.6 L/yr - ₹8 L/yr |
Explore more salaries
Compare HCL Group with
HCLTech
Compare
TCS
Compare
Tata Group
Compare
Wipro
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- HCL Group Interview Questions >
- HCL Group Plsql Developer Interview Questions
Share an Interview