Oracle 1Z0-146 Exam Details & Actual Exam Questions
- Exam Code/Number: 1Z0-146
- Exam Name/Title: Oracle database 11g:advanced pl/sql
- Certification Provider: Oracle
- Corresponding Certification: 9i Internet Application Developer
- Exam Questions: 136
- Updated On: Sep,17 2026
- Certification Level: Professional
Oracle database 11g:advanced pl/sql Exam Questions
View 1Z0-146 actual exam questions, answers and explanations for free.
91% student found the test questions almost same
All the information you need to pass Oracle database 11g:advanced pl/sql 1Z0-146 exam and free practice exam verified by EduDump exam experts.
Said the test questions were almost same
Passed the exams with the material
Found the study quides effective and helpful
(45 Up Votes)Oracle 1Z0-146 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database 11g: Advanced PL/SQL |
| Exam Number: | 1Z0-146 |
| Related Certifications: | Oracle Database 11g Administrator Certified Professional Oracle PL/SQL Developer Certified Associate |
| Exam Format: | Multiple Answer, Multiple Choice |
| Exam Duration: | 90 minutes |
| Real Exam Qty: | 68 |
| Exam Price: | $245 USD |
| Available Languages: | English |
| Passing Score: | 65% |
| Certificate Validity Period: | Does not expire once earned |
| Recommended Training: | Oracle Database 11g: Advanced PL/SQL Training |
| Exam Registration: | Pearson VUE Registration Oracle Certification Portal |
| Sample Questions: | Oracle 1Z0-146 Sample Questions |
| Exam Way: | In-person at Pearson VUE test centers or online proctored exam |
| Pre Condition: | No formal prerequisites; recommended to have Oracle PL/SQL Developer Certified Associate or equivalent experience |
| Official Syllabus URL: | https://education.oracle.com/oracle-database-11g-advanced-plsql/pexam_1Z0-146 |
Oracle 1Z0-146 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Safeguarding PL/SQL Code | - Implementing Fine-Grained Access Control (VPD) - Preventing SQL injection |
| Topic 2: PL/SQL Programming Concepts: Review | - Managing dependencies - Using Oracle-supplied packages - Restrictions on calling functions from SQL expressions - Exception handling |
| Topic 3: Administering SecureFile LOBs | - SecureFile LOB features - Enabling compression, deduplication, and encryption - Migrating BasicFile to SecureFile LOBs |
| Topic 4: Working with Collections | - Creating nested tables, VARRAYs, and associative arrays - Choosing appropriate collection types - Using collection methods - Manipulating collection data |
| Topic 5: Manipulating Large Objects | - Using DBMS_LOB package - Working with temporary LOBs - Creating and managing LOB data types |
| Topic 6: Performance and Tuning | - Native vs interpreted compilation - Using DBMS_RESULT_CACHE - Profiling and tracing PL/SQL code - Intraunit inlining |
| Topic 7: Designing PL/SQL Code | - Using cursor variables - Cursor design guidelines - Creating subtypes |
| Topic 8: Using Advanced Interface Methods | - Executing Java programs from PL/SQL - Executing external C programs from PL/SQL |
0
0
0
10