AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Expleo Group
Compare
Filter interviews by
Expleo Group Plsql Developer Interview Questions and Answers
Expleo Group Plsql Developer Interview Experiences
1 interview found
Selected
I applied via Naukri.com and was interviewed in Oct 2022. There were 2 interview rounds.
(2 Questions)
- Q1. Difference between sql and plsql
- Ans.
SQL is used to manage relational databases while PL/SQL is used to create procedures, functions, and triggers.
SQL is used to retrieve and manipulate data in a database.
PL/SQL is used to create stored procedures, functions, and triggers.
SQL is a declarative language while PL/SQL is a procedural language.
SQL is used to query data while PL/SQL is used to write code that can be executed.
SQL is used to create and modify tab...
- Q2. Difference between drop and truncate
- Ans.
Drop deletes the table and its structure while truncate deletes all the data in the table.
Drop is a DDL command while truncate is a DML command.
Drop cannot be rolled back while truncate can be rolled back using the undo tablespace.
Drop is slower than truncate as it deletes the table structure while truncate only deletes the data.
Drop can be used to delete views, sequences, and other database objects while truncate can ...
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
(4 Questions)
- Q1. How do you optimize Stored procedure
- Ans.
Optimizing stored procedures involves using proper indexing, reducing unnecessary loops, and minimizing database calls.
Use proper indexing on columns used in WHERE clauses to improve query performance
Avoid using cursors and loops whenever possible, as they can be inefficient
Minimize the number of database calls by combining multiple queries into a single query or using temporary tables
Consider using bulk processing tec...
- Q2. How do you optimize SQL query
- Ans.
Optimizing SQL queries involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing query structure.
Use indexes on columns frequently used in WHERE clauses
Minimize data retrieval by selecting only necessary columns
Avoid unnecessary joins by using EXISTS or IN clauses instead
Optimize query structure by using appropriate join types and conditions
- Q3. What is use of returning clause
- Ans.
Returning clause is used to return a value from a function or procedure in PL/SQL.
Used to return a single value from a function or procedure
Can be used to return multiple values using OUT parameters
Helps in passing values back to the calling program
- Q4. Disadvantages of triggers
- Ans.
Triggers can lead to performance issues, complexity, and potential for unintended consequences.
Triggers can make code harder to debug and maintain
They can lead to cascading effects if not carefully implemented
Performance can be impacted if triggers are not optimized
Triggers can introduce dependencies between different parts of the codebase
Skills evaluated in this interview
Shreeya
Interview Questionnaire
7 Questions
- Q1. Tell me about yourself?
- Ans.
I am a software developer with experience in Java and Python.
I have a Bachelor's degree in Computer Science.
I have worked on various projects involving web development and data analysis.
I am proficient in Java and Python programming languages.
I am a quick learner and enjoy working in a team environment.
- Q2. Do you know anything about DBMS? Where is it used?
- Ans.
DBMS stands for Database Management System. It is used to manage and organize data in a structured manner.
DBMS is used in various industries such as healthcare, finance, education, and more.
It helps in creating, modifying, and deleting data in a database.
DBMS provides security features to protect data from unauthorized access.
Examples of DBMS include MySQL, Oracle, Microsoft SQL Server, and PostgreSQL.
- Q3. Practical example of object
- Ans.
An object is a self-contained entity that contains data and behavior.
Objects are instances of classes
They have attributes (data) and methods (behavior)
Objects can interact with each other through method calls
Example: A car object has attributes like color, make, and model, and methods like start and stop
- Q4. Practical implementation of sorting
- Ans.
Sorting is the process of arranging data in a particular order.
Sorting can be done in ascending or descending order.
Common sorting algorithms include bubble sort, insertion sort, and quicksort.
Sorting can be done on various data types, including strings, numbers, and objects.
Sorting can be done using built-in functions in programming languages such as sort() in JavaScript.
Sorting can be optimized for performance by cho...
- Q5. Difference between C and C++
- Ans.
C is a procedural programming language while C++ is an object-oriented programming language.
C++ supports classes and objects while C does not.
C++ has better support for polymorphism and inheritance than C.
C++ has a larger standard library than C.
C++ allows function overloading while C does not.
C++ supports exception handling while C does not.
- Q6. Tell me about yourself
- Ans.
I am a software developer with experience in Java and Python. I am passionate about coding and always eager to learn new technologies.
Experienced in Java and Python
Passionate about coding
Eager to learn new technologies
- Q7. Will your family allow you to move to Hyderabad
- Ans.
Yes, my family is supportive of my career and relocation decisions.
My family understands the importance of career growth and is supportive of my decisions.
We have discussed the possibility of relocation and they are willing to make the necessary adjustments.
They trust my judgment and believe that this move will be beneficial for my career.
We have also considered the quality of life in Hyderabad and believe that it will...
Interview Preparation Tips
Experience: Level was pretty high in case of Quant. You not only need a lot of practice but also practice of some really good questions.
Other than quant all the other sections are easy and direct.
Duration: 60 minutes
Total Questions: 45
Round: Group Discussion
Experience: They give 10 mins to think about the topic and 20 mins for discussion. Main purpose is to check your communication skills so keep on discussing . Even if you can't think of any new point repeat your points
Duration: 20 minutes
Round: Technical Interview
Experience: There were many other questions other than this but what they were emphasizing was whether you have done any practical implementation of IT or the coding skills. Tell them about your projects and how you implemented the coding part.They are much interested in logic than syntax.
Since I'm from ECE these were the main things I talked about.
Round: HR Interview
Experience: It was much of an interactive session.They again asked about projects-nothing technical only some basic idea. Lasted hardly 10 mins.
Round: Other Interview
Experience: In this round they mainly explained the salary structure. This one too was of 10 mins.
General Tips: Even if you don't have excellent coding knowledge do appear for the company. They are not looking for same qualities in each candidate. You should be willing enough to learn.
Skills: Aptitude, Communication Skills, Basic Technical Knowledge-mainly emphasized on the implementation part.
College Name: NIT Bhopal
Motivation: The company dates back to 1983 with locations in almost every US state. It is the 43rd company in Fortune 100 US companies. You have options to switch within the departments. Other than this the compensation is 6lpa.
Skills evaluated in this interview
Interview Questionnaire
1 Question
- Q1. Exam was conducted on programmes. 10 questions were asked
Software Developer Interview Questions & Answers
Collabera Technologies
Anonymous
posted on 3 Feb 2021
Interview Questionnaire
1 Question
- Q1. Interview questions on .net technology
Selected
I appeared for an interview before Dec 2023.
Such a nice experience
Such a nice experience
(1 Question)
- Q1. Covered LinkedLists and Trees
(1 Question)
- Q1. Cultural Assessment Round
Interview Preparation Tips
Selected
I appeared for an interview in Jan 2025.
Test will be in hacker rank there would be a difficulty level between easy to medium
(1 Question)
- Q1. Question will be from data structure and easy to medium level of the programming laanguage question
(1 Question)
- Q1. This is just to check your english ability
Selected
I applied via LinkedIn
(2 Questions)
- Q1. Java Based question answers
- Q2. Array traversal problem
- Ans.
Traverse an array of strings
Use a loop to iterate through each element in the array
Access each element using its index
Perform any necessary operations on each element
Skills evaluated in this interview
Selected
I applied via Campus Placement and was interviewed in Nov 2024. There were 3 interview rounds.
Logical reasoning, grammar, and coding: two basic level questions.
(3 Questions)
- Q1. Question on core Java
- Q2. Question on SQL and PLSQL
- Q3. Resume based question and on project
(2 Questions)
- Q1. Resume and project based question
- Q2. What do you like about your current company, and why do you want to join our organization?
- Ans.
I appreciate the collaborative team environment and innovative projects at my current company, and I am excited about the opportunities for growth and learning at your organization.
Collaborative team environment fosters creativity and productivity
Innovative projects challenge me to learn and grow
Excited about the opportunities for growth and learning at your organization
Selected
I applied via Naukri.com and was interviewed before May 2023. There was 1 interview round.
It was good. Mostly questions on spark
Expleo Group Interview FAQs
Tell us how to improve this page.
Expleo Group Interviews By Designations
- Expleo Group Associate Software Engineer Interview Questions
- Expleo Group QA Associate Interview Questions
- Expleo Group Software Developer Interview Questions
- Expleo Group Graduate Engineer Trainee (Get) Interview Questions
- Expleo Group Java Developer Interview Questions
- Expleo Group Solution Architect Interview Questions
- Expleo Group Data Scientist Interview Questions
- Expleo Group Senior Engineer 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
Expleo Group Plsql Developer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Software Engineer
656
salaries
|  ₹2.4 L/yr - ₹10.2 L/yr |
|
Senior Software Engineer
426
salaries
| ₹4.6 L/yr - ₹14 L/yr |
|
Softwaretest Engineer
255
salaries
| ₹3 L/yr - ₹9.5 L/yr |
|
Associate Software Engineer
185
salaries
| ₹3 L/yr - ₹5.8 L/yr |
|
QA Associate
138
salaries
| ₹2.4 L/yr - ₹6.5 L/yr |
ITC Infotech
HTC Global Services
Unisys
Tietoevry
- Home >
- Interviews >
- Expleo Group Interview Questions >
- Expleo Group Plsql Developer Interview Questions
