OCP 12c PL/SQL 1Z0-148

Designing PL/SQL Code

  • Identify guidelines for cursor design – POST I
  • Use cursor variables –
  • Create subtypes based on existing types – POST I
  • 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 – POST I
  • Create and manage varrays – POST I
  • Create and manage associative arrays/PLSQL tables – POST I

Working with Collections

  • Manipulate collections –
  • 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 – POST I
  • Differentiate between internal and external LOBs – POST I
  • Use the DBMS_LOB PL/SQL package –
  • Use of temporary LOBs – POST I
  • Describe and use SecureFile LOB – POST I

Using Advanced Interface Methods

  • Execute external C programs from PL/SQL – POST I
  • Execute Java programs from PL/SQL – POST I

Tuning PL/SQL Performance

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

Improving Performance with Caching

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

Analyzing PL/SQL Code

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

Profiling and Tracing PL/SQL Code

  • Trace PL/SQL program execution – POST I
  • Profile PL/SQL applications – POST I

Implementing Fine-Grained Access Control for VPD

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

Safeguarding Your Code Against SQL Injection Attacks

  • Explain SQL injection – POST I
  • Reduce attack surfaces – POST I
  • Use DBMS_ASSERT – POST I

Miscellaneous

  • Grant roles to PL/SQL packages and standalone programs – POST I
  • Use BEQUEATH CURRENT_USER views – POST I
  • Enable INHERIT PRIVILEGES and INHERIT ANY PRIVILEGES privileges – POST I
  • Use invisible columns with %ROWTYPE attribute – POST I
  • Use Edition-Based Redefinition – POST I

Multidisciplinary

  • Items wherein concepts across multiple objectives will be tested in each item
Anúncios
Esse Blog é reconhecido pela
Sou um
Certificações
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 e OCP PL/SQL, 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
  • 142.605 Visualizações
%d blogueiros gostam disto: