(1Z0-148)-Oracle Database : Advanced PL/SQL.


(1Z0-148)-Oracle Database : Advanced PL/SQL:

 

Course in Pre-Launch Mode, Total number of question will be around 75+.

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

1Z0-148 (OCP) practice test

This course contain 2 Practice test for Oracle Certification exam 1Z0-148 for Advanced PL/SQL

It cover 100% of Oracle exam 1Z0-134 certification syllabus.

You can find questions more on practical side,they will help you to solve your real time problems.

Exam Topics

Designing PL/SQL Code

 

  • Identify guidelines for cursor design

  • Use cursor variables

  • Use DBMS_SQL functions

  • Create subtypes based on existing types

Working with Collections

 

  • Manipulate collections

  • Distinguish between the different types of collections and their uses

  • Use nested collections

  • Use collection of objects

Using Advanced Interface Methods

 

  • Execute external C programs from PL/SQL

  • Execute Java programs from PL/SQL

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

Profiling and Tracing PL/SQL Code

 

  • Trace PL/SQL program execution

  • Profile PL/SQL applications

Safeguarding Your Code Against SQL Injection Attacks

 

  • Explain SQL injection

  • Reduce attack surfaces

  • Use DBMS_ASSERT

Multidisciplinary

 

  • Items wherein concepts across multiple objectives will be tested in each item

Creating and Managing Collections

 

  • Create and manage nested tables

  • Create and manage varrays

  • Create and manage associative arrays/PLSQL tables

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

Tuning PL/SQL Performance

 

  • Use native and interpreted compilation methods

  • Optimize PL/SQL code

  • Enable intraunit inlining

  • Use DBMS_PARALLEL_EXECUTE 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

Implementing Fine-Grained Access Control for VPD

Explain the process of fine-grained access control

Build security policies

Edition-Based Redefinition

 

  • Use Edition-Based Redefinition

Exam Details:

Duration: 110 Minutes

Number of Questions: 75

Passing Score: 62%

Who this course is for:

 

  • Any one who want to write 1Z0-148 exam
  • PL/SQL Professionals
  • Anyone who want to learn more about Advanced PL/SQL
  •  

 


FOR ENQUIRY