Certification Provider: Oracle
Exam Name: Oracle Database 12c Advanced PL/SQL
Number of questions in our database: 107
1Z0-148 Exam Official Topics:
- Topic 1: Differentiate between internal and external LOBs/ Use native and interpreted compilation methods
- Topic 2: Distinguish between the different types of collections and their uses/ Explain the process of fine-grained access control
- Topic 3: Use the DBMS_METADATA package for creation DDL that can be used to re-create the objects/ Create subtypes based on existing types
- Topic 4: Implementing Fine-Grained Access Control for VPD/ Execute external C programs from PL/SQL
- Topic 5: Items wherein concepts across multiple objectives will be tested in each item/
Handle session dependencies in a result cache function/ Identify guidelines for cursor design
- Topic 6: Safeguarding Your Code Against SQL Injection Attacks/ Set up PL/SQL functions to use PL/SQL result caching
- Topic 7: Enable intraunit inlining/ Identify when to result cache a function/ Use the supplied packages and dictionary views to find coding information
- Topic 8: Create and manage associative arrays/PLSQL tables, Execute Java programs from PL/SQL
- Topic 9: Explain invalidation of cache results/ Create and maintain LOB data types/ Using Advanced Interface Methods
Submit Cancel