Exam Number: 1Z0-148
Exam Title: Oracle Database: Advanced PL/SQL
Associated Certification Paths Oracle Database PL/SQL Developer Certified Professional
Duration: 110
Number of Questions: 75
Passing Score: 62%
Format: Multple Choice
Complete Recommended Training
Oracle Database 12c: Advanced PL/SQL
Oracle Database 11g: Advanced PL/SQL
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-148: Oracle Database 12c: Advanced PL/SQL
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
QUESTION 1
Which three statements are correct with reference to intra unit inlining?
A. Inlining will always decrease the size of a unit.
B. Setting PLSQL_OPTIMIZE_LEVEL to 2 means automatic inlining is attempted.
C. You cannot inline an external subroutine.
D. Programs that make use of smaller helper subroutines are good candidates for inlining.
E. Pragmas apply only to calls in the next statement following the pragma.
F. You cannot inline local subroutines.
Answer: C,D,E
Explanation: References:
QUESTION 2
Which two statements are true regarding edition-based redefinition (EBR)?
A. There is no default edition defined in the database.
B. EBR does not let you upgrade the database components of an application while in use.
C. You never use EBR to copy the database objects and redefine the copied objects in isolation.
D. Editions are non-schema objects.
E. When you change an editioned object, all of its dependents remain valid.
F. Tables are not editionable objects.
Answer: E,F
Explanation: References:
QUESTION 3
Which statement is true about the DBMS_PARALLEL_EXECUTE package?
A. DBMS_PARALLEL_EXECUTE is a SYS-owned package and can be accessed only by a user with DBA privileges.
B. To execute chunks in parallel, users must have CREATE JOB system privilege.
C. No specific system privileges are required to create or run parallel execution tasks.
D. Only DBAs can create or run parallel execution tasks.
E. Users with CREATE TASK privilege can create or run parallel execution tasks.
Answer: B
Explanation:
Referencehttps://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_parallel_ex.htm#A RPLS67331(security model)
QUESTION 4
Which two statements describe actions developers can take to make their application less vulnerable to security attacks?
A. Include the AUTHID DEFINER clause in stored program units.
B. Do not concatenate unchecked user input into dynamically constructed SQL statements.
C. Switch from using DBMS_SQL to EXECUTE IMMEDIATE.
D. Include the AUTHID CURRENT_USER clause in stored program units.
E. Increase the amount of code that is accessible to users by default.
Answer: B,D
QUESTION 5
Which statement is correct about DBMS_LOB.SETOPTIONS and
DBMS_LOB.GETOPTIONS for SecureFiles?
A. DBMS_LOB.GETOPTIONS can only be used for BLOB data types.
B. DBMS_LOB.SETOPTIONS can perform operations on individual SecureFiles but not an entire column.
C. DBMS_LOB. SETOPTIONS can set option types COMPRESS, DUPLICATE, and ENCRYPT.
D. If a table was not created with compression specified in the store as securefile clause then DBMS_LOB.SETOPTIONS can be used to enable it later.
Answer: D
Explanation: References:
QUESTION 6
Which two statements about the PL/SQL hierarchical profiler are true?
A. Access it using the DBMS_PROFILER package.
B. Access it using the DBMS_HPROF package.
C. Profiler data is recorded in tables and published in HTML reports.
D. It is only accessible after a grant of the CREATE PROFILE privilege.
E. It helps you identify subprograms that are causing bottlenecks in application performance.
Answer: B,E
Explanation: References:
Click here to view complete Q&A of 1Z0-148 exam
Certkingdom Review, Certkingdom PDF Torrents
Best Oracle 1Z0-148 Certification, Oracle 1Z0-148 Training at certkingdom.com