Exam Title:	Oracle Database SQL
Exam Number:	1Z0-148
Exam Price:	€220 More on exam pricing
Format:	Multiple Choice

Duration:	110 minutes
Number of Questions:	75
Passing Score:	62%
Validated Against:	Exam has been validated against Oracle Database 12c.

Exam Preparation

Take Recommended Training Courses

Complete one of the courses below to prepare for your exam (optional):

Oracle Database 12c: Advanced PL/SQL
Oracle Database 11g: Advanced PL/SQL
Oracle Database Administration Learning Subscription
Oracle Database Developer Learning Subscription
Unlimited Product Learning Subscription

Additional Preparation and Information

A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

Oracle Database 12c: Program with PL/SQL
Oracle Database 12c: SQL and PL/SQL Fundamentals

Practice Exams: Oracle Authorized practice exam from Kaplan IT Training: 1Z0-071 DBCert: Oracle Database SQL

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

Register for and take your exam

Take the Test when you're ready - Buy an Exam Voucher

Purchase an exam voucher now and redeem it within 6 months - it's like a gift card.

Schedule Your Exam Now

If you're ready to take your exam, schedule it now and pay directly with a credit card, or redeem a voucher you’ve purchased from Oracle. Either way, you'll schedule it through our external testing provider, PearsonVue.

After The Exam

Within 30 minutes of completing your Oracle Certification exam, you will receive an email from Oracle notifying you that your exam results are available in CertView. If you have previously authenticated your CertView account, simply login and select the option to “See My New Exam Result Now”. If you have not authenticated your CertView account yet at this point, you will need to proceed with your account authentication.

Authentication requires an Oracle Single Sign On username and password and the following information from your Pearson VUE profile: email address and Oracle Testing ID. You will be taken to CertView to log in once your account has been authenticated.