Candidates need to practice the following 30 things to successfully pass the Oracle Advanced PL/SQL Developer Certified Professional (1Z0-146) examination:

  1. Introduction to PL/SQL
  2. List restrictions on calling functions from SQL expressions.
  3. Handle exceptions and manage dependencies.
  4. Use Oracle-supplied packages.
  5. Identify guidelines for cursor design and use cursor variables.
  6. Create subtypes based on existing types.
  7. Create collections (nested table, array and associative arrays, PL SQL tables).
  8. Use collections methods and manipulate collections.
  9. Distinguish between the different types of collections and their uses.
  10. Execute external C programs and Java programs from PL/SQL.
  11. Explain the process of fine-grained access control.
  12. Implement and test fine-grained access control.
  13. Create and manage LOB data types.
  14. Use the DBMS_LOB PL/SQL package.
  15. Use of temporary LOBs.
  16. Describe SecureFile LOB features.
  17. Enable SecureFile LOB deduplication, compression, and encryption.
  18. Migrate BasicFile LOBs to the SecureFile LOB format.
  19. Use native and interpreted compilation methods.
  20. Tune PL/SQL code and enable intraunit inlining.
  21. Improve memory usage by caching SQL result sets and using the DBMS_RESULT_CACHE package.
  22. Write queries that use the result cache hint.
  23. Set up PL/SQL functions to use PL/SQL result caching.
  24. Run reports on source code.
  25. Determine identifier types and usages.
  26. Use the DBMS_METADATA package to retrieve object definitions.
  27. Trace PL/SQL program execution.
  28. Profile PL/SQL applications.
  29. Describe SQL injections, reduce attack surfaces, and design immune code.
  30. Use the DBMS_ASSERT package and test code for SQL injection flaws.