D overloading allows different subprograms with the

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: Overloading allows different subprograms with the same number, type and order of parameters. D. Overloading allows different subprograms with the same name and same number or type of parameters. E. Overloading allows different subprograms with the same name, but different in either number, type or order of parameters. Actualtests.com - The Power of Knowing 1Z0-147 Answer: A, E Explanation: A Only local or packaged subprograms, or type methods, can be overloaded. You cannot overload standalone subprograms E The Subprograms within the package must have formal parameters that differ in number, data type, or the order of parameters. Incorrect Answers B You cannot overload two functions with the same name that differ only in their return data type. C & D The Subprograms within the package must have formal parameters that differ in number, data type, or the order of parameters. QUESTION 78: All users currently have the INSERT privilege on the PLAYER table. You only want your users to insert into this table using the ADD_PLAYTER procedure. Which two actions must you take? (Choose two) A. CRANT SELECT ON ADD_PLAYER TO PUBLIC; B. CRANT EXECTUE ON ADD_PLAYER TO PUBLIC; C. CRANT INSERT ON PLAYER TO PUBLIC; D. CRANT EXECTUE INSERT ON ADD_PLAYER TO PUBLIC; E. REVOKE INSERT ON PLAYER FROM PUBLIC; Answer: B, E Explanation: B. You must provide the users with EXECUTE privilege to the procedure. E. You want to restrict access to the underlying table so you REVOKE the INSERT privilege to PUBLIC. Incorrect Answers A. You can't GRANT the SELECT privilege to a procedure C. Users already have this privilege, you want to REVOKE this privilege. D. You can't GRANT an INSERT privilege to a procedure, the EXECUTE privilege is correct. QUESTION 79: When creating a function, in which section will you typically find the RETURN keyword? Actualtests.com - The Power of Knowing 1Z0-147 A. HEADER only B. DECLARATIVE C. EXECUTABLE and HEADER D. DECLARATIVE,EXECUTABLE and EXCEPTION HANDLING Answer: C Explanation: The header of the function contains the R...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online