AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
LTIMindtree
Compare
Filter interviews by
LTIMindtree Plsql Developer Interview Questions and Answers
LTIMindtree Plsql Developer Interview Experiences
1 interview found
Anonymous
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
(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
- 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
Interview questions from similar companies
I applied via Naukri.com and was interviewed before Jul 2021. There were 2 interview rounds.
(1 Question)
- Q1. What is performing tuning?
- Ans.
Performance tuning is the process of optimizing the performance of a system or application.
Identifying and resolving performance bottlenecks
Optimizing database queries and indexes
Improving hardware and network configurations
Reducing resource usage and improving response time
Monitoring and analyzing system performance
(1 Question)
- Q1. Explain stored procedure and PLSQL concept in detail?
- Ans.
Stored procedure is a precompiled program that is stored in a database and can be called by other programs.
Stored procedures are used to encapsulate business logic and improve performance.
PL/SQL is a procedural language used to write stored procedures in Oracle databases.
Stored procedures can accept input parameters and return output parameters or result sets.
They can also be used to enforce security and data integrity...
Interview Preparation Tips
Stored procedures...and do some practical coding in tools like SQL developer and isqlplus version 11G and more..
Interview Questionnaire
2 Questions
- Q1. They have only one phone interview
- Q2. They asking about full sql and plsql
Interview Preparation Tips
Experience: Detailed description of explaination full topics
Imaya Valli
(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...
(1 Question)
- Q1. Waiting for round 1 results
(3 Questions)
- Q1. SQL queries, joins, views, functions , advanced functions, exceptions.. Lot of Scenario based question
- Q2. About resume and past experiences
- Q3. Interview happened almost 1hr
(1 Question)
- Q1. After 30 days.. Do u have any other offer in hand? How much they offered
Interview Preparation Tips
Hr discussion happened. Which was surprising one. The package they offfered is very less for an experienced candidate .. It doesn't even have 20%hike from current salary.
(1 Question)
- Q1. Plsql and Oracle SQL
(1 Question)
- Q1. Discussion for salary
I applied via Naukri.com and was interviewed in Nov 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Procedure, function, bulk collect,
Interview Preparation Tips
Selected
I applied via Recruitment Consulltant and was interviewed before Apr 2023. There was 1 interview round.
(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.
uma devi
It is little bit easy
2 coding question in python
I applied via LinkedIn and was interviewed in May 2022. There were 2 interview rounds.
(2 Questions)
- Q1. Views and triggers basics
- Q2. Learning capabilities of new softwares
- Ans.
I have a strong ability to learn new software quickly.
I am a self-motivated learner and enjoy exploring new technologies.
I am comfortable with online tutorials, documentation, and experimenting with new software.
I have experience learning new software such as Oracle SQL Developer, Toad, and PL/SQL Developer.
I am able to adapt to new software quickly and efficiently.
Interview Preparation Tips
LTIMindtree Interview FAQs
Tell us how to improve this page.
LTIMindtree Interviews By Designations
- LTIMindtree Software Engineer Interview Questions
- LTIMindtree Senior Software Engineer Interview Questions
- LTIMindtree Software Developer Interview Questions
- LTIMindtree Senior Specialist Interview Questions
- LTIMindtree Graduate Engineer Trainee (Get) Interview Questions
- LTIMindtree Module Lead Interview Questions
- LTIMindtree Graduate Engineer Interview Questions
- LTIMindtree Graduate Trainee Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Plsql Developer Interview Questions
- Oracle SQL and PLSQL Developer Interview Questions
- Front end Developer Interview Questions
- Web Developer Interview Questions
- Software Developer Intern Interview Questions
- Backend Developer Interview Questions
- Junior Software Developer Interview Questions
- Full Stack Software Developer Interview Questions
- Show more
LTIMindtree Plsql Developer Interview Process
based on 1 interview
Interview experience
Plsql Developer Interview Questions from Similar Companies
Fast track your campus placements
LTIMindtree Plsql Developer Reviews and Ratings
based on 3 reviews
Rating in categories
|
Senior Software Engineer
21.5k
salaries
|  ₹5 L/yr - ₹19.1 L/yr |
|
Software Engineer
16.2k
salaries
| ₹2 L/yr - ₹10 L/yr |
|
Technical Lead
6.4k
salaries
| ₹9.4 L/yr - ₹36 L/yr |
|
Module Lead
5.9k
salaries
| ₹7 L/yr - ₹25.5 L/yr |
|
Senior Engineer
4.4k
salaries
| ₹4.2 L/yr - ₹16.8 L/yr |
Cognizant
Capgemini
Accenture
TCS
- Home >
- Interviews >
- LTIMindtree Interview Questions >
- LTIMindtree Plsql Developer Interview Questions
