PL/SQL INTERVIEW QUESTION & ANSWERS
| 11. |
Where does PL/SQL code execution take place? |
| |
Usually, execution takes place at the server level. |
| 12. |
What is the use of records? |
| |
Records are used to store related information, which is not necessarily of the same. |
| 13. |
What command tells SQL*Plus to display PL/SQL output? |
| |
SET SERVEROUTPUT ON |
| 14. |
What are the four SQL DML statements permitted in a PL/SQL block? |
| |
The four DML statements that are supported within a PL/SQL block are : - INSERT
- DELETE
- UPDATE
- SELECT
|
| 15. |
What are the collection types that supports PL/SQL? |
| |
The three collection types PL/SQL supports are : - index–by tables
- nested tables
- varrays
|
