Oracle9i program with pl/sql 1Z0-147 Certified Exam Dumps

1Z0-147 Exam Dumps

Oracle9i program with pl/sql 1Z0-147 real exam questions and online practice test engine by FreeCram. Try 1Z0-147 exam questions for free. You can also download a free demo of the 1Z0-147 exam PDF version.

Oracle's 1Z0-147 actual exam materials brought to you by FreeCram group of Oracle certification experts.
View all 1Z0-147 actual exam questions & answers and explanations for free.

If you like our product, you can request full access to all the latest Oracle9i program with pl/sql 1Z0-147 exam premium questions.

Certification Provider: Oracle
Exam Code / Number: 1Z0-147
Exam Name: Oracle9i program with pl/sql
Exam Questions: 111
Last Updated: Jul 08, 2026
Corresponding Certification: 9i Internet Application Developer

Go To 1Z0-147 Questions

(346 Up Votes)

Oracle 1Z0-147 Exam Syllabus Topics:

SectionWeightObjectives
Topic 1: Managing Dependencies and Performance5%- Object dependencies
  • 1. Privileges and security
  • 2. Invalidation and recompilation
Topic 2: Control Structures15%- Conditional statements
  • 1. IF, ELSIF, CASE expressions
- Iterative statements
  • 1. Nested loops and EXIT conditions
  • 2. LOOP, WHILE, FOR loops
Topic 3: PL/SQL Fundamentals15%- Declaring Variables and Data Types
  • 1. Using %TYPE and %ROWTYPE attributes
  • 2. Scalar, composite, reference types
- Overview of PL/SQL
  • 1. Architecture and benefits
  • 2. Block structure and execution
Topic 4: Packages20%- Advanced package features
  • 1. Persistent state and cursors
  • 2. Overloading subprograms
  • 3. Package initialization
- Package structure
  • 1. Specification and body
  • 2. Scope and visibility
Topic 5: Procedures and Functions20%- Creating and invoking functions
  • 1. Differences between procedures and functions
  • 2. Return values and usage in SQL
- Creating and invoking procedures
  • 1. Privileges and dependencies
  • 2. Parameter modes IN, OUT, IN OUT
Topic 6: Error Handling and Exceptions10%- Handling exceptions
  • 1. EXCEPTION block structure
  • 2. Propagation and logging
- Exception concepts
  • 1. User-defined exceptions
  • 2. Predefined exceptions
Topic 7: Database Triggers15%- Creating and managing triggers
  • 1. Enabling, disabling, and dropping triggers
  • 2. Trigger body and restrictions
- Trigger concepts
  • 1. Firing order and timing
  • 2. DML, INSTEAD OF, DDL triggers


0
0
0
10