D return a boolean or varchar2 data type answer c

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: th IN and OUT parameters. C. Use the positional notation for parameters. D. Return a BOOLEAN or VARCHAR2 data type. Answer: C Explanation: Functions called from SQL statements must use positional notation to pass values to the IN parameters. Incorrect Answers: A.Functions invoked using SQL statements must be stored in the database, however if they are stored on the client this alone will not cause the statement to fail. B. The function must only have parameters of the IN Mode for them to be used in a SQL Expression. D. You cannot use PL/SQL data types, such as BOOLEAN, RECORD, or TABLE for returning values for the function to be callable from a SQL expression. Actualtests.com - The Power of Knowing 1Z0-147 QUESTION 39: Which two describe a stored procedure? (Choose two) A. A stored procedure is typically written in SQL. B. A stored procedure is a named PL/SQL block that can accept parameters. C. A stored procedure is a type of PL/SQL subprogram that performs an action. D. A stored procedure has three parts: the specification, the body, and the exception handler part. E. The executable section of a stored procedure contains statements that assigns values, control execution, and return values to the calling environment. Answer: B,C A procedure is a named PL/SQL block that can accept parameters (sometimes referred to as arguments), and be invoked. Generally speaking, you use a procedure to perform an action. A procedure has a header, a declaration section, an executable section, and an optional exception-handling section. A procedure can be compiled and stored in the database as a schema object. Procedures promote reusability and maintainability. When validated, they can be used in any number of applications. If the requirements change, only the procedure needs to be updated. QUESTION 40: Examine this code: CREATE OR REPLACE PROCEDURE add_dept ( p_name departments.department_name%TYPE DEFAULT 'unknown', p_loc departments.location_id%TYPE DEFAULT 1700) IS BEGIN INSERT INTO depart...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online