Full Name: Oracle Database 12c - Advanced PL/SQL
Exam Code: 1Z0-148
Oracle 1Z0-148 Exam Details:
Exam Name
|
Oracle Database - Advanced PL/SQL
|
Exam Code
|
1Z0-148
|
Exam Product Version
|
Oracle Database 12c
|
Exam Price
|
USD $245 (Price may vary by country or by localized currency)
|
Duration
|
110 minutes
|
Number of Questions
|
75
|
Passing Score
|
62%
|
Recommended Training
|
|
Format
|
Multiple Choice Questions (MCQ)
|
Recommended Training
|
|
Recommended Practice
|
Oracle 1Z0-148 Syllabus Topics:
Designing PL/SQL Code | -- Identify guidelines for cursor design - Use cursor variables - Use DBMS_SQL functions - Create subtypes based on existing 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 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 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 |
Edition-Based Redefinition | - Use Edition-Based Redefinition |
Multidisciplinary | - Items wherein concepts across multiple objectives will be tested in each item |
0 comments:
Post a Comment