This preview shows page 1. Sign up to view the full content.
Unformatted text preview: th IN and OUT parameters.
C. Use the positional notation for parameters.
D. Return a BOOLEAN or VARCHAR2 data type.
Functions called from SQL statements must use positional notation to pass values to the IN
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
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
E. The executable section of a stored procedure contains statements that assigns values,
control execution, and return values to the calling environment.
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
QUESTION 40: Examine this code:
CREATE OR REPLACE PROCEDURE add_dept
( p_name departments.department_name%TYPE DEFAULT
p_loc departments.location_id%TYPE DEFAULT 1700)
INSERT INTO depart...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09