Nextvalpname ploc end adddept you created the adddept

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ments(department_id, department_name, loclation_id) VALUES(dept_seq.NEXTVAL,p_name, p_loc); END add_dept; / You created the add_dept procedure above, and you now invoke the procedure in SQL *Plus. Which four are valid invocations? (Choose four) A. EXECUTE add_dept(p_loc=>2500) B. EXECUTE add_dept('Education', 2500) C. EXECUTE add_dept('2500', p_loc =>2500) D. EXECUTE add_dept(p_name=>'Education', 2500) - The Power of Knowing 1Z0-147 E. EXECUTE add_dept(p_loc=>2500, p_name=>'Education') Answer: A,B,C,E Explanation: A. This statement correctly uses named notation. A Default value is defined for both parameters in the procedure so it is not necessary to pass any parameters. B. This statement correct uses positional notation. C. This statement correctly uses mixed notation. E. This statement correctly uses named notation. Incorrect Answers D. When using mixed notation to pass the values, all the parameters specified with positional notation must precede the parameters specified with named notation in the subprogram call. If the parameters specified with positional notation do not precede the parameters specified with named notation, the following error is generated at run time: PLS-00312: a positional parameter association may not follow a named QUESTION 41: Which three are valid ways to minimize dependency failure? (Choose three) A. Querying with the SELECT * notification. B. Declaring variables with the %TYPE attribute. C. Specifying schema names when referencing objects. D. Declaring records by using the %ROWTYPE attribute. E. Specifying package.procedure notation while executing procedures. Answer: A,B,D Explanation: A. Use the SELECT * notation. This will minimize recompilation failures because SELECT * will select all the columns of the table. If you add or remove any column from the table, the SELECT statement will not be impacted by the change in the table and will require no changes to the program unit. B, D. Use the %ROWTYPE to declare records and %TYPE to declare variables. This allows you to declare records and variables that inherit the data types of the underlying columns of the base...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online