This page was exported from New Braindump2go Exam Dumps [ https://www.eccouncildumps.com ] Export date:Sun Apr 20 17:27:10 2025 / +0000 GMT ___________________________________________________ Title: Oracle 1Z0-147 Practice Tests From People Who Created Oracle 1Z0-147 Exam --------------------------------------------------- QUESTION 1What can you do with the DBMS_LOB package? A.    Use the DBMS_LOB.WRITE procedure to write data to a BFILE.B.    Use the DBMS_LOB.BFILENAME function to locate an external BFILE.C.    Use the DBMS_LOB.FILEEXISTS function to find the location of a BFILE.D.    Use the DBMS_LOB.FILECLOSE procedure to close the file being accessed. Answer: DQUESTION 2Examine 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 QUESTION 3Which 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 QUESTION 4Examine 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'); Answer: BC QUESTION 5You need to create a DML trigger. Which five pieces need to be identified? (Choose five.) A.    tableB.    DML eventC.    trigger bodyD.    package bodyE.    package nameF.    trigger nameG.    system eventH.    trigger timing Answer: ABCFH QUESTION 6This statement fails when executed: CREATE OR REPLACE TRIGGER CALC_TEAM_AVG AFTER INSERT ON PLAYER BEGIN INSERT INTO PLAYER_BAT_STAT (PLAYER_ID, SEASON_YEAR,AT_BATS,HITS) VALUES (:NEW.ID, 1997, 0,0); END; To which type must you convert the trigger to correct the error? A.    rowB.    statementC.    ORACLE FORM triggerD.    before Answer: A QUESTION 7The add_player , upd_player_stat , and upd_pitcher_stat procedures are grouped together in a package. A variable must be shared among only these procedures. Where should you declare this variable? A.    in the package bodyB.    in a database triggerC.    in the package specificationD.    in each procedure's DECLARE section, using the exact same name in each Answer: A QUESTION 8Examine this package:  Which statement is true? A.    The value of DISCOUNT_RATE always remains 0.00 in a session.B.    The value of DISCOUNT_RATE is set to 0.10 each time the package is invoked in a session.C.    The value of DISCOUNT_RATE is set to 1.00 each time the procedure DISPLAY_PRICE is invoked.D.    The value of DISCOUNT_RATE is set to 0.10 when the package is invoked for the first time in a session. Answer: D QUESTION 9Examine this code: Which statement is true? A.    g_comm has a value of 15 at 9:06am for Smith.B.    g_comm has a value of 15 at 9:06am for Jones.C.    g_comm has a value of 20 at 9:06am for both Jones and Smith.D.    g_comm has a value of 15 at 9:03am for both Jones and Smith.E.    g_comm has a value of 10 at 9:06am for both Jones and Smith.F.    g_comm has a value of 10 at 9:03 for both Jones and Smith. Answer: B QUESTION 10Examine this code: Which statement removes the function? A.    DROP gen_email_name;B.    REMOVE gen_email_name;C.    DELETE gen_email_name;D.    TRUNCATE gen_email_name;E.    DROP FUNCTION gen_email_name;F.    ALTER FUNCTION gen_email_name REMOVE; Answer: E Braindump2go New Realeased Oracle 1Z0-147 Practice Tests Questions Free Share http://www.braindump2go.com/1z0-147.html --------------------------------------------------- Images: http://examgod.com/l2pimages/06d1ced94bc4_A30A/clip_image0016_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb.jpg http://examgod.com/l2pimages/06d1ced94bc4_A30A/clip_image0014_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb.jpg http://examgod.com/l2pimages/06d1ced94bc4_A30A/clip_image0018_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb_thumb.jpg --------------------------------------------------- --------------------------------------------------- Post date: 2014-09-05 03:39:01 Post date GMT: 2014-09-05 03:39:01 Post modified date: 2014-09-05 03:39:02 Post modified date GMT: 2014-09-05 03:39:02 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com