Oracle 1Z0-147 training certification

3.Which three describe a stored procedure? (Choose three.) 

A.A stored procedure is typically written in SQL. 

B.By default, a stored procedure executes with the privileges of its owner. 

C.A stored procedure has three parts: the specification, the body, and the exception handler part . 

D.A stored procedure is stored in the database and can be shared by a number of programs. 

E.A stored procedure offers some advantages over a standalone SQL statement, such as programmable functionality and compiled code. 

Correct:B D E 

4.Which three are valid ways to minimize dependency failure? (Choose three.) 

A.querying with the SELECT * notation 

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 

Correct:A B D 

5.Examine this procedure: 

CREATE OR REPLACE PROCEDURE INSERT_TEAM (V_ID in NUMBER, V_CITY in VARCHAR2 DEFAULT 'AUSTIN', V_NAME in VARCHAR2) IS BEGIN INSERT INTO TEAM (id, city, name) VALUES (v_id, v_city, v_name); COMMIT; END; 

Which two statements will successfully invoke this procedure in SQL*Plus? (Choose two.) 

A.EXECUTE INSERT_TEAM; 

B.EXECUTE INSERT_TEAM(3, V_NAME=>'LONGHORNS', V_CITY=>'AUSTIN'); 

C.EXECUTE INSERT_TEAM(3,'AUSTIN','LONGHORNS'); 

D.EXECUTE INSERT_TEAM (V_ID := 3, V_NAME := 'LONGHORNS', V_CITY := 'AUSTIN'); 

E.EXECUTE INSERT_TEAM (3,'LONGHORNS'); 

Correct:B C