Upload Button Icon Add office photos

Filter interviews by

Abacus Civilian School Plsql Developer Interview Questions and Answers

Be the first one to contribute and help others!

Interview questions from similar companies

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

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
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
Round 1 - Technical 

(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
Round 2 - HR 

(1 Question)

  • Q1. After 30 days.. Do u have any other offer in hand? How much they offered

Interview Preparation Tips

Interview preparation tips for other job seekers - After 30 days after n number of follow up mail
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.
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 tips
Round 2 - Technical 

(1 Question)

  • Q1. Plsql and Oracle SQL
Round 3 - HR 

(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

Interview preparation tips for other job seekers - We have to be confidence while answering.they are checking ur ability
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.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

It is little bit easy

Round 2 - Coding Test 

2 coding question in python

I applied via LinkedIn and was interviewed in May 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 tips
Round 2 - Technical 

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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Basic sql queries and questions are asked like views, stored procedures and triggers and subqieries and functions

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

Tell us how to improve this page.

Compare Abacus Civilian School with

TCS

3.7
Compare

Accenture

3.8
Compare

Wipro

3.7
Compare

Cognizant

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