Exam Title: Oracle Database 12c: Advanced PL/SQL
Associated Certification Paths
Passing single certification exams is one requirement you need to fulfill to become certified.
Each certification has different requirements.
When you select each associated certification path, you can see the entire list of requirements necessary to be certified in a particular technology.
We recommend:
Taking related training courses to increase your chances of passing your exam.
Reviewing exam topics to help focus your studying.
Signing up for the appropriate exam(s) and taking it to officially become certified.
Exam Details:
Duration: 110
Number of Questions: 75
Passing Score: 62%
Beta test score reports will be available at CertView approximately 11 weeks after the Beta exam is closed. You will receive an email with instructions on how to access the results of your beta test.
View passing score policy
Validated Against:
Exam has been validated against Oracle Database 12c.
Format: Multple Choice
Exam Preparation
Training Increases Your Chance of Passing
Take Recommended Training Courses
Complete the training below to prepare for your exam (optional):
Oracle Database 12c: Advanced PL/SQL
Additional Preparation and Information
The combination of training and hands-on experience is the best preparation for passing the exam.
Oracle Database 12c: Program with PL/SQL
Oracle Database 12c: SQL and PL/SQL Fundamentals
Review Exam Topics
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 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
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
Use DBMS_PARALLEL_EXECUTE package
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
Use DBMS_ASSERT
Miscellaneous
Grant roles to PL/SQL packages and standalone programs
"Use BEQUEATH CURRENT_USER views
Enable INHERIT PRIVILEGES and INHERIT ANY PRIVILEGES privileges
Use invisible columns with %ROWTYPE attribute
Use Edition-Based Redefinition
Multidisciplinary
Items wherein concepts across multiple objectives will be tested in each item