CGI Group Plsql Developer Interview Questions and Answers

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...read more
Answered by AI
Add your answer
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
Add your answer
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
Add your answer
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
Add your answer
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
Add your answer
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
Add your answer

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...read more
Add your answer

Q1. Waiting for round 1 results
Add your answer

It is little bit easy

2 coding question in python

Q1. Triggers , procedures , exception handling , collections, package
Add your answer
Q2. Type , array, partition, performance tuning, AWR
Add your answer

Q1. Stored procedures
Add your answer

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.
Add your answer

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...read more
Answered by AI
Add your answer
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
Add your answer