Scroll to top button

Oracle Database 11g: Advanced PL/SQL

ISBN : 9781616912468

Start your prep for the Oracle PL/SQL Developer certified associate professional certification exam with the Oracle Database 11g: Advanced PL/SQL course. The cert guide offers complete coverage of the 1Z0-146 exam objectives and includes topics such as analyzing, developing, and developing PL/SQL codes; performance and tuning; profiling and tracing PL/SQL codes; improving performance with caching, and many more. The course will help you learn the skills of securing and safe guarding your PL/SQL code.

The 1Z0-146 exam is part of Oracle's Advanced PL/SQL Developer Certified Professional certification which comprises of three exams. It is a required part to the certification.

Certification can be earned in one of the two ways:

  • Option 1: Pass the Oracle PL/SQL Developer Certified Associate prior to taking the 1Z0-146 exam.
  • Option 2: Pass exams required for the Oracle PL/SQL Developer Certified Associate certification and then take 1Z0-146 exam to get credit to this certification

The 1Z0-146 exam is targeted at advanced PL/SQL developers who are looking to optimize the design of their PL/SQL application.

Glossary of terms
Pre Assessment Questions
Full Length Tests
Post Assessment Questions
  • Introduction
  • Introduction to PL/SQL
  • List restrictions on calling functions from SQL expressions
  • Hand exceptions
  • Manage dependencies
  • Use Oracle-supplied packages
  • Identify guidelines for cursor design
  • Use cursor variables
  • Create subtypes based on existing types
  • Create collections (nested table, array and associative arrays, PL SQL tables)
  • Use collections methods
  • Manipulate collections
  • Distinguish between the different types of collections and their uses
  • Execute external C programs from PL/SQL
  • Execute Java programs from PL/SQL
  • Explain the process of fine-grained access control
  • Implement and test fine-grained access control
  • Create and manage LOB data types
  • Use the DBMS_LOB PL/SQL package
  • Use of temporary LOBs
  • Describe SecureFile LOB features
  • Enable SecureFile LOB deduplication, compression, and encryption
  • Migrate BasicFile LOBs to the SecureFile LOB format
  • Use native and interpreted compilation methods
  • Tune PL/SQL code
  • Enable intraunit inlining
  • Improve memory usage by caching SQL result sets and using the DBMS_RESULT_CACHE package
  • Write queries that use the result cache hint
  • Set up PL/SQL functions to use PL/SQL result caching
  • Run reports on source code
  • Determine identifier types and usages
  • Use DBMS_METADATA to retrieve object definitions
  • Trace PL/SQL program execution
  • Profile PL/SQL applications
  • Describe SQL injections
  • Reduce attack surfaces
  • Design immune code
  • Test code for SQL injection flaws