subject: 1z0-147 exam answers [print this page] Author: andy Author: andy
oracle9i program with pl/sql
Exam Number/Code : 1z0-147
Exam Name : oracle9i program with pl/sql
Questions and Answers : 132 Q&As 1. 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);
Answer: BC 2. Examine this procedure: CREATE OR REPLACE PROCEDURE ADD_PLAYER (V_ID IN NUMBER, V_LAST_NAME VARCHAR2) IS BEGIN INSERT INTO PLAYER (ID,LAST_NAME) VALUES (V_ID, V_LAST_NAME); COMMIT; END; This procedure must invoke the UPD_BAT_STAT procedure and pass a parameter. Which statement, when added to the above procedure, will successfully invoke the UPD_BAT_STAT procedure?
A. EXECUTE UPD_BAT_STAT(V_ID);
B. UPD_BAT_STAT(V_ID);
C. RUN UPD_BAT_STAT(V_ID);
D. START UPD_BAT_STAT(V_ID);
Answer: B 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.
Answer: BDE With the Certinside 1z0-147 practice exam you not only get questions and answers, but you will also get qualified and accurate explanations so that you get a firm grasp of the 1z0-147 exam information. Our resources are constantly being revised and updated for relevance and accuracy. Prepare for your 1z0-147 exam certification today! Select the braindump you want to begin your training with, and pass your next exam. Certinside offers each possible guide to smooth your way of training. If you are visionary learner and feel better with free demo and trainning materials,Oracle 1z0-147 Braindumps is also there to treat you with thorough demonstrations of all critical subject matters. Certinside can help you pass Oracle 1z0-147dumps in the first try!About the Author:
