OCP Preparation|التحضير للشهادة الدولية

التحضير للشهادة الدولية OCP

·         التحضير للشهادة الدولية OCP  ليس بالأمر الصعب إلا انه يحتاج إلى مزيد من الدراسة والتمرين على الأسئلة وطريقة حلها ,  وحقيقة إن الحصول على هذه الشهادة يستحق عناء الدراسة والتمرين لما لها من سمعة  عالية وشهرة واسعة على مستوى العالم وبالأخص فى الوطن العربى  وهناك الكثير من الشركات والمشروعات الحكومية التى تشترط الحصول على هذه الشهادة للمتقدمين للتعيين لديها .

·         تتكون الشهادة من 3 اختبارات رئيسية وهى :

1.    SQL      (1Z0 - 051 Oracle Database 11g: SQL Fundamentals I )

2.    PLSQL (1Z0 – 144 Oracle Database 11g: Program with PL/SQL)

3.    Forms   (1Z0 – 151 Oracle Fusion Middleware 11g: Build Applications                       with Oracle Forms(

·         بعد اجتياز الامتحان الأول والثانى تحصل على شهادة OCA(Oracle Certified Associated )

·         ثم بعد اجتياز الإختبار الثالث تحصل على شهادة OCP(Oracle certified Proffesional)

·         الطريقة المتبعة فى التحضير للأمتحانات :

بعد الإنتهاء من دراسة كورس SQL  ,وتطبيق مفاهيمه عمليا على المشروع سنتوقف عن اكمال بقية الدورة لمدة اسبوع كامل للتحضير للأمتحان وحل الأسئلة من الإمتحانات السابقة مثل test king , pass4sure   وكذلك الحال مع بقية الإختبارات  PLSQL ,Forms .

فيما يلى كل التفاصيل اللازمة للحصول على الشهادة (تفاصيل الإختبارات وأماكن الإختبارات ):

تفاصيل الإختبارات :

كل مايخص تفاصيل الإختبارات واسعارها ونقاط الإختبار ومعدل النجاح وعدد الأسئلة  ونوعية الأسئلة , تكلفة الاختبارات الثلاثة 615 دولار موزعة كالتالى  :

·        SQL      125 $

·        PLSQL  245 $

·        Forms  245 $

(1)     1Z0 – 051   Oracle Database 11g: SQL Fundamentals I

       لمزيد من المعلومات يرجى زيارة الرابط التالى من شركة أوراكل :

https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=652&get_params=p_exam_id:1Z0-051

Oracle Database 11g: SQL Fundamentals I

Exam Number: 1Z0-051 Associated Certifications: Oracle Database 10g Administrator Certified Associate - retired , Oracle Database 11g Administrator Certified Associate , Oracle PL/SQL Developer Certified Associate , OPN Certified Specialist , Oracle Database 12c Administrator Certified Associate Exam Product Version: Oracle Database 11g Exam Price: US$ 125  Duration: 120 minutes Number of Questions: 64 Passing Score: 60% View passing score policy Validated Against: This exam has been validated against Oracle Database 10g and 11g Release 2 version 11.2.0.1.0. format: Multiple Choice

Exam Topics

Retrieving Data Using the SQL SELECT Statement 

·         List the capabilities of SQL SELECT statements

·         Execute a basic SELECT statement

Restricting and Sorting Data

·         Limit the rows that are retrieved by a query

·         Sort the rows that are retrieved by a query 

·         Use ampersand substitution to restrict and sort output at runtime

Using Single-Row Functions to Customize Output 

·         Describe various types of functions available in SQL

·         Use character, number, and date functions in SELECT statements

Using Conversion Functions and Conditional Expressions

·         Describe various types of conversion functions that are available in SQL

·         Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions 

·         Apply conditional expressions in a SELECT statement

Reporting Aggregated Data Using the Group Functions 

·         Identify the available group functions

·         Describe the use of group functions 

·         Group data by using the GROUP BY clause 

·         Include or exclude grouped rows by using the HAVING clause

Displaying Data from Multiple Tables 

·         Write SELECT statements to access data from more than one table using equijoins and nonequijoins

·         Join a table to itself by using a self-join 

·         View data that generally does not meet a join condition by using outer joins 

·         Generate a Cartesian product of all rows from two or more tables

Using Subqueries to Solve Queries 

·         Define subqueries

·         Describe the types of problems that the subqueries can solve 

·         List the types of subqueries 

·         Write single-row and multiple-row subqueries

Using the Set Operators 

·         Describe set operators

·         Use a set operator to combine multiple queries into a single query 

·         Control the order of rows returned

Manipulating Data 

·         Describe each data manipulation language (DML) statement

·         Insert rows into a table 

·         Update rows in a table 

·         Delete rows from a table 

·         Control transactions

Using DDL Statements to Create and Manage Tables

·         Categorize the main database objects

·         Review the table structure 

·         List the data types that are available for columns 

·         Create a simple table 

·         Explain how constraints are created at the time of table creation 

·         Describe how schema objects work

Creating Other Schema Objects

·         Create simple and complex views

·         Retrieve data from views 

·         Create, maintain, and use sequences 

·         Create and maintain indexes 

·         Create private and public synonyms

(2)     1Z0 – 144   Oracle Database 11g: Program with PL/SQL

لمزيد من المعلومات برجاء زيارة الرابط التالى من شركة أوراكل

https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-144

Oracle Database 11g: Program with PL/SQL

Exam Number: 1Z0-144 Associated Certifications: Oracle Advanced PL/SQL Developer Certified Professional , Oracle PL/SQL Developer Certified Associate Exam Product Version: Oracle Database 11g Exam Price: US$ 245  Duration: 90 minutes Number of Questions: 63 Passing Score: 65% View passing score policy Validated Against: This exam has been validated against Oracle Database 10g, Oracle Database 11g, Oracle Database 11g Release 2, and Oracle Database 12c Release 1. format: Multiple Choice

Exam Topics

Oracle Database 11g: PL/SQL Fundamentals

·         Introduction to PL/SQL

·         Explain the need for PL/SQL

·         Explain the benefits of PL/SQL

·         Identify the different types of PL/SQL blocks

·         Output messages in PL/SQL

·         Declaring PL/SQL Variables

·         Recognize valid and invalid identifiers

·         List the uses of variables, declare and initialize variables, use bind variables

·         List and describe various data types using the %TYPE attribute

·         Writing Executable Statements

·         Identify lexical units in a PL/SQL block

·         Use built-in SQL functions in PL/SQL and sequences in PL/SQL expressions

·         Describe when implicit conversions take place and when explicit conversions have to be dealt with

·         Write nested blocks and qualify variables with labels

·         Write readable code with appropriate indentation

·         Interacting with the Oracle Database Server

·         Create PL/SQL executable blocks using DML and transaction control statements

·         Make use of the INTO clause to hold the values returned by a SQL statement

·         Writing Control Structures

·         Identify the uses and types of control structures (IF, CASE statements and expressions)

·         Construct and identify loop statements

·         Apply guidelines when using conditional control structures

·         Working with Composite Data Types

·         Create user-defined PL/SQL records

·         Create a record with the %ROWTYPE attribute

·         Create an INDEX BY table and INDEX BY table of records

·         Describe the differences among records, tables, and tables of records

·         Using Explicit Cursors

·         Distinguish between usage of implicit and explicit cursors, use SQL cursor attributes

·         Declare and control explicit cursors, use simple loops and cursor FOR loops to fetch data

·         Declare and use cursors with parameters

·         Lock rows with the FOR UPDATE clause and reference the current row with the WHERE CURRENT OF clause

·         Handling Exceptions

·         Define PL/SQL exceptions

·         Recognize unhandled exceptions

·         Handle different types of exceptions (pre-defined exceptions, non-predefined exceptions and user-defined exceptions)

·         Propagate exceptions in nested blocks and call applications

·         Creating Stored Procedures and Functions

·         Differentiate between anonymous blocks and subprograms

·         Create a simple procedure and invoke it from an anonymous block

·         Create a simple function

·         Create a simple function that accepts a parameter

·         Differentiate between procedures and functions

Oracle Database 11g: Develop PL/SQL Program Units

·         Creating Procedures

·         Differentiate between anonymous blocks and subprograms, use a modularized and layered subprogram design, and identify the benefits of subprograms

·         Create a simple procedure and invoke it from an anonymous block

·         Work with procedures

·         Handle exceptions in procedures, remove a procedure, and display a procedure's information

·         Creating Functions

·         Differentiate between a procedure and a function

·         Describe the uses of functions

·         Work with functions (create, invoke and remove functions)

·         Creating Packages

·         Identify the benefits and the components of packages

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

·         Working with Packages

·         Overload package subprograms, use forward declarations

·         Create an initialization block in a package body

·         Manage persistent package data states for the life of a session and use PL/SQL tables and records in packages

·         Using Oracle-Supplied Packages in Application Development

·         Describe how the DBMS_OUTPUT package works

·         Use UTL_FILE to direct output to operating system files

·         Describe the main features of UTL_MAIL

·         Using Dynamic SQL

·         Describe the execution flow of SQL statements

·         Use Native Dynamic SQL (NDS)

·         Use the DBMS_SQL package

·         Design Considerations for PL/SQL Code

·         Create standard constants and exceptions

·         Write and call local subprograms

·         Control the run-time privileges of a subprogram

·         Perform autonomous transactions

·         Use NOCOPY hint, PARALLEL ENABLE hint and DETERMINISTIC clause

·         Use bulk binding and the RETURNING clause with DML

·         Creating Triggers

·         Describe different types of triggers and their uses

·         Create database triggers

·         Manage triggers

·         Creating Compound, DDL, and Event Database Triggers

·         Create triggers on DDL statements

·         Create triggers on system events

·         Using the PL/SQL Compiler

·         Describe the new PL/SQL compiler and features

·         Use the new PL/SQL compiler initialization parameters

·         Use the new PL/SQL compile time warnings

·         Managing PL/SQL Code

·         Describe and use conditional compilation

·         Hide PL/SQL source code using dynamic obfuscation and the Wrap utility

·         Managing Dependencies

·         Track and manage procedural dependencies

(3)  1Z0 - 151__Oracle Fusion Middleware 11g: Build Applications with Oracle Forms

https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-151

Oracle Fusion Middleware 11g: Build Applications with Oracle Forms
Exam Number: 1Z0-151 Associated Certifications: Oracle Certified Professional, Oracle Fusion Middleware 11g Forms Developer Exam Product Version: Forms and Reports Exam Price: US$ 245  Duration: 135 minutes Number of Questions: 80 Passing Score: 65% View passing score policy Validated Against: This exam has been validated against 11g. format: Multiple Choice

Exam Topics

Introduction to Oracle Forms Builder and Oracle Forms Services

·         Describe the components of Oracle Fusion Middleware 11g

·         Describe the features and benefits of Oracle Forms Services and Oracle Forms Builder

·         Describe the architecture of Oracle Forms Services

·         Describe the course application

Running an Oracle Forms Application

·         Start WebLogic Server

·         Describe the run-time environment

·         Describe the elements in a running form

·         Navigate a Forms applicatio

·         Describe the two main modes of operation

·         Run a form in a Web browser

·         Retrieve both restricted and unrestricted data

·         Insert, update, and delete records

·         Display database errors

Working in the Forms Builder Environment

·         Describe Forms Builder components

·         Navigate the Forms Builder interface

·         Identify the main objects in a form module

·         Customize the Forms Builder sessionUse the online help facilities

·         Use the online help facilities

·         Identify the main Forms executables

·         Describe the form module types

·         Set environment variables for design and run time

·         Run a form from within Forms Builder

Creating a Basic Form Module

·         Create a form module

·         Create a data block

·         Save and run a form module

·         Identify form file formats and their characteristics

·         Describe how to deploy a Forms application

·         Explain how to create documentatoin for a Forms application

Creating a Master-Detail Form

·         Create data blocks that have relationships with one another

·         Run a master-detail form module

·         Modify a data block

·         Modify the layout of a data block

Working with Data Blocks and Frames

·         Identify the components of the Property Palette

·         Manage object propertiesCreate and use Visual Attributes

·         Control the behavior and appearance of data blocks

·         Control frame properties

·         Create data blocks that do not directly correspond to database tables

·         Delete data blocks and their components

Working with Text Items

·         Describe text items

·         Create a text item

·         Modify the appearance of a text item

·         Control the data in a text item

·         Alter the navigational behavior of a text item

·         Enhance the relationship between the text item and the database

·         Add functionality to a text itemDisplay helpful messages

·         Enhance the relationship between the text item and the database

Creating LOVs and Editors

·         Describe LOVs and editors

·         Design, create, and associate LOVs with text items in a form

·         Create editors and associate them with text items in a form

Creating Additional Input Items

·         Identify the item types that allow input

·         Create a check box

·         Create a list item

·         Create a radio group

Creating Noninput Items

·         Identify item types that do not allow input

·         Create a display item

·         Create an image item

·         Create a button

·         Create a calculated item

·         Create a hierarchical tree ite

·         Create a bean area ite

Creating Windows and Content Canvases

·         Describe the relationship between windows and content canvases

·         Create windows and content canvases

·         Display a form module in multiple windows

·         Display a form module on multiple layouts

Working with Other Canvas Types

·         Describe the different types of canvases and their relationships to each other

·         Identify the appropriate canvas type for different scenarios

·         Create an overlay effect by using stacked canvases

·         Create a toolbar

·         Create a tabbed interface

Introduction to Triggers

·         Describe triggers

·         Identify the different trigger categories

·         Plan the type and scope of triggers in a form

·         Explain how trigger properties affect trigger behavior

Producing Triggers

·         Write trigger code

·         Explain the use of built-in subprograms in Forms applications

·         Describe the When-Button-Pressed trigger

·         Describe the When-Window-Closed trigger

Debugging Triggers

·         Describe the components of the debug console

·         Use the Run Form Debug button to run a form module in debug mode

·         Explain how to use remote debugging

·         Debug PL/SQL code

Adding Functionality to Items

·         Supplement the functionality of input items by using triggers and built-ins

·         Supplement the functionality of noninput items by using triggers and built-ins

Run-Time Messages and Alerts

·         Describe the default messaging behavior of a form

·         Handle run-time failure of built-in subprograms

·         Identify the different types of forms messages

·         Control system messages

·         Create and control alerts

·         Handle database server errors

Query Triggers

·         Explain the processes involved in querying a data block

·         Describe query triggers and their scope

·         Write triggers to screen query conditions

·         Write triggers to supplement query results

·         Control trigger action based on the form's query status

Validation

·         Explain the effects of the validation unit upon a form

·         Control validation

·         Describe how Forms tracks validation status

·         Control when validation occurs

Navigation

·         Distinguish between internal and external navigation

·         Control navigation with properties

·         Describe and use navigation triggers

·         Use navigation built-ins in triggers

Transaction Processing

·         Explain the process used by Forms to apply changes to the database

·         Describe the commit sequence of events

·         Supplement transaction processing

·         Allocate sequence numbers to records as they are applied to tables

·         Implement array data manipulation language (DML)

Writing Flexible Code

·         Describe flexible code

·         Explain the advantages of using system variables

·         Identify built-in subprograms that assist flexible coding

·         Write code to reference objects

Sharing Objects and Code

·         Describe the various methods for reusing objects and code

·         Inherit properties from property classes

·         Group related objects for reuse

·         Explain the inheritance symbols in the Property Palette

·         Reuse objects from an object library

·         Reuse PL/SQL code

Using WebUtil to Interact with the Client

·         Describe the benefits of the WebUtil utility

·         Integrate WebUtil into a form

·         Use WebUtil to interact with the client machine

Introducing Multiple Form Applications

·         Call one form module from another

·         Define multiple form functionality

·         Share data among open forms

Creating a Menu Module

·         Describe the different components of a menu module

·         Create, save and attach menu modules

·         Set menu properties using the Property Palette

·         Create menu toolbars

·         Create pop-up menus

Managing Menu Modules

·         Control menus programmatically

·         Manage the interaction between the menu and form documents

·         Implement application security through the menu