Upload Button Icon Add office photos
Engaged Employer

i

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

Tech Mahindra Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Tech Mahindra Plsql Developer Interview Questions and Answers

Updated 17 Jul 2024

Tech Mahindra Plsql Developer Interview Experiences

1 interview found

Plsql Developer Interview Questions & Answers

user image Suvham Das

posted on 17 Jul 2024

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

Rate your
company

🤫 100% anonymous

How was your last interview experience?

Share interview

Plsql Developer Jobs at Tech Mahindra

View all

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 Questionnaire 

2 Questions

  • Q1. Index , collection, partition, package, pragma autonomous transaction
  • Q2. Answer confidently
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Types of cursors
  • Ans. 

    Types of cursors include implicit, explicit, and parameterized cursors.

    • Implicit cursors are automatically created by Oracle when a SQL statement is executed.

    • Explicit cursors are defined by the programmer using the DECLARE, OPEN, FETCH, and CLOSE statements.

    • Parameterized cursors allow for dynamic SQL statements to be executed with different parameters.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare plsql topics well.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Question based on PLSQL
  • Q2. What is Execution Plan, Query Optimization
  • Ans. 

    Execution plan is a roadmap created by the database optimizer to determine the most efficient way to execute a query.

    • Execution plan shows the steps the database will take to execute a query.

    • Query optimization involves finding the most efficient way to execute a query.

    • Optimization techniques include index usage, join methods, and access paths.

    • Understanding execution plans helps in tuning queries for better performance.

  • 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.
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - Technical 

(4 Questions)

  • Q1. Sql loader questions - Give command
  • Q2. Difference in procedure and function
  • Ans. 

    Procedure is used to perform an action, while function returns a value.

    • Procedure does not return a value, while function does

    • Functions can be used in SQL queries, procedures cannot

    • Functions can be called from SQL statements, procedures cannot

  • Answered by AI
  • Q3. What is init in performance tuning?
  • Ans. 

    In performance tuning, init refers to the initialization parameter file used by Oracle Database to configure various settings.

    • init is a text-based configuration file that contains parameters to optimize the performance of Oracle Database.

    • It is used to set parameters such as memory allocation, parallel processing, and resource utilization.

    • By tuning the init file, developers can improve the overall performance of the dat...

  • Answered by AI
  • Q4. Exception handling - Named and unnamed. Give exceptions names.
  • Ans. 

    Named and unnamed exceptions in PL/SQL with examples

    • Named exceptions are user-defined exceptions with specific names like 'custom_exception'

    • Unnamed exceptions are predefined exceptions like 'NO_DATA_FOUND' or 'TOO_MANY_ROWS'

    • Named exceptions can be raised using RAISE statement with the exception name

    • Unnamed exceptions are raised automatically by the system in case of errors

    • Example of named exception: DECLARE custom_exce...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Just know the basics. But Infosys keeps people waiting in queue for months before giving out the results.
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

Plsql Developer Interview Questions & Answers

Infosys user image Bvm Bharath Kumar

posted on 14 Oct 2023

Interview experience
4
Good
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 

(2 Questions)

  • Q1. Dif between SQL n plsql
  • Ans. 

    SQL is a query language used to interact with databases, while PL/SQL is a procedural language extension for SQL.

    • SQL is used for querying and manipulating data in databases.

    • PL/SQL is used for writing procedural code like loops, conditions, and functions.

    • SQL statements are executed one at a time, while PL/SQL blocks can contain multiple statements.

    • PL/SQL can be used to create stored procedures, functions, and triggers i...

  • Answered by AI
  • Q2. Structure query language and extension version of sql
  • Ans. 

    SQL is a structured query language used to communicate with databases. SQL extensions add additional functionality to the language.

    • SQL is a standard language used to interact with databases

    • SQL extensions like PL/SQL add procedural programming capabilities to SQL

    • PL/SQL is an extension of SQL used in Oracle databases

  • Answered by AI

Skills evaluated in this interview

I applied via Approached by Company and was interviewed in Mar 2022. There were 3 interview rounds.

Round 1 - One-on-one 

(3 Questions)

  • Q1. What is a cursor. And its types
  • Ans. 

    A cursor is a database object used to retrieve data from a result set one row at a time.

    • Types of cursors: Implicit, Explicit, Ref, and Dynamic

    • Implicit cursor is used for single row queries

    • Explicit cursor is used for multi-row queries

    • Ref cursor is used to point to a cursor variable

    • Dynamic cursor is used to execute dynamic SQL statements

  • Answered by AI
  • Q2. Functions and procedures
  • Q3. Triggers and its types and syntax
  • Ans. 

    Explanation of triggers and their types in PL/SQL

    • Triggers are database objects that are automatically executed in response to certain events

    • Types of triggers include DML, DDL, and system triggers

    • Syntax for creating a trigger: CREATE [OR REPLACE] TRIGGER trigger_name {BEFORE|AFTER} {INSERT|UPDATE|DELETE} ON table_name [FOR EACH ROW] [WHEN condition] BEGIN ... END;

  • Answered by AI
Round 2 - One-on-one 

(1 Question)

  • Q1. What is SQL optimization. Normalization. Pragma usage
  • Ans. 

    SQL optimization, normalization, and pragma usage are important concepts in PL/SQL development.

    • SQL optimization involves improving the performance of SQL queries by analyzing and modifying the query structure, indexes, and data access patterns.

    • Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

    • Pragma is a compiler directive that provides additional information ...

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion, asked about having any other offer in hand

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up SQL queries and procedures, function, triggers

Skills evaluated in this interview

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

Tech Mahindra Interview FAQs

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

Some of the top questions asked at the Tech Mahindra Plsql Developer interview -

  1. Factorial of a num...read more
  2. Modelling of sch...read more
  3. Sql queries including 2nd highest salary and table jo...read more

Recently Viewed

SALARIES

Quintessence

Junior Executive, Coimbatore

unlock blur L/yr (AmbitionBox Estimate)

(1 salary)

SALARIES

Rico Auto Industries

Production Engineer Incharge

unlock blur L/yr

(3 salaries)

SALARIES

Longspan Structures

Senior Engineer, Pune

unlock blur L/yr (AmbitionBox Estimate)

(1 salary)

COMPANY BENEFITS

VERSETAL TECH SOLUTIONS

Vmware Consultant

1 benefit

REVIEWS

Reliance Communications

No Reviews

SALARIES

Inflow Technologies

SALARIES

Tech Mahindra

LIST OF COMPANIES

Uniinfo Telecom Services

Overview

REVIEWS

Uniinfo Telecom Services

No Reviews

COMPANY BENEFITS

Tech Mahindra

No Benefits

Tell us how to improve this page.

Tech Mahindra Plsql Developer Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Anonymously discuss salaries, work culture, and many more

Get Ambitionbox App

Tech Mahindra Plsql Developer Salary
based on 339 salaries
₹2 L/yr - ₹9.7 L/yr
At par with the average Plsql Developer Salary in India
View more details

Tech Mahindra Plsql Developer Reviews and Ratings

based on 14 reviews

3.3/5

Rating in categories

3.3

Skill development

3.0

Work-life balance

3.0

Salary

3.5

Job security

3.2

Company culture

3.0

Promotions

2.9

Work satisfaction

Explore 14 Reviews and Ratings
oracle PL/SQL Developer

Pune

8-13 Yrs

Not Disclosed

Explore more jobs
Software Engineer
26.3k salaries
unlock blur

₹2 L/yr - ₹9.3 L/yr

Senior Software Engineer
21.4k salaries
unlock blur

₹5.5 L/yr - ₹23 L/yr

Technical Lead
11.7k salaries
unlock blur

₹9.5 L/yr - ₹32 L/yr

Associate Software Engineer
5.5k salaries
unlock blur

₹1.8 L/yr - ₹8.2 L/yr

Team Lead
5k salaries
unlock blur

₹5.2 L/yr - ₹17 L/yr

Explore more salaries
Compare Tech Mahindra with

Infosys

3.6
Compare

Cognizant

3.7
Compare

Accenture

3.8
Compare

Wipro

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