e-Zest Plsql Developer Interview Questions and Answers

Q1. RANK, WITH CLAUSE, PARTITION, DISTINCT, REF CURSOR
Add your answer
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
Add your answer
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
Add your answer
Q4. Joins, DBMS_PROFILER
Add your answer

Q1. Basics of Angular
Add your answer
Q2. Routing, interceptor
Add your answer

Output event emitter, filter related coding

Coding and few concepts in angular

It was aptitude round

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
Add your answer
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
Add your answer

Technical questions will be there

Simple coding questions will be asked.

Q1. Only about salary and joining dates.
Add your answer

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...read more
Add your answer
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
Add your answer

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.

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

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

Ask what the effects on Indian economy due to climent change

Ask some aptitude and technical questions

Q1. Ask some dbms queries and method overloading and method overridng
Add your answer

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...read more
Answered by AI
Add your answer