Topic: Oracle Certified Professional Exams (OCP & OCA) >> Exam No 1Z0-147
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| swag |
Posted: Apr 21, 2008 02:35:40 PM |
Total Post: 2
Joined: Apr, 2008
|
Hi All,
i am trying to pass the second examn 1z0-147, got some sample 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 as earliest as possible:
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
Thanx in advance
Regards
Swagat |
|
|
 GOPU |
| Posted: Apr 22, 2008 01:20:27 AM |  |
|
Total Post: 239
Joined: Apr, 2008
|
Hi,
why you are going in back of the resources to get the answer.
you alone going to write the exam,right ?
then you find the answer alone.may be it will take some time, and you have to do some hard work in the begning, but i am sure that all will help you in the future.
all the best for your exams
regards
Gopu
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 239 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
