We're so confident of our products that we provide no hassle product exchange.
Introduction to 1z0-148 Exam
The Oracle Database - Advanced PL/SQL (1Z0-148) certification builds on the oracle database skills measured by the Oracle. The Oracle 1Z0-148 certification is principally focused to those candidates who has some expertise or exposure of Oracle info 12c and wish to flourish their career with Oracle Database PL/SQL Developer Certified Professional (OCP) credential
1z0-148 Exam is a certification exam that is conducted by Oracle to validates candidate knowledge and help to provide advance understanding of the oracle 12c database. The Oracle Database - Advanced PL/SQL certification exam approve your comphrension of the Oracle info 12c technology and sets the stage for your future advancement.
After passing this exam, candidates get a certificate from Oracle that helps them to demonstrate their knowledge in oracle database having in depth knowledge in terms of PL/SQL.
How much 1z0-148 Exam cost
1z0-148 exam cost is $245 USD.
Oracle 1z1-148 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle Database: Advanced PL/SQL |
| Exam Number: | 1Z0-148 |
| Related Certifications: | Oracle Database SQL (1Z0-071) Oracle Database Program with PL/SQL (1Z0-149) |
| Exam Format: | Multiple choice |
| Available Languages: | English, Japanese |
| Exam Price: | USD $245 (approx.) |
| Passing Score: | 60% (approx.) |
| Exam Duration: | 120 minutes |
| Certificate Validity Period: | No expiry (certification does not expire) |
| Real Exam Qty: | 70–85 |
| Sample Questions: | Oracle 1z1-148 Sample Questions |
| Exam Way: | Onsite at test center or online proctored delivery |
| Pre Condition: | Recommended: Experience with PL/SQL programming and Oracle Database, and passing Oracle Database SQL (1Z0-071) or equivalent foundation knowledge |
| Official Syllabus URL: | https://education.oracle.com/oracle-database-pl-sql-developer-certified-professional/trackp_OCPPLSQL19C |
The candidate is required to have passed any of the following Oracle certification exams in order to pass the 1Z0-148 test and receive the Oracle DB PL/SQL Developer Certified Professional certificate:
- 1Z0-144 (Oracle DB 11g)
- 1Z0-071 (Oracle Database SQL)
- 1Z0-061 (Oracle DB 12c: SQL Fundamentals). This exam is going to be retired on November 30, 2019.
Those students who wish to take the exam have to pay 245$. Registration for the test can be done online at the Pearson VUE website.
Oracle 1z1-148 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Designing PL/SQL Code | - Guidelines for cursor design and use of cursor variables - Use of DBMS_SQL functions and advanced constructs |
| Topic 2: Security and Code Robustness | - Implement error handling and mitigate SQL injection |
| Topic 3: Performance and Caching | - Optimize PL/SQL performance, result caching and parallel execution |
| Topic 4: Analyzing and Profiling PL/SQL Code | - Trace and profile code using supplied packages |
| Topic 5: Advanced Interface Methods | - Execute external C programs and Java programs from PL/SQL |
| Topic 6: Working with Collections | - Create and manage nested tables, varrays, associative arrays |
| Topic 7: Manipulating Large Objects (LOBs) | - Create and maintain LOB data types and use DBMS_LOB |
By Harlan
