Upload Button Icon Add office photos
Engaged Employer

i

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

Cognizant Verified Tick

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Clear (1)

Cognizant Plsql Developer Interview Questions, Process, and Tips

Updated 19 Apr 2024

Top Cognizant Plsql Developer Interview Questions and Answers

View all 7 questions

Cognizant Plsql Developer Interview Experiences

4 interviews found

I applied via Naukri.com and was interviewed in Jun 2022. 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 Resume 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
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.

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
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 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

Cognizant interview questions for designations

 Developer

 (6)

 Software Developer

 (124)

 Java Developer

 (24)

 Salesforce Developer

 (18)

 RPA Developer

 (10)

 Application Developer

 (9)

 Servicenow Developer

 (9)

 Python Developer

 (9)

Interview questions from similar companies

Interview Questionnaire 

2 Questions

  • Q1. They have only one phone interview
  • Q2. They asking about full sql and plsql

Interview Preparation Tips

Round: Resume Shortlist
Experience: Detailed description of explaination full topics

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Factorial of a number
  • Ans. 

    Factorial of a number is the product of all positive integers up to that number.

    • To calculate factorial of a number, multiply all positive integers up to that number.

    • Factorial of 0 is 1.

    • Example: Factorial of 5 is 5*4*3*2*1 = 120.

  • Answered by AI
  • Q2. Sql queries including 2nd highest salary and table joins
Round 2 - Technical 

(2 Questions)

  • Q1. Sql question and table joins
  • Q2. Modelling of schema
  • Ans. 

    Modelling of schema involves designing the structure of a database to organize and represent data.

    • Identify entities and their relationships

    • Define attributes for each entity

    • Establish primary and foreign keys

    • Normalize the schema to reduce redundancy

    • Consider performance and scalability

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Some sql queries
1 DSA prime no

Skills evaluated in this interview

Interview Questionnaire 

2 Questions

  • Q1. Index , collection, partition, package, pragma autonomous transaction
  • Q2. Answer confidently
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. EXPLAIN ABOUT UR PRJECT
  • Ans. 

    Developed a PL/SQL project for managing inventory and sales data in a retail store.

    • Designed database tables to store product information, sales transactions, and customer details.

    • Implemented PL/SQL procedures and functions for adding, updating, and querying data.

    • Created triggers to enforce business rules and maintain data integrity.

    • Developed reports using PL/SQL queries to analyze sales performance and inventory levels

  • Answered by AI
  • Q2. How do you work on performance optimization
  • Ans. 

    I work on performance optimization by analyzing query execution plans, indexing, and code refactoring.

    • Analyzing query execution plans to identify bottlenecks

    • Creating appropriate indexes to improve query performance

    • Refactoring code to optimize resource usage

    • Using tools like Explain Plan and SQL Tuning Advisor

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
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 Resume tips
Round 2 - Technical 

(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 a query to delete duplicates from table 5.whi...
Round 3 - One-on-one 

(1 Question)

  • Q1. Waiting for round 1 results
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

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

(1 Question)

  • Q1. Window Functions in SQL
  • Ans. 

    Window functions in SQL are used to perform calculations across a set of table rows related to the current row.

    • Window functions are used to calculate values based on a set of rows related to the current row.

    • They allow you to perform calculations without grouping the rows into a single output row.

    • Examples of window functions include ROW_NUMBER(), RANK(), and LAG().

  • Answered by AI
Round 3 - Technical 

(1 Question)

  • Q1. Uses of Packages in PL/SQL
  • Ans. 

    Packages in PL/SQL are used to group related procedures, functions, variables, and other PL/SQL constructs together for better organization and security.

    • Packages help in modularizing code for easier maintenance and debugging

    • They provide encapsulation and hide implementation details

    • Packages can contain multiple procedures, functions, variables, cursors, and exceptions

    • They improve performance by reducing network traffic

    • E...

  • Answered by AI

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

Cognizant Interview FAQs

How many rounds are there in Cognizant Plsql Developer interview?
Cognizant interview process usually has 1-2 rounds. The most common rounds in the Cognizant interview process are Technical, Resume Shortlist and One-on-one Round.
How to prepare for Cognizant 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 Cognizant. The most common topics and skills that interviewers at Cognizant expect are PLSQL, Oracle, Performance Tuning, Unix Shell Scripting and Oracle SQL.
What are the top questions asked in Cognizant Plsql Developer interview?

Some of the top questions asked at the Cognizant Plsql Developer interview -

  1. Write a sql to delete duplicate records from a ta...read more
  2. Difference between soft parsing and hard parsing of ...read more
  3. Difference between implicit and explicit cur...read more

Recently Viewed

COMPANY BENEFITS

ICICI Bank

Kakinada

6 benefits

COMPANY BENEFITS

ICICI Bank

Junagadh

1 benefit

COMPANY BENEFITS

ICICI Bank

No Benefits

SALARIES

Tata AIA Life Insurance

JOBS

YASH Technologies

No Jobs

REVIEWS

ICICI Bank

No Reviews

SALARIES

Axis Direct

SALARIES

Axis Direct

COMPANY BENEFITS

ICICI Bank

No Benefits

SALARIES

SBI General Insurance

Tell us how to improve this page.

Cognizant Plsql Developer Interview Process

based on 1 interview

1 Interview rounds

  • Technical Round
View more
Cognizant Plsql Developer Salary
based on 358 salaries
₹3.2 L/yr - ₹13 L/yr
33% more than the average Plsql Developer Salary in India
View more details

Cognizant Plsql Developer Reviews and Ratings

based on 29 reviews

4.1/5

Rating in categories

4.2

Skill development

3.9

Work-life balance

3.5

Salary

3.9

Job security

4.2

Company culture

3.0

Promotions

3.9

Work satisfaction

Explore 29 Reviews and Ratings
Associate
72.1k salaries
unlock blur

₹5.1 L/yr - ₹16 L/yr

Programmer Analyst
55.5k salaries
unlock blur

₹2.4 L/yr - ₹9.5 L/yr

Senior Associate
48.9k salaries
unlock blur

₹9 L/yr - ₹27.8 L/yr

Senior Processing Executive
28.9k salaries
unlock blur

₹1.8 L/yr - ₹9 L/yr

Technical Lead
17.5k salaries
unlock blur

₹5.9 L/yr - ₹21 L/yr

Explore more salaries
Compare Cognizant with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

Accenture

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