Premium Employer

i

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

Clover Infotech Verified Tick

Compare button icon Compare button icon Compare
3.6

based on 1.1k Reviews

Filter interviews by

Clover Infotech Plsql Developer Interview Questions and Answers

Updated 9 Jan 2025

Clover Infotech Plsql Developer Interview Experiences

3 interviews found

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

I applied via Recruitment Consulltant and was interviewed in Dec 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Explain Public , private Procedure
  • Q2. Cursor and Trigger , Mutating error
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Recruitment Consulltant and was interviewed in Dec 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Public and private procedure
  • Q2. Cursor , triggers and function

Plsql Developer Interview Questions Asked at Other Companies

asked in TCS
Q1. What is procedure in plsql and it's syntax and difference between ... read more
asked in TCS
Q2. What is temp table and temp variable in plsql?
asked in TCS
Q3. A plsql programme to print 103,99,96...3?
asked in TCS
Q4. What is mutating table or mutating trigger?
asked in TCS
Q5. How do you find if two table having similer data

Plsql Developer Interview Questions & Answers

user image Nayan Parmar

posted on 7 Feb 2024

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

I applied via Naukri.com and was interviewed in Jan 2024. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. All basics of Oracle SQL, Oracle PLSQL and scenario based questions
Round 2 - Client Interview 

(1 Question)

  • Q1. ICICI bank client - all basics of Oracle SQL and plsql and some scenario based questions like joins based, case statement based, set operator based, aggregate function and all

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and clear concept of basic. If you do not know the practical experience then simply answer the concept and explain it that's it . They want concept clear with confidence.

Plsql Developer Jobs at Clover Infotech

View all

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - Technical 

(4 Questions)

  • Q1. RANK, WITH CLAUSE, PARTITION, DISTINCT, REF CURSOR
  • Q2. Procedure with Ref cursor AVG, EXISTS, write a block to find factorial
  • Ans. 

    Using PL/SQL to create a procedure with a ref cursor to find the average and factorial of a given number.

    • Create a procedure that takes in a number as input and returns the average of that number using a ref cursor.

    • Use the EXISTS function to check if a factorial exists for a given number.

    • Write a block of code to calculate the factorial of a number using a loop.

  • Answered by AI
  • Q3. Handle duplicate records with case statement
  • Ans. 

    Use a case statement to handle duplicate records in PL/SQL.

    • Use a case statement to check for duplicate records based on specific criteria.

    • Implement logic within the case statement to handle the duplicates appropriately.

    • Consider using a unique identifier or combination of columns to identify duplicates.

  • Answered by AI
  • Q4. Joins, DBMS_PROFILER

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. Basics of Angular
  • Q2. Routing, interceptor
Round 2 - Coding Test 

Output event emitter, filter related coding

Round 3 - Coding Test 

Coding and few concepts in angular

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

It was aptitude round

Round 2 - Technical 

(2 Questions)

  • Q1. What are OOPS in java?
  • Ans. 

    OOPS in Java stands for Object-Oriented Programming concepts which include inheritance, encapsulation, polymorphism, and abstraction.

    • OOPS stands for Object-Oriented Programming concepts

    • Includes inheritance, encapsulation, polymorphism, and abstraction

    • Encourages modular and reusable code

    • Allows for easier maintenance and updates

    • Example: Creating classes and objects in Java

  • Answered by AI
  • Q2. Explain exception handling in java
  • Ans. 

    Exception handling in Java is a mechanism to handle runtime errors and prevent program crashes.

    • Use try-catch blocks to handle exceptions

    • Use finally block to execute code regardless of exception

    • Use throw keyword to manually throw exceptions

    • Use throws keyword in method signature to declare exceptions that can be thrown

  • Answered by AI

Skills evaluated in this interview

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

I applied via Referral and was interviewed in May 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Technical questions will be there

Round 2 - Coding Test 

Simple coding questions will be asked.

Round 3 - HR 

(1 Question)

  • Q1. Only about salary and joining dates.
Interview experience
2
Poor
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Jul 2023. 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 tips
Round 2 - Technical 

(2 Questions)

  • Q1. 1. Introduce yourself, by describing all the projects you have worked on. 2. What is your approach to bringing in a Bone Fracture classifier? 3. Confusion matrix and its definitions of TP, FP and Precision...
  • Q2. What is your current CTC and what is your expected CTC?
  • Ans. 

    Current CTC is confidential. Expectation is based on market standards and my experience.

    • Current CTC is confidential information and not disclosed in interviews.

    • Expected CTC is based on market standards, industry trends, and my experience.

    • I am looking for a competitive salary package that aligns with my skills and expertise.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Sonata Software Senior Developer interview:
  • Deep Learning
  • Machine Learing
  • Python
Interview preparation tips for other job seekers - Please make sure to the HR team about your relevant and total experience in years.
It seems like the HR screening was okay and I didn't proceed to the next rounds because the Interviewers felt I didn't have enough experience.
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Dec 2023. There were 3 interview rounds.

Round 1 - Group Discussion 

GD assesses the overall personality – thoughts, feelings and behaviour - of an individual in a group. A topic is presented to the group members for discussion.

Round 2 - Group Discussion 

To share and exchange knowledge and ideas, clarify doubts, and arrive at a collective decision or understanding

Round 3 - Case Study 

A case study is an appropriate research design when you want to gain concrete, contextual, in-depth knowledge about a specific real-world subject.

Interview Preparation Tips

Interview preparation tips for other job seekers - Thank you
Interview experience
2
Poor
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via campus placement at A. D. Patel Institute of Technology, Vallabh Vidyanagar and was interviewed in Jun 2023. There were 5 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 - Group Discussion 

Ask what the effects on Indian economy due to climent change

Round 3 - Aptitude Test 

Ask some aptitude and technical questions

Round 4 - Technical 

(1 Question)

  • Q1. Ask some dbms queries and method overloading and method overridng
Round 5 - HR 

(1 Question)

  • Q1. Add oops concepts on room
  • Ans. 

    Object-oriented programming concepts can be applied to a room by treating it as an object with properties and behaviors.

    • Encapsulation: Encapsulate the room's properties (such as size, color, furniture) and behaviors (such as lighting, temperature control) within a Room class.

    • Inheritance: Create subclasses of Room for different types of rooms (e.g. Bedroom, LivingRoom) that inherit common properties and behaviors from t...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - All rounds are best experience for me.

Skills evaluated in this interview

Clover Infotech Interview FAQs

How many rounds are there in Clover Infotech Plsql Developer interview?
Clover Infotech interview process usually has 1-2 rounds. The most common rounds in the Clover Infotech interview process are Technical and Client Interview.
How to prepare for Clover Infotech Plsql 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 Clover Infotech. The most common topics and skills that interviewers at Clover Infotech expect are PLSQL, Oracle, SQL, SQL Development and Triggers.
What are the top questions asked in Clover Infotech Plsql Developer interview?

Some of the top questions asked at the Clover Infotech Plsql Developer interview -

  1. Explain Public , private Proced...read more
  2. ICICI bank client - all basics of Oracle SQL and plsql and some scenario based ...read more
  3. All basics of Oracle SQL, Oracle PLSQL and scenario based questi...read more

Tell us how to improve this page.

Clover Infotech Plsql Developer Interview Process

based on 6 interviews

1 Interview rounds

  • Technical Round
View more
Join Clover Infotech Digital Solutions for the New-Age Enterprise
Clover Infotech Plsql Developer Salary
based on 113 salaries
₹2.3 L/yr - ₹9.2 L/yr
18% less than the average Plsql Developer Salary in India
View more details

Clover Infotech Plsql Developer Reviews and Ratings

based on 11 reviews

3.5/5

Rating in categories

3.2

Skill development

2.9

Work-life balance

2.9

Salary

3.2

Job security

3.4

Company culture

3.0

Promotions

3.2

Work satisfaction

Explore 11 Reviews and Ratings
PLSQL Developer

Pune,

Chennai

+1

3-6 Yrs

₹ 7-10 LPA

PL/SQL Developer

Mumbai

2-5 Yrs

₹ 2.65-9 LPA

Explore more jobs
Software Engineer
1.2k salaries
unlock blur

₹1.8 L/yr - ₹9 L/yr

Senior Software Engineer
831 salaries
unlock blur

₹4.2 L/yr - ₹15.6 L/yr

Technical Support Engineer
617 salaries
unlock blur

₹2 L/yr - ₹7.5 L/yr

Application Support Engineer
567 salaries
unlock blur

₹2 L/yr - ₹8.3 L/yr

Oracle Database Administrator
479 salaries
unlock blur

₹1.8 L/yr - ₹10 L/yr

Explore more salaries
Compare Clover Infotech with

TCS

3.7
Compare

Wipro

3.7
Compare

Infosys

3.7
Compare

HCLTech

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