We're so confident of our products that we provide no hassle product exchange.
Oracle 1Z0-147 Exam Overview:
| Certification Vendor: | Oracle |
| Exam Name: | Oracle9i Program with PL/SQL |
| Exam Number: | 1Z0-147 |
| Exam Price: | USD 245 |
| Passing Score: | 70% - 77% |
| Certificate Validity Period: | Lifetime |
| Related Certifications: | Oracle PL/SQL Developer Certified Professional |
| Available Languages: | English |
| Exam Duration: | 90 minutes |
| Real Exam Qty: | 64 - 66 |
| Exam Format: | Multiple Choice, Single Answer, Multiple Answer |
| Recommended Training: | Oracle9i: Program with PL/SQL Training |
| Exam Registration: | Pearson VUE Oracle Registration Oracle University |
| Sample Questions: | Oracle 1Z0-147 Sample Questions |
| Exam Way: | Computer-based test, delivered at authorized Pearson VUE centers; retired after July 31, 2013 |
| Pre Condition: | No mandatory prerequisites; recommended basic knowledge of SQL and Oracle Database 9i |
| Official Syllabus URL: | https://education.oracle.com/ |
Oracle 1Z0-147 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: PL/SQL Fundamentals | 15% | - Overview of PL/SQL
|
| Topic 2: Procedures and Functions | 20% | - Creating and invoking procedures
|
| Topic 3: Packages | 20% | - Package structure
|
| Topic 4: Database Triggers | 15% | - Creating and managing triggers
|
| Topic 5: Managing Dependencies and Performance | 5% | - Object dependencies
|
| Topic 6: Error Handling and Exceptions | 10% | - Exception concepts
|
| Topic 7: Control Structures | 15% | - Conditional statements
|
Oracle9i program with pl/sql Sample Questions:
1. The 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 each procedure's DECLARE section, using the exact same name in each.
B) In a database trigger.
C) In the package body.
D) In the package specification.
2. The add_player procedure inserts rows into the PLAYER table. Which command will show this directory dependency?
A) SELECT * FROM USER_DEPENDENCIES WHERE TYPE = 'DIR';
B) SELECT * FROM USER DEPENDENCIES WHERE REFERENCED_NAME = 'ADD_PLAYER';
C) SELECT * FROM USER_DEPENDENCIES WHERE REFERENCED_NAME = 'PLAYER';
D) SELECT * FROM USER DEPENDENCIES WHERE REFERENCED_NAME = 'TABLE';
3. When creating a function, in which section will you typically find the RETURN keyword?
A) DECLARATIVE
B) HEADER only
C) DECLARATIVE,EXECUTABLE and EXCEPTION HANDLING
D) EXECUTABLE and HEADER
4. Which statement is true?
A) Stored functions can increase the efficiency of queries by performing functions in the query rather than in the application.
B) Stored functions can be called from the SELECT and WHERE clauses only.
C) Stored functions cannot manipulate new types of data, such as longitude and latitude.
D) Stored functions do not permit calculations that involve database links in a distributed environment.
5. Which statements are true? (Choose all that apply)
A) If errors occur during the compilation of a trigger you can go into SQL *Plus and query the USER_ERRORS data dictionary view to see compilation errors.
B) If errors occur during the compilation of a trigger you can go into SQL *Plus and query the USER_TRIGGERS data dictionary view to see the compilation errors.
C) If errors occur during the compilation of a trigger you can use the SHOW ERRORS command within iSQL *Plus to see the compilation errors.
D) If errors occur during the compilation of a trigger, the trigger is still created.
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: C | Question # 3 Answer: D | Question # 4 Answer: A | Question # 5 Answer: A,C,D |
By Aurora
