OCA PL/SQL 1Z0-144

Aqui esta listado todos os tópicos da pova 1Z0-144 OCA PL/SQL. Com o tempo irei adicionando os posts relacionados a cada tópico. Apesar de um post estar listado a um respectivo tópico, talvez esse post não fale apenas desse tópico, mas de outros também, então estejam atentos! Espero que gostem!

Oracle Database 11g: PL/SQL Fundamentals

Introduction to PL/SQL
Explain the need for PL/SQL – POST
Explain the benefits of PL/SQL – POST
Identify the different types of PL/SQL blocks – POST
Output messages in PL/SQL – POST
Declaring PL/SQL Variables
Recognize valid and invalid identifiers – POST
List the uses of variables, declare and initialize variables, use bind variables – POST
List and describe various data types using the %TYPE attribute – POST
Writing Executable Statements
Identify lexical units in a PL/SQL block – POST
Use built-in SQL functions in PL/SQL and sequences in PL/SQL expressions – POST
Describe when implicit conversions take place and when explicit conversions have to be dealt with – POST
Write nested blocks and qualify variables with labels – POST
Write readable code with appropriate indentation – POST
Interacting with the Oracle Database Server
Create PL/SQL executable blocks using DML and transaction control statements – POST
Make use of the INTO clause to hold the values returned by a SQL statement – POST
Writing Control Structures
Identify the uses and types of control structures (IF, CASE statements and expressions) – POST
Construct and identify loop statements – POST
Apply guidelines when using conditional control structures – POST
Working with Composite Data Types
Create user-defined PL/SQL records – POST
Create a record with the %ROWTYPE attribute – POST
Create an INDEX BY table and INDEX BY table of records – POST
Describe the differences among records, tables, and tables of records – POST
Using Explicit Cursors
Distinguish between usage of implicit and explicit cursors, use SQL cursor attributes – POST
Declare and control explicit cursors, use simple loops and cursor FOR loops to fetch data – POST
Declare and use cursors with parameters – POST
Lock rows with the FOR UPDATE clause and reference the current row with the WHERE CURRENT OF clause – POST I, POST II
Handling Exceptions
Define PL/SQL exceptions – POST
Recognize unhandled exceptions – POST
Handle different types of exceptions (pre-defined exceptions, non-predefined exceptions and user-defined exceptions) – POST
Propagate exceptions in nested blocks and call applications – POST
Creating Stored Procedures and Functions
Differentiate between anonymous blocks and subprograms – POST
Create a simple procedure and invoke it from an anonymous block – POST
Create a simple function – POST
Create a simple function that accepts a parameter – POST
Differentiate between procedures and functions – POST

Oracle Database 11g: Develop PL/SQL Program Units

Creating Procedures
Differentiate between anonymous blocks and subprograms, use a modularized and layered subprogram design, and identify the benefits of subprograms – POST I, POST II
Create a simple procedure and invoke it from an anonymous block – POST
Work with procedures – POST
Handle exceptions in procedures, remove a procedure, and display a procedure’s information – POST I,
Creating Functions
Differentiate between a procedure and a function – POST
Describe the uses of functions – POST
Work with functions (create, invoke and remove functions) – POST I, POST II
Creating Packages
Identify the benefits and the components of packages – POST
Work with packages (create package specification and body, invoke package subprograms, remove a package and display package information) – POST
Working with Packages
Overload package subprograms, use forward declarations – POST I, POST II
Create an initialization block in a package body – POST
Manage persistent package data states for the life of a session and use PL/SQL tables and records in packages – POST
Using Oracle-Supplied Packages in Application Development
Describe how the DBMS_OUTPUT package works – POST
Use UTL_FILE to direct output to operating system files – POST
Describe the main features of UTL_MAIL – POST
Using Dynamic SQL
Describe the execution flow of SQL statements – POST
Use Native Dynamic SQL (NDS) – POST I, POST II,
Use the DBMS_SQL package – POST I, POST II,
Design Considerations for PL/SQL Code
Create standard constants and exceptions – POST
Write and call local subprograms – POST
Control the run-time privileges of a subprogram – POST
Perform autonomous transactions – POST
Use NOCOPY hint, PARALLEL ENABLE hint and DETERMINISTIC clause – POST I, POST II, POST III
Use bulk binding and the RETURNING clause with DML – POST I, POST II, POST III
Creating Triggers
Describe different types of triggers and their uses – POST
Create database triggers – POST I, POST II
Manage triggers – POST
Creating Compound, DDL, and Event Database Triggers – POST
Create triggers on DDL statements – POST
Create triggers on system events – POST
Using the PL/SQL Compiler
Describe the new PL/SQL compiler and features – POST
Use the new PL/SQL compiler initialization parameters – POST
Use the new PL/SQL compile time warnings – POST
Managing PL/SQL Code
Describe and use conditional compilation – POST
Hide PL/SQL source code using dynamic obfuscation and the Wrap utility – POST
Managing Dependencies
Track and manage procedural dependencies – POST