1Z0-146: Oracle Database 11g - Advanced PL/SQL


Exam Number: 1Z0-146

Exam Title: Oracle Database 11g - Advanced PL/SQL


Associated Certification Paths



Oracle 1Z0-146 Certification Details:


Exam Name Oracle Database 11g - Advanced PL/SQL
Exam Code 1Z0-146
Exam Product Version Oracle Database 11g
Exam Price USD $245
Duration 90 minutes
Number of Questions 68
Passing Score 65% 
Validated Against This exam has been validated against Oracle Database9i - 12.1.0.1.0 (12c Release 1).
Format Multiple Choice
Recommended Practice 1Z0-146 Online Practice Exam
Recommended Training Oracle Database 11g: Advanced PL/SQL

Oracle 1Z0-146 Certification Topics:



Oracle11g: Advanced PL/SQL
  • Introduction to PL/SQL
PL/SQL Programming Concepts: Review
  • List restrictions on calling functions from SQL expressions
  • Hand exceptions
  • Manage dependencies
  • Use Oracle-supplied packages
Designing PL/SQL Code
  • Identify guidelines for cursor design
  • Use cursor variables
  • Create subtypes based on existing types
Working with Collections
  • 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
Using Advanced Interface Methods
  • Execute external C programs from PL/SQL
  • Execute Java programs from PL/SQL
Implementing Fine-Grained Access Control for VPD
  • Explain the process of fine-grained access control
  • Implement and test fine-grained access control
Manipulating Large Objects
  • Create and manage LOB data types
  • Use the DBMS_LOB PL/SQL package
  • Use of temporary LOBs
Administering SecureFile LOBs
  • Describe SecureFile LOB features
  • Enable SecureFile LOB deduplication, compression, and encryption
  • Migrate BasicFile LOBs to the SecureFile LOB format
Performance and Tuning
  • Use native and interpreted compilation methods
  • Tune PL/SQL code
  • Enable intraunit inlining
Improving Performance with Caching
  • 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
Analyzing PL/SQL Code
  • Run reports on source code
  • Determine identifier types and usages
  • Use DBMS_METADATA to retrieve object definitions
Profiling and Tracing PL/SQL Code
  • Trace PL/SQL program execution
  • Profile PL/SQL applications
Safeguarding Your Code Against SQL Injection Attacks
  • Describe SQL injections
  • Reduce attack surfaces
  • Use DBMS_ASSERT
  • Design immune code
  • Test code for SQL injection flaws

Oracle 1Z0-146 - Oracle Database 11g - Advanced PL/SQL Exam Preparation: