1Z0-148 - Oracle Database: Advanced PL/SQL
3.1 (11 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
56 students enrolled

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

Crack Oracle Database 12c : Advanced PL/SQL (OCP) Certification Exam.
3.1 (11 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
56 students enrolled
Created by Karan Singhal
Last updated 4/2019
English
1Z0-148 - Oracle Database: Advanced PL/SQL
Current price: $20.99 Original price: $29.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 Practice Tests
  • Full lifetime access
  • Access on mobile
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
Requirements
  • Knowledge of Oracle PL/SQL is must to have
Included in This Course
+ Practice Tests
2 Tests 75 questions
Oracle Database: Advanced PL/SQL | 1Z0-148
40 questions
Oracle Database: Advanced PL/SQL | 1Z0-148
35 questions
Description

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