In this course, you will only get the exam practice questions. There are not any lectures on these exams. These tests are simulations of what the real exam will be like. If you face these practice tests, you’ll be in good shape for the actual exam.
Review Exam topics: Exam Code: 1Z0-071 | Oracle 12c Database SQL
Review the Oracle 1Z0-071 Exam Details: Duration: 120 Minutes, No. Of Questions: 63, Passing Score: 78%,
Validation: This exam was validated against 11g Release 2 version 11.2.0.1.0 and up to 19c
Relational Database concepts
Retrieving Data using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using Group Functions
Displaying Data from Multiple Tables
Using Subqueries to Solve Queries
Using SET Operators
Managing Tables using DML statements
Managing Indexes Synonyms and Sequences
Use DDL to manage tables and their relationships
Managing Views
Controlling User Access
Managing Objects with Data Dictionary Views
Managing Data in Different Time Zones
Review Exam topics: Exam Code: 1Z0-144 | Oracle Database 11g: Program with PL/SQL
Review the Oracle 1Z0-144 Exam Details: Duration: 90 Minutes, No. Of Questions: 63, Passing Score: 65%,
Validation: This exam has been validated against Oracle Database 10g, Oracle Database 11g, Oracle Database 11g Release 2, and Oracle Database 12c Release 1.
Oracle Database 11g: PL/SQL Fundamentals
Oracle Database 11g: Develop PL/SQL Program Units
Review Exam topics: Exam Code: 1Z0-148 | Oracle Database - Advanced PL/SQL
Review the Oracle 1Z0-144 Exam Details: Duration: 110 Minutes, No. Of Questions: 75, Passing Score: 62%,
Designing PL/SQL Code
Creating and Managing Collections
Working with Collections
Manipulating Large Objects
Using Advanced Interface Methods
Tuning PL/SQL Performance Improving Performance with Caching
Analyzing PL/SQL Code
Profiling and Tracing PL/SQL Code
Implementing Fine-Grained Access Control for VPD
Safeguarding Your Code Against SQL Injection Attacks
Edition-Based Redefinition
Multidisciplinary