OCP 12c PL/SQL 1Z0-148

Designing PL/SQL Code

  • Identify guidelines for cursor design
  • Use cursor variables
  • Create subtypes based on existing types
  • Specify a white list of PL/SQL units to access a package
  • Use PL/SQL bind types

Creating and Managing Collections

  • Create and manage nested tables
  • Create and manage varrays
  • Create and manage associative arrays/PLSQL tables

Working with Collections

  • Manipulate collections001
  • Distinguish between the different types of collections and their uses
  • Use nested collections
  • Use collection of objects

Manipulating Large Objects

  • Create and maintain LOB data types
  • Differentiate between internal and external LOBs
  • Use the DBMS_LOB PL/SQL package
  • Use of temporary LOBs
  • Describe and use SecureFile LOB

Using Advanced Interface Methods

  • Execute external C programs from PL/SQL
  • Execute Java programs from PL/SQL

Tuning PL/SQL Performance

  • Use native and interpreted compilation methods
  • Optimize PL/SQL code
  • Enable intraunit inlining
  • Use the FETCH FIRST clause
  • Use PL/SQL functions that run faster in SQL

Improving Performance with Caching

  • Identify when to result cache a function
  • Handle session dependencies in a result cache function
  • Set up PL/SQL functions to use PL/SQL result caching
  • Invoker’s Right function result caching
  • Explain invalidation of cache results
  • Use the DBMS_RESULT_CACHE package

Analyzing PL/SQL Code

  • Use the supplied packages and dictionary views to find coding information
  • Determine identifier types and usages with PL/Scope
  • Use the DBMS_METADATA package for creation DDL that can be used to re-create the objects
  • Use the UTL_CALL_STACK Package
  • Use compile time warnings
  • Use conditional compilation

Profiling and Tracing PL/SQL Code

  • Trace PL/SQL program execution
  • Profile PL/SQL applications

Implementing Fine-Grained Access Control for VPD

  • Explain the process of fine-grained access control
  • Build security policies

Safeguarding Your Code Against SQL Injection Attacks

  • Explain SQL injection
  • Reduce attack surfaces


  • Grant roles to PL/SQL packages and standalone programs
  • Use invisible columns with %ROWTYPE attribute
  • Use Edition-Based Redefinition


  • Items wherein concepts across multiple objectives will be tested in each item
Esse Blog é reconhecido pela
Sou articulista
Sou articulista

Clique para seguir este blog e receber notificações via email de novos posts.

Tércio Costa

Tércio Costa

Meu nome é Tércio Costa, sou formado em Ciências da Computação pela UFPB, tenho a certificação Oracle SQL Expert, mantendo um blog reconhecido pela OTN(oraclepress.wordpress.com), no qual também publico artigos técnicos no portal OTN, no portal http://www.profissionaloracle.com.br/gpo e na revista SQL Magazine. Além de tudo isto sou um Oracle ACE Associate por estar sempre contribuindo para a comunidade com um bom nível de expertise.

Links Pessoais

Serviços verificados

Visualizar Perfil Completo →

Total de Visualizações da Página
  • 96.671 Visualizações
%d blogueiros gostam disto: