PL/SQL Interview Questions:
====================
1. What are the Different Types of PL/SQL Blocks?
2. What is %TYPE, %ROWTYPE Datatypes how They are useful useful?
3. What is PL/SQL Table or Associative Array and what are the Methods
used in Associative Array?
4. PL/SQL Record Datatypes are used in What Situation?
5. Write a PL/SQL Program to Print Numbers 1 to 100
6. Write a PL/SQL Program to Print the Data As Follows:
Input : 'Oracle'
O/P : O r a c l e
7. What is the Different types of CASE Statements And Explain.
8. What is Case Expression?
9. What is the Difference between Simple Loops, While Loops And For
Loops?
What is REVERSE keyword and how it is used?
10. What are the Different Types of Cursors in PL/SQL?
11. What are the Cursor Attributes?
12. While Trying to Identify implicit Cursors what is the Cursor
attribute that is used and with what prefix we have to write?
13. What are the Steps taken place for every cursor Explain?
14. What is an Active Set in cursors? When the Cursors context area with
active set is ready?
15. What Happens When You
i. OPEN the Cursor Which is already opened without closing the
first opened cursor
ii. CLOSE The Cursor More Than Once for One OPEN CURSOR
iii. If You FETCH the Data Without Opening The CURSOR.
16.How For LOOP Cursors Takes advantage over Simple Loop And While Loop
Cursors?
17. What is the advantage of For Loop Cursors with Sub-Queries?
18. What are Cursor Variables? How Many Types of Cursor Variables are
there? How are they used and what is the Advantage ?
19. What are the Different Types of Exceptions are Available?
20. How Pre-defined exceptions are Handled. Explain the Complete process
with an example?
21. What are user-Defined exceptions and in what situation they used and
handled in a PL/SQL Block?
22. What is RAISE_APPLICATION_ERROR in Exceptions and how it is used?
23. What are Stored Procedures in PL/SQL?
24. What is NOCOPY in PL/SQL?
25. What are Formal Parameters and Actual Parameters ?
26. What are the different types of Modes of Parameters in PL/SQL?
27. What are User Defined Functions in PL/SQL? What is The Difference
Between Procedures and Functions?
28. What are Packages in PL/SQL? What is the Difference Between Stand
alone Procedure and a Package?
29. What are the different parts of the Packages and how are they
created?
30. What is Forward Referencing in a Package?
31. What is global Variables in Package and how it is useful?
32. How do we call a Stored Procedure And Packages?
33. What are Triggers in PL/SQL? How Many different Types of Triggers are
available in PL/SQL?
34. What is The Difference between BEFORE INSERT/UPDATE/DELETE and
AFTER INSERT/UPDATE/DELETE in Triggers?
35. Maximum how many Triggers can be Created upon one single Table?
36. What is the difference between statement level trigger and Row Level
Trigger?
37. What are Instead of Triggers?
38. What is a PRAGMA And What is PRAGMA AUTONOMOUS_TRANSACTION? How and
When We Use That in PL/SQL?
39. Can We Write DML Statements in a User-Defined Functions? What's The
Impact?
40. Can We Call a Function Inside another Procedure or Vice Versa?
--All These Questions are Related to the Syllabus what we Have Discussed
and will Discuss until our Contract---------
--The Below Questions are regarding Advanced Concepts which are out of
Syllabus--
1. What is a SQL * LOADER? What are the Different Files Generated while
running the SQL * LOADER?
2. What is UTL_FILE How and When We use this Utility?
3. What are External Tables in Oracle PL/SQL?
4. What are the Different PRAGMAS Available in Oracle PL/SQL?
i.AUTONOMOUS_TRANSACTION
ii. EXCEPTION INIT
iii. INLINE
iv. SERIALIAZABLE
5. What is BULK COLLECT And BULK BINDING in PL/SQL?
6. What is FORALL in PL/SQL and When it is used? What is the Advantage?
7. What is Dynamic SQL in PL/SQL? How And When We Use it?
8. What is Normalization in Oracle Database? What are the Different Types
of Normalizations are available? Explain each Normalization in detail
with a Small Diagram?
