1. TCO 7 – Which of the following is an acceptable error number for the RAISE_APPLICATION_ERROR function? 2. TCO 7 – Which of the following is saved in an Oracle application or library on the client-side? 3. TCO 7 – One important item that needs to be considered when creating stored procedures is to make them flexible so that they can be ____. 4. TCO 7 – A(n) ____ must be assigned one of three available modes: IN, OUT, IN OUT 5. TCO 5 – Which of the following commands is used to delete a program unit? 6. TCO 5 – In the code below, which of the following is the parameter variable? CREATE OR REPLACE FUNCTION fct_test1_sf (p_num IN NUMBER) RETURN NUMBER IS BEGIN UPDATE bb_test1 SET col1 = p_num; RETURN p_num; END; 7. TCO 5 – Which of the following statements is true? 8. TCO 5 – Functions used in SQL statements must meet all of the following requirements, except ____. 9. TCO 7 – What information must be provided in the header section of a PL/SQL block for each parameter?
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer