AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
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
Anonymous
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
Suvham Das
(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.
- Q2. Sql queries including 2nd highest salary and table joins
(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
Interview Preparation Tips
1 DSA prime no
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in May 2021. There were 3 interview rounds.
Interview Questionnaire
10 Questions
- Q1. Oracle instance architecture
- Q2. Redo log buffer
- Q3. Difference between Procedure and function
- Ans.
Procedures and functions are both PL/SQL program units, but they have some key differences.
Procedures do not return a value, while functions do.
Procedures can have OUT parameters to pass values back to the caller, while functions cannot.
Functions can be used in SQL statements, while procedures cannot.
Functions must return a value, while procedures do not necessarily have to.
Procedures are typically used for performing ...
- Q4. Difference between implicit and explicit cursor
- Ans.
Implicit cursors are automatically created by the Oracle server, while explicit cursors are explicitly declared by the programmer.
Implicit cursors are used for single-row queries, while explicit cursors are used for multi-row queries.
Implicit cursors are automatically opened, fetched, and closed by the Oracle server, while explicit cursors need to be manually opened, fetched, and closed by the programmer.
Implicit curso...
- Q5. Difference between soft parsing and hard parsing of sql
- Ans.
Soft parsing is reusing the existing execution plan while hard parsing is generating a new execution plan.
Soft parsing is faster as it avoids the overhead of generating a new execution plan.
Hard parsing is slower as it involves generating a new execution plan.
Soft parsing occurs when the SQL statement is already in the shared pool.
Hard parsing occurs when the SQL statement is not in the shared pool or needs a new execu...
- Q6. Difference between rdbms and dbms
- Ans.
RDBMS is a type of DBMS that stores data in a structured manner using tables with relationships.
DBMS is a software system that manages data stored in a computer's memory or disk storage.
RDBMS is a type of DBMS that uses a relational model to store data in tables with relationships.
RDBMS supports ACID properties (Atomicity, Consistency, Isolation, Durability) for data integrity.
Examples of RDBMS include Oracle, MySQL, S...
- Q7. Write a sql to find nth highest salary
- Ans.
SQL query to find the nth highest salary
Use the ORDER BY clause to sort the salaries in descending order
Use the LIMIT clause to select the nth highest salary
- Q8. Write a sql to delete duplicate records from a table
- Ans.
SQL query to delete duplicate records from a table.
Use the DELETE statement with a subquery to identify and delete duplicate records.
The subquery should select the duplicate records based on the criteria for duplication.
Ensure to keep at least one copy of the duplicate records to avoid deleting all instances.
- Q9. Difference between delete and truncate
- Ans.
Delete is a DML operation that removes specific rows from a table, while truncate is a DDL operation that removes all rows from a table.
Delete is slower than truncate as it generates undo logs and triggers
Delete can be rolled back, while truncate cannot be rolled back
Delete operation maintains the integrity of the transaction log, while truncate operation does not
Delete operation fires delete triggers, while truncate o...
- Q10. Scenario based questions on exceptions in plsql
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Jun 2022. There were 2 interview rounds.
(2 Questions)
- Q1. Triggers , procedures , exception handling , collections, package
- Q2. Type , array, partition, performance tuning, AWR
Interview Preparation Tips
Interview Questionnaire
2 Questions
- Q1. Index , collection, partition, package, pragma autonomous transaction
- Q2. Answer confidently
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
I applied via Approached by Company and was interviewed in Sep 2023. There were 3 interview rounds.
(1 Question)
- Q1. Window Functions in SQL
- Ans.
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
Window functions are used to calculate values based on a set of rows related to the current row.
They allow you to perform calculations without grouping the rows into a single output row.
Examples of window functions include ROW_NUMBER(), RANK(), and LAG().
(1 Question)
- Q1. Uses of Packages in PL/SQL
- Ans.
Packages in PL/SQL are used to group related procedures, functions, variables, and other PL/SQL constructs together for better organization and security.
Packages help in modularizing code for easier maintenance and debugging
They provide encapsulation and hide implementation details
Packages can contain multiple procedures, functions, variables, cursors, and exceptions
They improve performance by reducing network traffic
E...
Skills evaluated in this interview
(1 Question)
- Q1. Plsql and Oracle SQL
(1 Question)
- Q1. Discussion for salary
manasa dasari
I applied via Referral and was interviewed before Jun 2023. There was 1 interview round.
Oracle pl sql developer
Interview Preparation Tips
(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
Tell us how to improve this page.
Interview Questions for Popular Designations
- Oracle SQL and PLSQL Developer Interview Questions
- Senior 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
Plsql Developer Interview Questions from Similar Companies
TCS
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- Abacus Civilian School Interview Questions >
- Abacus Civilian School Plsql Developer Interview Questions
