1)Requirement
You need a small lookup table that will be generated in memory every time a PL/SQL procedure is invoked or a package that declares it is initialized. Which of the following is the proper composite data type to use?
Solution:
Associative array(An associative array (formerly called PL/SQL table or index-by table) is a set of key-value pairs. Each key is a unique index, used to locate the associated value with the syntax variable_name(index))For more information on index by table
http://www.ebiztechnics.net/2019/04/oracle-plsql-index-by-integer.html
2)Which of the following is a valid reason for deciding to create a subprogram as a function rather than as a procedure?
It must be callable from SQL statements
.
