| |
 |
| |
|
| Duration: |
90 minutes |
| Number of Questions: |
68 |
| Passing Score: |
65% |
|
Passing score subject to change. View Details
|
|
Recommended Training and Preparation
Additional Information & Resources
Exam Topics
Fraudulent Activity Policy
Recommended Training and Preparation
Oracle Database
11g: Advanced PL/SQL
The exam has been validated only against Oracle Database 11g Release 1. When the exam has been validated against Oracle Database 11g: Release 2, this page will be updated to reflect that information.
Additional Information & Resources
Exam Topics
Oracle11g: Advanced PL/SQL |
| [ ] | Introduction |
| [ ] | 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 Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.
If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.
View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.
Printer View