1Z0-148: Oracle Database 12c - Advanced PL/SQL


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