Upload Button Icon Add office photos

Accenture

Compare button icon Compare button icon Compare

Filter interviews by

Accenture Plsql Developer Interview Questions, Process, and Tips

Updated 22 Nov 2024

Top Accenture Plsql Developer Interview Questions and Answers

View all 10 questions

Accenture Plsql Developer Interview Experiences

5 interviews found

Interview experience
4
Good
Difficulty level
Easy
Process Duration
-
Result
-

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

Round 1 - Technical 

(6 Questions)

  • Q1. What is view? Can we update in view?
  • Ans. 

    A view is a virtual table created by a query. It does not store data itself but displays data from one or more tables. Views can be used for querying data as if it were a table.

    • Views are created using a SELECT statement with optional joins, WHERE clauses, etc.

    • Views can simplify complex queries by pre-defining joins and filters.

    • Views do not store data themselves, they display data from underlying tables.

    • Views can be upd...

  • Answered by AI
  • Q2. What is synonym?
  • Ans. 

    A synonym is an alternative name for a table, view, sequence, or other database object.

    • Synonyms can be used to provide a different name for an object, making it easier to reference.

    • They can be created to reference objects in other schemas or databases.

    • Synonyms can be public (accessible to all users) or private (accessible only to the creator).

  • Answered by AI
  • Q3. What is sequence
  • Ans. 

    A sequence is a database object in Oracle that generates unique numbers in a specified order.

    • Used to generate unique numbers for primary key columns

    • Can be used in INSERT statements to automatically generate values

    • Can be defined to increment by a specific value and start at a specific number

  • Answered by AI
  • Q4. What is procedures?
  • Ans. 

    Procedures are named PL/SQL blocks that perform a specific task. They can accept parameters and return values.

    • Procedures are stored in the database and can be called by other PL/SQL blocks or applications.

    • They can accept input parameters to perform operations and can also return output values.

    • Procedures help in modularizing code and promoting reusability.

    • Example: CREATE PROCEDURE calculate_salary (emp_id IN NUMBER) IS

  • Answered by AI
  • Q5. What is difference between procedure and functions
  • Ans. 

    Procedures do not return any value while functions return a value.

    • Procedures are used to perform an action, while functions are used to calculate and return a value.

    • Procedures do not have a return statement, while functions must have a return statement.

    • Functions can be called from SQL queries, while procedures cannot be called directly in SQL queries.

  • Answered by AI
  • Q6. What is partitions?
  • Ans. 

    Partitions in PL/SQL are used to divide a table into smaller, more manageable pieces.

    • Partitions help improve query performance by allowing data to be stored in separate segments based on a specified criteria.

    • Common partitioning methods include range, hash, list, and composite partitioning.

    • Example: Partitioning a sales table by month can improve query performance when searching for sales data within a specific time fram

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Stored procedures

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
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is plsql and different from sql
  • Ans. 

    PL/SQL is a procedural extension of SQL used for writing stored procedures, functions, triggers, and packages in Oracle databases.

    • PL/SQL allows for procedural programming, including loops, conditions, and exception handling.

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

    • PL/SQL code is executed on the server side, while SQL queries are executed on the client side.

    • PL/SQL can be used to...

  • Answered by AI
  • Q2. What is performance tuning
  • Ans. 

    Performance tuning is the process of optimizing the speed and efficiency of a database system.

    • Identifying and resolving bottlenecks in the database system

    • Optimizing SQL queries for better performance

    • Improving indexing and partitioning strategies

    • Monitoring and analyzing system performance metrics

    • Utilizing tools like explain plan and SQL tuning advisor

    • Implementing caching mechanisms to reduce data retrieval time

  • Answered by AI

Skills evaluated in this interview

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

(2 Questions)

  • Q1. Basics of pl sql like cursor, triggers, sequences
  • Q2. Performance tuning, basic queries on situations
Round 3 - HR 

(1 Question)

  • Q1. Just a discussion with HR

Interview Preparation Tips

Topics to prepare for Accenture Plsql Developer interview:
  • PLSQL
Interview preparation tips for other job seekers - Just prepare for everything that u worked on, the interview will be easy

Accenture interview questions for designations

 Developer

 (9)

 Application Developer

 (258)

 Software Developer

 (237)

 Java Developer

 (51)

 Salesforce Developer

 (37)

 Web Developer

 (16)

 Senior Developer

 (10)

 Python Developer

 (8)

Plsql Developer Interview Questions & Answers

user image Ravichandran S

posted on 4 Jul 2022

I applied via Naukri.com and was interviewed before Jul 2021. There were 2 interview rounds.

Round 1 - Technical 

(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

  • Answered by AI
Round 2 - Technical 

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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Need to focus query writing
Stored procedures...and do some practical coding in tools like SQL developer and isqlplus version 11G and more..

Get interview-ready with Top Accenture Interview Questions

Interview questions from similar companies

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

I was interviewed in Jan 2025.

Round 1 - Technical 

(14 Questions)

  • Q1. Queries on joins using inner join, left join, right join, outer join
  • Q2. What are the definitions of case and decode, what are the differences between them, and can you explain the logic for each?
  • Ans. 

    Case and decode are conditional expressions in PL/SQL used for data manipulation.

    • CASE is used for conditional logic in SQL statements, while DECODE is used for conditional logic in SELECT statements.

    • CASE is more flexible and can handle multiple conditions, while DECODE is limited to one condition.

    • CASE can be used in both SQL and PL/SQL, while DECODE is specific to SQL.

    • Example of CASE: SELECT CASE WHEN condition1 THEN r...

  • Answered by AI
  • Q3. What are the primary key and foreign key in database design, and can you provide examples of each?
  • Ans. 

    Primary key uniquely identifies each record in a table, while foreign key establishes a link between two tables.

    • Primary key ensures uniqueness and cannot have null values

    • Foreign key establishes a relationship between tables based on the primary key of another table

    • Example of primary key: EmployeeID in an Employee table

    • Example of foreign key: DepartmentID in an Employee table linking to DepartmentID in a Department tabl

  • Answered by AI
  • Q4. What are the differences between Rank and Dense Rank in SQL?
  • Ans. 

    Rank assigns unique ranks to each distinct row, while Dense Rank assigns consecutive ranks without gaps.

    • Rank may have gaps in the ranking sequence, while Dense Rank does not.

    • Rank assigns the same rank to rows with the same values, while Dense Rank assigns different ranks.

    • Rank function is non-consecutive, while Dense Rank function is consecutive.

  • Answered by AI
  • Q5. What is the difference between procedures and functions?
  • Ans. 

    Procedures are used to perform an action, while functions return a value.

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

    • Functions can be called from SQL queries, while procedures cannot.

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

  • Answered by AI
  • Q6. Is it possible to use a package body without a package specification?
  • Ans. 

    No, a package body cannot be used without a package specification.

    • A package body must always be associated with a package specification.

    • The package specification defines the public interface of the package, while the package body contains the implementation details.

    • Attempting to use a package body without a corresponding package specification will result in compilation errors.

  • Answered by AI
  • Q7. What is a SQL query that can be used to find duplicate values in a database?
  • Ans. 

    Use a SQL query with GROUP BY and HAVING clause to find duplicate values in a database.

    • Use GROUP BY clause to group the values that are duplicated.

    • Use HAVING clause to filter out the groups that have more than one occurrence.

    • Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;

  • Answered by AI
  • Q8. Queries using group by and having clause
  • Ans. 

    Group by and having clause are used together to filter groups based on specified conditions.

    • Group by clause is used to group rows that have the same values into summary rows.

    • Having clause is used to filter groups based on specified conditions.

    • Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 5000;

  • Answered by AI
  • Q9. What are the definitions of the Substr and Instr functions?
  • Ans. 

    Substr function extracts a substring from a string, while Instr function returns the position of a substring within a string.

    • Substr function syntax: SUBSTR(string, start_position, length)

    • Example: SUBSTR('Hello World', 7, 5) will return 'World'

    • Instr function syntax: INSTR(string, substring)

    • Example: INSTR('Hello World', 'World') will return 7

  • Answered by AI
  • Q10. What is the process for writing a SQL query that includes a subquery?
  • Ans. 

    Writing a SQL query with a subquery involves nesting one query inside another to retrieve specific data.

    • Start by writing the main query that will retrieve the primary data

    • Identify the criteria for the subquery to filter the results

    • Enclose the subquery within parentheses and use it in the WHERE or FROM clause of the main query

    • Ensure that the subquery returns a single value or a single column result

  • Answered by AI
  • Q11. What is the difference between char, varchar, and varchar2 data types?
  • Ans. 

    Char is fixed length, varchar is variable length with max 4000 bytes, varchar2 is variable length with max 32767 bytes.

    • Char is fixed length and always right-padded with spaces, while varchar and varchar2 are variable length.

    • Varchar can store up to 4000 bytes of data, while varchar2 can store up to 32767 bytes.

    • Char is less efficient in terms of storage compared to varchar and varchar2.

  • Answered by AI
  • Q12. Queries using Trunc and round
  • Q13. Is it possible to combine two tables with differing data and columns without utilizing joins?
  • Ans. 

    No, it is not possible to combine two tables with differing data and columns without utilizing joins.

    • Joins are necessary to combine tables based on a common column or key.

    • Different data and columns require a join to match and merge the data properly.

    • Examples of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

  • Answered by AI
  • Q14. Is it possible to update data in a view?
  • Ans. 

    Yes, it is possible to update data in a view using INSTEAD OF triggers.

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

    • By using INSTEAD OF triggers, you can update data in a view by specifying the logic to handle the update operation.

    • The trigger intercepts the update operation on the view and executes the specified logic to update the underlying tables.

    • For example, you can create an INSTEAD OF trigge...

  • Answered by AI
Round 2 - Behavioral 

(6 Questions)

  • Q1. Can you describe yourself and provide details about your project, including the brief questions that were asked about it?
  • Q2. Why TCS?
  • Ans. 

    TCS is a global IT services company known for its innovative solutions and commitment to employee growth.

    • TCS has a strong reputation in the IT industry for delivering high-quality services.

    • TCS offers opportunities for professional growth and development through training programs and career advancement.

    • TCS has a diverse and inclusive work culture that values teamwork and collaboration.

  • Answered by AI
  • Q3. What is a dynamic cursor in database management?
  • Ans. 

    A dynamic cursor in database management allows for the execution of different SQL queries at runtime.

    • Dynamic cursors are used when the SQL query to be executed is not known until runtime.

    • They allow for flexibility in querying the database based on user input or other conditions.

    • Dynamic cursors can be used to handle varying result sets or conditions in a more efficient manner.

    • Example: Using a dynamic cursor to search fo...

  • Answered by AI
  • Q4. Did you perform performance tuning, and if so, what steps did you take?
  • Ans. 

    Yes, I have performed performance tuning by identifying bottlenecks and optimizing queries.

    • Identified slow queries using tools like SQL Trace, Explain Plan, and AWR reports.

    • Optimized queries by adding indexes, rewriting SQL statements, and reducing unnecessary data retrieval.

    • Tuned PL/SQL code by using bulk processing, minimizing context switches, and optimizing loops.

    • Utilized database features like partitioning and mat

  • Answered by AI
  • Q5. What is the definition of a package, and is it possible to use a package body without a package specification?
  • Ans. 

    A package in PL/SQL is a collection of related procedures, functions, variables, and other constructs.

    • A package consists of two parts: package specification and package body.

    • The package specification defines the public interface of the package, including declarations of variables, constants, cursors, procedures, and functions.

    • The package body contains the actual implementation of the procedures and functions declared i...

  • Answered by AI
  • Q6. I got more questions from my project related
Round 3 - HR 

(6 Questions)

  • Q1. What are your reasons for wanting to join TCS?
  • Ans. 

    I am excited about the opportunity to work with a global leader like TCS and contribute to innovative projects.

    • TCS is a renowned global company with a strong reputation in the IT industry

    • I am impressed by TCS's commitment to innovation and cutting-edge technology

    • I believe TCS offers great opportunities for professional growth and development

    • I am excited about the chance to work on diverse and challenging projects at TC

  • Answered by AI
  • Q2. What is your current salary package?
  • Ans. 

    I prefer to discuss my salary expectations based on the responsibilities and requirements of the position.

    • Focus on discussing salary expectations based on the job responsibilities and requirements.

    • Avoid disclosing specific current salary package.

    • Emphasize the importance of fair compensation based on market rates and skills.

    • Provide examples of successful projects or achievements that demonstrate your value.

    • Discuss oppor...

  • Answered by AI
  • Q3. What is your expected salary package?
  • Ans. 

    I am looking for a competitive salary package based on my experience and skills.

    • I am open to discussing salary based on the responsibilities and requirements of the role.

    • I have researched the average salary range for Plsql Developers in this location.

    • I am looking for a package that includes benefits such as healthcare, retirement plans, and professional development opportunities.

  • Answered by AI
  • Q4. Are you comfortable with shift work?
  • Ans. 

    Yes, I am comfortable with shift work and have experience working various shifts.

    • I have previous experience working different shifts in my current/previous roles.

    • I am flexible with my schedule and can easily adapt to changing shift patterns.

    • I understand the importance of shift work in ensuring 24/7 coverage for critical systems.

  • Answered by AI
  • Q5. Are you ok with any location
  • Ans. 

    Yes, I am open to any location for the Plsql Developer position.

    • I am willing to relocate for the right opportunity

    • I am open to working in different cities or countries

    • I am flexible with travel requirements for the job

  • Answered by AI
  • Q6. Holding any other offers in hand
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Nov 2024.

Round 1 - Technical 

(4 Questions)

  • Q1. Types of partition in sql
  • Q2. Can we edit data in complex views, will the underlying table be effected?
  • Q3. How do you do performance tuning?
  • Q4. Tell about regex
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 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 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
-
Result
Not Selected

I applied via Naukri.com and was interviewed in Aug 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - HR 

(1 Question)

  • Q1. Experience,ctc,expected ctc
Round 3 - Technical 

(1 Question)

  • Q1. Plsql concepts , procedure , functions
Round 4 - Technical 

(1 Question)

  • Q1. Plsql advance concepts, procedure , function

Accenture Interview FAQs

How many rounds are there in Accenture Plsql Developer interview?
Accenture interview process usually has 1-2 rounds. The most common rounds in the Accenture interview process are Technical, Resume Shortlist and HR.
What are the top questions asked in Accenture Plsql Developer interview?

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

  1. Explain stored procedure and PLSQL concept in deta...read more
  2. What is difference between procedure and functi...read more
  3. What is performing tuni...read more

Tell us how to improve this page.

Accenture Plsql Developer Interview Process

based on 4 interviews

1 Interview rounds

  • Technical Round
View more
Accenture Plsql Developer Salary
based on 337 salaries
₹3 L/yr - ₹11.4 L/yr
7% more than the average Plsql Developer Salary in India
View more details

Accenture Plsql Developer Reviews and Ratings

based on 10 reviews

4.2/5

Rating in categories

3.6

Skill development

3.7

Work-life balance

3.8

Salary

3.8

Job security

4.0

Company culture

3.5

Promotions

3.4

Work satisfaction

Explore 10 Reviews and Ratings
Application Development Analyst
38.9k salaries
unlock blur

₹3 L/yr - ₹12 L/yr

Application Development - Senior Analyst
26.9k salaries
unlock blur

₹6.9 L/yr - ₹20.2 L/yr

Team Lead
24.3k salaries
unlock blur

₹7.1 L/yr - ₹25.5 L/yr

Senior Software Engineer
18.2k salaries
unlock blur

₹6 L/yr - ₹19.5 L/yr

Software Engineer
17.4k salaries
unlock blur

₹3.6 L/yr - ₹13.4 L/yr

Explore more salaries
Compare Accenture with

TCS

3.7
Compare

Cognizant

3.8
Compare

Capgemini

3.7
Compare

Infosys

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