Upload Button Icon Add office photos

Filter interviews by

Productivity Aids Plsql Developer Interview Questions and Answers

Updated 9 Mar 2023

Productivity Aids Plsql Developer Interview Experiences

1 interview found

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

I applied via Naukri.com and was interviewed in Sep 2022. There were 4 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 - Aptitude Test 

Basic aptitude test we can crack easily

Round 3 - Coding Test 

Technical interview scheduled by hr

Round 4 - Technical 

(2 Questions)

  • Q1. About partitions and indexes asked?
  • Q2. View and materialized view Collection data types?
  • Ans. 

    Views and materialized views, collection data types.

    • Views are virtual tables that display data from one or more tables.

    • Materialized views are physical copies of the data in a view.

    • Collection data types include arrays, nested tables, and varrays.

    • Arrays are fixed-size, ordered collections of elements of the same data type.

    • Nested tables are dynamic, unordered collections of elements of the same data type.

    • Varrays are varia...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared regarding your field. You can crack any interview easily.

Skills evaluated in this interview

Top trending discussions

View All
Interview Tips & Stories
1w (edited)
a team lead
Why are women still asked such personal questions in interview?
I recently went for an interview… and honestly, m still trying to process what just happened. Instead of being asked about my skills, experience, or how I could add value to the company… the questions took a totally unexpected turn. The interviewer started asking things like When are you getting married? Are you engaged? And m sure, if I had said I was married, the next question would’ve been How long have you been married? What does my personal life have to do with the job m applying for? This is where I felt the gender discrimination hit hard. These types of questions are so casually thrown at women during interviews but are they ever asked to men? No one asks male candidates if they’re planning a wedding or how old their kids are. So why is it okay to ask women? Can we please stop normalising this kind of behaviour in interviews? Our careers shouldn’t be judged by our relationship status. Period.
Got a question about Productivity Aids?
Ask anonymously on communities.

Interview questions from similar companies

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
-
Result
No response

I applied via Recruitment Consulltant and was interviewed in Jan 2023. There were 3 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 - HR 

(2 Questions)

  • Q1. Basic self introduction
  • Q2. Tell me about your self
Round 3 - Technical 

(1 Question)

  • Q1. It was a virtual technical round. About basic sql and Adv plsql question

Interview Preparation Tips

Interview preparation tips for other job seekers - I have attended second round interview on first week of February 2023. I was informed that it got cleared and HR will call back but no one called me still .dear all is it OK to wait. I dont have any contact person in EY. please post suggestions
Ey HR if you do filtering using resume then why I was asked to attend second round .there too I have cleared it. .

Plsql Developer Interview Questions Asked at Other Companies

asked in TCS
Q1. What is temp table and temp variable in plsql?
asked in TCS
Q2. What is procedure in plsql and it's syntax and difference between ... read more
asked in TCS
Q3. Write a PL/SQL program to print the sequence 103, 99, 96...3.
asked in TCS
Q4. What is a mutating table or mutating trigger?
asked in Cognizant
Q5. Write a SQL query to delete duplicate records from a table.

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

Interview Questionnaire 

10 Questions

  • Q1. Oracle instance architecture
  • Q2. Redo log buffer
  • Q3. Difference between Procedure and function
  • Ans. 

    Procedures and functions are both PL/SQL program units, but they have some key differences.

    • Procedures do not return a value, while functions do.

    • Procedures can have OUT parameters to pass values back to the caller, while functions cannot.

    • Functions can be used in SQL statements, while procedures cannot.

    • Functions must return a value, while procedures do not necessarily have to.

    • Procedures are typically used for performing ...

  • Answered by AI
  • Q4. Difference between implicit and explicit cursor
  • Ans. 

    Implicit cursors are automatically created by the Oracle server, while explicit cursors are explicitly declared by the programmer.

    • Implicit cursors are used for single-row queries, while explicit cursors are used for multi-row queries.

    • Implicit cursors are automatically opened, fetched, and closed by the Oracle server, while explicit cursors need to be manually opened, fetched, and closed by the programmer.

    • Implicit curso...

  • Answered by AI
  • Q5. Difference between soft parsing and hard parsing of sql
  • Ans. 

    Soft parsing is reusing the existing execution plan while hard parsing is generating a new execution plan.

    • Soft parsing is faster as it avoids the overhead of generating a new execution plan.

    • Hard parsing is slower as it involves generating a new execution plan.

    • Soft parsing occurs when the SQL statement is already in the shared pool.

    • Hard parsing occurs when the SQL statement is not in the shared pool or needs a new execu...

  • Answered by AI
  • Q6. Difference between rdbms and dbms
  • Ans. 

    RDBMS is a type of DBMS that stores data in a structured manner using tables with relationships.

    • DBMS is a software system that manages data stored in a computer's memory or disk storage.

    • RDBMS is a type of DBMS that uses a relational model to store data in tables with relationships.

    • RDBMS supports ACID properties (Atomicity, Consistency, Isolation, Durability) for data integrity.

    • Examples of RDBMS include Oracle, MySQL, S...

  • Answered by AI
  • Q7. Write a sql to find nth highest salary
  • Ans. 

    SQL query to find the nth highest salary

    • Use the ORDER BY clause to sort the salaries in descending order

    • Use the LIMIT clause to select the nth highest salary

  • Answered by AI
  • Q8. Write a sql to delete duplicate records from a table
  • Ans. 

    SQL query to delete duplicate records from a table.

    • Use the DELETE statement with a subquery to identify and delete duplicate records.

    • The subquery should select the duplicate records based on the criteria for duplication.

    • Ensure to keep at least one copy of the duplicate records to avoid deleting all instances.

  • Answered by AI
  • Q9. Difference between delete and truncate
  • Ans. 

    Delete is a DML operation that removes specific rows from a table, while truncate is a DDL operation that removes all rows from a table.

    • Delete is slower than truncate as it generates undo logs and triggers

    • Delete can be rolled back, while truncate cannot be rolled back

    • Delete operation maintains the integrity of the transaction log, while truncate operation does not

    • Delete operation fires delete triggers, while truncate o...

  • Answered by AI
  • Q10. Scenario based questions on exceptions in plsql

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Asked few SQL queries from basics to intermediate level, and asked to write plsql code with exceptions . Increased difficulty level in the same program step by step.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I appeared for an interview in Dec 2024, where I was asked the following questions.

  • Q1. What is the procedure to write a PL/SQL function that checks the validity of a provided email address?
  • Ans. 

    A PL/SQL function to validate email addresses using regex patterns.

    • Define a function with a VARCHAR2 parameter for the email address.

    • Use regular expressions to match the email format.

    • Return TRUE if the email matches the pattern, otherwise FALSE.

    • Example regex: '^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Z|a-z]{2,}$'.

    • Consider edge cases like missing '@' or domain parts.

  • Answered by AI
  • Q2. How do you write a trigger to insert data into a table when an insert, delete, or update action occurs on a specified table?
  • Ans. 

    A trigger can automate data insertion in response to changes in a specified table.

    • Triggers are database objects that automatically execute when a specified event occurs.

    • To create a trigger for INSERT, DELETE, or UPDATE, use the CREATE TRIGGER statement.

    • Example: CREATE TRIGGER trg_after_insert AFTER INSERT ON source_table FOR EACH ROW INSERT INTO target_table (column1) VALUES (:NEW.column1);

    • You can define the timing of ...

  • Answered by AI
Round 1 - Technical 

(2 Questions)

  • Q1. Basic SQL related question
  • Q2. Good knowledge on pl SQL is preferred, few in-depth questions . Keep your cool and answer every question with best of your knowledge

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't panic and answer questions with your best experience and knowledge.

I applied via Naukri.com and was interviewed in Jun 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
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
Round 2 - One-on-one 

(2 Questions)

  • Q1. Triggers , procedures , exception handling , collections, package
  • Q2. Type , array, partition, performance tuning, AWR

Interview Preparation Tips

Interview preparation tips for other job seekers - For senior level they will expect knowledge on bulk processing exception handling packages collections
Are these interview questions helpful?

I applied via Campus Placement and was interviewed before Nov 2021. There were 3 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 - Aptitude Test 

Numerical and logical aptitude test

Round 3 - Coding Test 

There are 5 rounds on datastructure and algorithm

Interview Preparation Tips

Interview preparation tips for other job seekers - Nice hr and all team is suportive
Good and smoth interview experiance

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

Interview Questionnaire 

5 Questions

  • Q1. Javascript fundamentals
  • Q2. ES6 Functions
  • Q3. React hooks basics
  • Q4. State Management in React- states and props
  • Ans. 

    State management in React involves managing the state and props of components.

    • State is used to manage data that changes within a component

    • Props are used to pass data from a parent component to a child component

    • State can be updated using setState() method

    • Props are read-only and cannot be modified within a component

    • State and props are used together to create dynamic and interactive UIs

  • Answered by AI
  • Q5. Redux Architecture

Interview Preparation Tips

Interview preparation tips for other job seekers - I attended for react developer role. Asusual it started with self introduction and project role description. Then I was tested on the javascript core concepts with ES6 features and react basics. In the middle, we discussed about the best practices we follow in our project for error handling.

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Jun 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 

I was selected through campus drive at my college. The test was easy. I would suggest freshers to practice some mock tests online, grammer, intelligence, quant., etc.

Round 2 - Technical 

(1 Question)

  • Q1. OOPS related all fundamental questions. I was questioned on only this.
Round 3 - HR 

(2 Questions)

  • Q1. Why do you want to join cognizant?
  • Q2. What is your ultimate goal, IT career or higher education?

Interview Preparation Tips

Interview preparation tips for other job seekers - I would suggest all freshers to prepare for Technical interview by starting with OOPS fundamentals, etc.
Practice mock tests for aptitude especially if you are from not CS/IT branch person.
Work on verbal communication a bit. Stay relaxed and enjoy the interview experience.

Productivity Aids Interview FAQs

How many rounds are there in Productivity Aids Plsql Developer interview?
Productivity Aids interview process usually has 4 rounds. The most common rounds in the Productivity Aids interview process are Resume Shortlist, Aptitude Test and Coding Test.
What are the top questions asked in Productivity Aids Plsql Developer interview?

Some of the top questions asked at the Productivity Aids Plsql Developer interview -

  1. View and materialized view Collection data typ...read more
  2. About partitions and indexes ask...read more

Tell us how to improve this page.

Overall Interview Experience Rating

4/5

based on 1 interview experience

Difficulty level

Moderate 100%

Duration

Less than 2 weeks 100%
View more
Design Engineer
6 salaries
unlock blur

₹1.8 L/yr - ₹3 L/yr

Mechanical Engg. Design
3 salaries
unlock blur

₹1.8 L/yr - ₹5.3 L/yr

Explore more salaries
Compare Productivity Aids with

Cognizant

3.7
Compare

Teleperformance

3.9
Compare

iEnergizer

4.7
Compare

Reliance Retail

3.9
Compare
write
Share an Interview