Forum Stats

  • 3,723,799 Users
  • 2,244,619 Discussions


Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

IZ0-146 exam preparation

Ora-aff Member Posts: 179 Blue Ribbon
I am OCA with IZ0-047 SQL Expert and IZ0-147 Program with PL SQL passed. I am preparing for IZ0-146 Advanced PL SQL, however, I am finding it difficult to prepare as there are no books that target specifically the exam. I bought Oracle 11g Programming with PL SQL By Steven Feurestien and Oracle 11g Program with PL SQL by Michael Mclaughlin. Overall, I am not happy with either of these books as they assume reader already knows many things or the books are simply written for experienced programmers. Apart from these books I have also downloaded few Oracle reference guides. So I have categorized the exam topics based on from where I will study them.

*1. Design Considerations* *(McLaughlin)*
Describe the predefined data types
Create subtypes based on existing types for an application
List the different guidelines for cursor design
Use cursor variables
Pass cursor variables as program parameters
Compare cursor variables to static cursors

*2. Using Collections* *(McLaughlin)*
Overview of collections
Use Associative arrays
Use Nested tables
Use Varrays
Write PL/SQL programs that use collections
Use Collections effectively

*3. Using Advanced Interface Methods* *(Oracle referenced guide)*
Calling C from PL/SQL
Calling Java from PL/SQL

*4. Implementing VPD with Fine-Grained Access Control* *(Oracle referenced guide)*
Understand how fine-grained access control works overall
Describe the features of fine-grained access control
Describe an application context
Create an application context
Set an application context
List the DBMS_RLS procedures
Implement a policy
Query the dictionary views holding information on fine-grained access

*5. Manipulating Large Objects* *(McLaughlin)*
Describe a LOB object
Manage internal LOBs
Describe BFILEs
Create and use the DIRECTORY object to access and use BFILEs
Describe the DBMS_LOB package
Remove LOBs
Create a temporary LOB programmatically with the DBMS_LOB package

*6. Administering SecureFile LOBs* *(Oracle referenced guide)*
Introduction to SecureFile LOBs
Enable the environment for SecureFile LOBs
Use SecureFile LOBs to store documents
Convert BasicFile LOBs to SecureFile LOB format
Examine the performance of SecureFile LOBs
Enable deduplication and compression
Enable encryption

*7. Tuning and Performance* *(Yet to know where to study)*
Understand and influence the compiler
Tune PL/SQL code
Enable intra unit inlining
Identify and tune memory issues

*8. Improving Performance with SQL and PL/SQL Caching* *(Yet to know where to study)*
Describe result caching
Use SQL query result cache
PL/SQL function cache

*9. Analyzing PL/SQL Code* *(Yet to know where to study)*
Use the supplied packages and dictionary views to find coding information
Determine identifier types and usages with PL/Scope
Use the DBMS_METADATA package to obtain metadata from the data dictionary as -
XML or creation DDL that can be used to re-create the objects

*10. Profiling and Tracing PL/SQL Code* *(Feurestein)*
Trace PL/SQL program execution
Profile PL/SQL applications

*11. Safeguarding Your Code Against SQL Injection Attacks* *(Yet to know where to study)*
Describe SQL injections
Reduce attack surfaces
Design immune code
Test code for SQL injection flaws

Please let me know if I am missing anything. And also helpme with Yet to know where to study+ topics. Am I underestimating Steven Feurestein Book? Thanks
This discussion has been closed.