Oracle Project Portfolio Management Cloud 2017 Implementation Essentials (1Z0-964) Practice Exam

Oracle Project Portfolio Management Cloud 2017 Implementation Essentials (1Z0-964) is a certification exam provided by Oracle that assesses a candidate’s knowledge and skills in implementing and managing Oracle's Project Portfolio Management (PPM) Cloud solutions. The certification attests your skills in the various aspects of project management cloud like project planning, execution, resource management, financial management, and portfolio analysis. The exam certifies your skills in complying with the best practices in Oracle's project and portfolio management cloud-based tool.
Why is Oracle Project Portfolio Management Cloud 2017 Implementation Essentials (1Z0-964) important?

• Attests to your skills in Oracle's Project Portfolio Management Cloud implementations.
• Boosts career opportunities in project management and portfolio analysis.
• Showcases your ability to manage project costs, resources, and schedules effectively.
• Validates your Oracle's PPM cloud implementation's compliance with industry standards for project management practices.
• Increases your knowledge of integrating financial management with project execution.
• Globally recognized certificate.
  
• Improves your credibility for senior roles in project management roles within Oracle environments.

Who should take the Oracle Project Portfolio Management Cloud 2017 Implementation Essentials (1Z0-964) Exam?

• Oracle PPM Cloud Consultants
• Project Managers
• Portfolio Managers
• Resource Managers
• Financial Analysts specializing in project finance
• Implementation Consultants for Oracle PPM
• Cloud Solutions Architects focusing on project management
• IT Project Managers

Skills Evaluated

Candidates taking the certification exam on the Oracle Project Portfolio Management Cloud 2017 Implementation Essentials (1Z0-964) is evaluated for the following skills:

• Implementing and configuring Oracle Project Portfolio Management Cloud.
• Managing project planning, execution, and resource allocation.
• Understanding financial management processes related to projects.
• Analyzing project performance and portfolio health.
• Configuring dashboards and reporting for project management insights.
• Integrating PPM with other Oracle Cloud applications.
• Utilizing best practices in project and portfolio management.

Oracle Project Portfolio Management Cloud 2017 Implementation Essentials (1Z0-964) Certification Course Outline
The Oracle Project Portfolio Management Cloud 2017 Implementation Essentials (1Z0-964) Certification covers the following topics -

Module 1. Declaring PL/SQL Variables

• Recognize valid and invalid identifiers

• Listing the uses of variables, declare and initialize variables, use bind variables

• Listing and describing various data types using the %TYPE and %ROWTYPE attributes

Module 2. Writing Executable Statements

• Identifying lexical units in a PL/SQL block

• Using built-in SQL functions in PL/SQL and sequences in PL/SQL expressions

• Describing when implicit conversions take place and when explicit conversions have to be dealt with

• Writing nested blocks and qualify variables with labels

• Writing readable code with appropriate indentation

Module 3. Writing SQL in PL/SQL

• Creating PL/SQL executable blocks using DML and transaction control statements

• Making use of the INTO clause to hold the values returned by a SQL statement

Module 4. Writing Control Structures

• Identifying the uses and types of control structures (IF, CASE statements and expressions)

• Constructing and identifying loop statements

• Using EXIT and CONTINUE statements inside loops

Module 5. Working with Composite Data Types

• Creating user-defined PL/SQL records

• Creating a record with the %ROWTYPE attribute

• Creating an INDEX BY table and INDEX BY table of records

• Describing the differences among records, collections, and collections of records

• Initializing collections and records

Module 6. Using Explicit Cursors

• Distinguishing between implicit and explicit cursors and use SQL cursor attributes

• Declaring and controlling explicit cursors, use simple loops and cursor FOR loops to fetch data

• Declaring and using cursors with parameters

• Locking rows with the FOR UPDATE clause and reference the current row with the WHERE CURRENT OF clause

Module 7. Handling Exceptions

• Defining PL/SQL exceptions

• Recognizing unhandled exceptions

• Handling different types of exceptions (internally defined exceptions, predefined exceptions and user-defined exceptions)

• Propagating exceptions

Module 8. Using PL/SQL Subprograms

• Differentiating between anonymous blocks and subprograms

• Creating a simple procedure and invoke it from an anonymous block

• Identifying benefits of subprograms

Module 9. Creating Procedures and Using Parameters

• Creating a procedure with parameterrs

• Using named notation

• Working with procedures (create, invoke and remove procedures)

• Handling exceptions in procedures and display a procedure's information

Module 10. Creating Functions

• Differentiating between a procedure and a function

• Describing the uses of functions

• Working with functions (create, invoke and remove functions)

Module 11. Creating Packages

• Identifying the benefits and the components of packages

• Working with packages (create package specification and body, invoke package subprograms, remove a package and display package information)

• Overloading package subprograms and use forward declarations

Module 12. Working with Packages

• Using package types and variables

• Using packaged constants and functions in SQL

• Using ACCESSIBLE BY to restrict access to package subprograms

Module 13. Using Dynamic SQL

• Describing the execution flow of SQL statements

• Using Native Dynamic SQL (NDS)

• Binding PL/SQL types in SQL statements

Module 14. Design Considerations for PL/SQL Code

• Creating standard constants and exceptions

• Writing and calling local subprograms

• Controlling the run-time privileges of a subprogram

• Performing autonomous transactions

• Using NOCOPY hint, PARALLEL ENABLE hint and DETERMINISTIC clause

• Using bulk binding and the RETURNING clause with DML

Module 15. Creating Compound, DDL, and Event Database Triggers

• Creating triggers on DDL statements

• Creating triggers on system events

• Describing different types of triggers and their uses

Module 16. Using the PL/SQL Compiler

• Describing the PL/SQL compiler and features

• Using the PL/SQL compiler initialization parameters

• Using the PL/SQL compile time warnings

Module 17. Managing PL/SQL Code

• Describing and using conditional compilation

• Code-based access controlling: granting roles to program units

• Whitelisting code access with the ACCESSIBLE BY clause

• Marking code as deprecated

Module 18. Managing Dependencies

• Tracking and managing procedural dependencies