Which two tasks should be created as functions instead of as procedures? (Choose two.)
A. Reference host or bind variables in a PL7SQL block of code
B. Tasks that compute and return multiple values to the calling environment
C. Tasks that compute a value that must be returned to the calling environment
D. Tasks performed in SQL that increase data independence by processing complex data analysis within the Oracle server, rather than by retrieving the data into an application
|
Download Printable PDF. VALID exam to help you PASS. |
 |
I agree that correct answers are C,D.
Reference for D:
OracleDatabase11g:Develop PL/SQL Program UnitsVolume1 Student GuideD49986GC20
https://technodocbox.com/81312928-Databases/Oracle-database-11g-develop-pl-sql-program-units.html
“Advantages of User-Defined Functions in SQL Statements SQL statements can reference PL/SQL user-defined functions anywhere a SQL expression is allowed. For example, a user-defined function can be used anywhere that a built-in SQL function, such as UPPER(), can be placed. Advantages Permits calculations that are too complex, awkward, or unavailable with SQL. Functions increase data independence by processing complex data analysis within the Oracle server, rather than by retrieving the data into an application Increases efficiency of queries by performing functions in the query rather than in the application Manipulates new types of data (for example, latitude and longitude) by encoding character strings and using functions to operate on the strings Oracle Database 11g”