Search Again: 1z0-147 From: Tab Leh Date: Monday, September 27, 2004 Time: 5:36:46 am Hi, I am trying to get the OCP (PL/SQL Programmer ) , so first i pass the 1z0-001 examn and i am trying to pass the second examn 1z0-147, get some simple of the question from the internet but i found that some resources gives different answers to the same questions , so plz i f u can help me to get the insure answers for this questions: 1- Wich three are true about dependent objects? (Choose Three). A.Invalid objects cannot be decribed. B.An object with status of invalid cannot be referenced object. C.The oracle server automatically records dependencies among objects. D.All schema objects have a status that is recorded in the data dictionary. E.You can view whether an objects is valid or invalid in the USER_STATUS data dictionary. F.you can view wether an object is valid or invalid in the USER_OBJECTS data dictionary. The Answers was : C,D,F OR A,C,F 2-You have created a stored procedure DELETE_TEMP_TABLE that uses dynamique SQL to remove a table in your schema. YOu have granted the EXECUTE privileges to user A on this procedure. When user A executes the DELETE_TEMP_TEBLE procedure, under whose privileges are the operations performed by default ? A.SYS privileges. B.Your privileges. C.Public privileges. D.User As privileges. E.User A cannot execute your procedure that has dynamic SQL. The Answers was : D OR B 3-You want to create a PL/SQL block of code that calculate discounts on customer orders. This code will beinvoked from several places, but only within the program unit ORDERTOTAL. What is the most appropriate location to store the code that calculates the discounts. A.A storedprocedure on the server. B.A block code in a PL/SQL library. C.A stand alone procedure on the client machine. D.A block of code in the body of the programm unit ORDERTOTAL. E.A local subprogramm defined within the programm unit ORDERTOTAL. The Answers was : A OR E. 4-You create a DML trigger.For the timing information, which is valid with a DML trigger? A.During. B.INSTEAD. C.ON SHUTDOWN. D.BEFORE. E.ON STATMENT EXECUTION. The Answers was : B OR D 5-Which two describe a stored procedure? (Choose Two). A.A stored procedure is typically written in SQL. B.A stored procedure is named PL/SQL block that can accept parameters. C.A stored procedure is a type of PL/SQL subprogram that perform 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 statment taht assign values, control execution, and return values to the environment. The Answers was : C,D OR B,C 6-Wich two dopes the INSTEAD OF clause in a trigger identify? (Choose Two). A.The view associated with the trigger. B.The table associated with the trigger. C.The event associated with the trigger. D.The package associated with the trigger. E.The statment level or for each row association to the trigger. The Answers was : A,E OR A,C 7-What part of a database trigger determines the number of times the trigger body executes? A.Trigger type. B.Trigger Body. C.Trigger event. D.Trigger timing. The Answers was : A OR C Plz Help me A.S.A.P Thanks in Advance Best Reguards, --------------------------------- Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage!

Messages In This Thread: 1z0-147 by Tab Leh on Sep 27, 2004 at 5:36:46 am