PL/SQL

1. Which of the following tasks should be created as functions instead of as procedures? 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 require processing complex data analysis within the Oracle server, rather than by retrieving the data into an application 2. Create and invoke the GET_JOB function to return a job title. a. Create a function called GET_JOB to return a job title . b. Create a VARCHAR2 host variable called TITLE, allowing a length of 35 characters. Invoke the function with SA_REP job ID to return the value in the host variable. Print the host variable to view the result