PL/SQL INTERVIEW QUESTION & ANSWERS
| 21. |
What is a mutating table? |
| |
A mutating table is one that is in the process of being modified by the SQL statement
which fired a trigger. Because the table is being changed it is not in a consistent state and Oracle does not allow queries against it. |
| 22. |
What are the types of literals? |
| |
There are different types of literals are : - Character literal
- Numeric literal
- String literal
- Boolean literal
- Datetime literal
|
| 23. |
What are subprograms? |
| |
Subprograms are named PL/SQL blocks that can be called with a set of parameters.
PL/SQL has two types of subprograms, procedures and functions. Generally, you use a procedure to perform an action and a function to compute a value. |
| 24. |
What is a collection? |
| |
A collection is an ordered group of elements, all of the same type.
It is a concept that encompasses lists, arrays and other datatypes used in classic programmimg algorithms.
|
| 25. |
Which data manipulation statements can support triggers? |
| |
|
