Skills required for Oracle test 1Z0-147.
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
Skills required for Oracle test 1Z0-147.
Rating:
Oracle has specified around ninety objectives for 1Z0-147 (Oracle9i: Program with PL/SQL) test, which are grouped under eleven topics. Following are the important areas in which an individual should possess good knowledge before taking the test:
- Writing PL/SQL programs.
- Designing subprograms such as procedures and functions and storing them in the database for repeated execution.
- Invoking stored procedures and functions from different environments.
- Creating packages and related variables, cursors, constants, exceptions, procedures, and functions.
- Invoking a package construct.
- Creating packages that use the overloading feature.
- Performing SQL operations on large objects (LOBs).
- Creating and executing different types of database triggers.
- Using OLD and NEW qualifiers in database triggers.
- Calling stored procedures from within database triggers.
- Managing procedural dependencies.
- Knowing how remote dependencies are governed.
Rating:
Was this information helpful?
Other articles
- What is the DBMS_LOB package?
- What is dynamic SQL?
- What is the DBMS_OUTPUT Oracle supplied package?
- What is a BEFORE trigger?
- What is the syntax for creating a package body?