إنتقال للمحتوى

  • تسجيل الدخول عبر الفيس بوك تسجيل الدخول عبر تويتر Log In with LinkedIn Log In with Google      تسجيل دخول    
  • إنشاء حساب

صورة
* * * * - 4 صوت

هنا تفاصيل عن اختبارات الديفيلوبير وأرقامها والمنهج المقرر


155 رد (ردود) على هذا الموضوع

#1 sara gamal

sara gamal

    عضو نشط

  • الأعضــاء
  • 411 مشاركة
  • البـلـد: Country Flag

تاريخ المشاركة 18 July 2009 - 01:03 AM

السلام عليكم ورحمه الله وبركاته

في ناس كتير بتطلب الامتحانات وتفاصيل عنها وعشان بأذن الله الناس كلها تستفيد ومن يريد نماذج الاختبارات يراسلني على الخاص
ودى التفاصيل الخاصه بالامتحانات
امتحانات الديفلوبر مش محتاجه شهاده حضور ولأى حاجه وهي ثلاثه امتحانات

1-introduction to Oracle 9i-SQL 1z0-007 "لايوجد شهاده "
2-Program with pl/sql 1z0-147 " "شهاده ال OCA"
3-build internet applications forms 1z0-141 "شهاده ال OCP"

اسعار الامتحانات في الوقت الحالى
1-600
2-700
3-700
دى الاسعار في مصر
والاسعار بالدولار
1-$95.00
2-$125.00
3-$125.00
-----------------------------------------------------------------------------------------------------------------------------------------
وإليكم التفاصيل الكاملة لكل جزء من الاجزاء السابقة
بالنسبه لامتحان ال SQL:

الامتحان بيجى من SQL Fundamentals I
وال chapters المهمه في SQL Fundamentals IIهى :
Chapter 1,2,7
ودى المواضييع المطلوبه في الامتحان زي ما مكتوبه في موقع اوراكل
Writing Basic SQL Select Statements
[ ] List the capabilities of SQL SELECT statements
[ ] Execute a basic SELECT statement
[ ] Differentiate between SQL statements and iSQL*Plus commands

Restricting and Sorting Data
[ ] Limit the rows retrieved by a query
[ ] Sort the rows retrieved by a query

Single-Row Functions
[ ] Describe various types of functions available in SQL
[ ] Use character, number, and date functions in SELECT statements
[ ] Use conversion functions

Displaying Data from Multiple Tables
[ ] Write SELECT statements to access data from more than one table using equality and nonequality joins
[ ] View data that generally does not meet a join condition by using outer joins
[ ] Join a table to itself using a self-join

Aggregating Data using Group Functions
[ ] Identify the available group functions
[ ] Use group functions
[ ] Group data using the GROUP BY clause
[ ] Include or exclude grouped rows by using the HAVING clause
Subqueries
[ ] Describe the types of problems that subqueries can solve
[ ] Define subqueries
[ ] List the types of subqueries
[ ] Write single-row and multiple-row subqueries
%

Producing Readable Output with iSQL*Plus
[ ] Produce queries that require a substitution variable
[ ] Produce more readable output
[ ] Create and execute script files

Manipulating Data
[ ] Describe each DML statement
[ ] Insert rows into a table
[ ] Update rows in a table
[ ] Delete rows from a table
[ ] Merge rows in a table
[ ] Control transactions

Creating and Managing Tables
[ ] Describe the main database objects
[ ] Create tables
[ ] Describe the datatypes that can be used when specifying column definition
[ ] Alter table definitions
[ ] Drop, rename and truncate tables

Including Constraints
[ ] Describe constraints
[ ] Create and maintain constraints
Creating Views
[ ] Describe a view
[ ] Create, alter the definition, and drop a view
[ ] Retrieve data through a view
[ ] Insert, update and delete data through a view

Creating Other Database Objects
[ ] Create, maintain and use sequences
[ ] Create and maintain indexes
[ ] Create private and public synonyms


Subqueries
[ ] Describe the types of problems that subqueries can solve
[ ] Define subqueries
[ ] List the types of subqueries
[ ] Write single-row and multiple-row subqueries

Creating Views
[ ] Describe a view
[ ] Create, alter the definition, and drop a view
[ ] Retrieve data through a view
[ ] Insert, update and delete data through a view


بالنسبه لامتحان ال pl/sql:
طبعا اكتر تركيز في الاسئله بيكون من الprogram unit وارقام ال Chapters المهمه جدا فيها 1و2و3و4و6و8و10و11
وفي 3 اسئله ممكن يكونوا مش موجودين في الchapters دي موجودين في المرفقات
ودى المواضييع المطلوبه في الامتحان زي ما مكتوبه في موقع اوراكل:
Overview of PL/SQL Programs
[ ] Describe a PL/SQL program construct
[ ] List the components of a PL/SQL block
[ ] List the benefits of subprograms
[ ] Describe how a stored procedure/function is invoked

Creating Procedures
[ ] Define what a stored procedure is
[ ] List the development steps for creating a procedure
[ ] Create a procedure
[ ] Describe the difference between formal and actual parameters
[ ] List the types of parameter modes
[ ] List the methods for calling a procedure with parameters
[ ] Describe the DEFAULT option for parameters
[ ] Create a procedure with parameters
[ ] Invoke a procedure that has parameters
[ ] Define a subprogram in the declarative section of a procedure
[ ] Describe how exceptions are propagated
[ ] Remove a procedure
Creating Functions
[ ] Define what a stored function is
[ ] Create a function
[ ] List how a function can be invoked
[ ] List the advantages of user-defined functions in SQL statements
[ ] List where user-defined functions can be called from within an SQL statement
[ ] Describe the restrictions on calling functions from SQL statements
[ ] Remove a function
[ ] Describe the differences between procedures and functions
Managing Subprograms
[ ] Contrast system privileges with object privileges
[ ] Grant privileges
[ ] Contrast invokers rights with definers rights
[ ] Identify views in the data dictionary to manage stored objects

Creating Packages
[ ] Use DESCRIBE command to describe packages and list their possible components
[ ] Identify a package specification and body
[ ] Create packages: Create related variables , cursors, constants, exceptions, procedures, and functions
[ ] Designate a package construct as either public or private
[ ] Invoke a package construct
[ ] Use a bodiless package
[ ] Drop Packages
[ ] Identify benefits of Packages

More Package Concepts
[ ] Write packages that use the overloading feature
[ ] Use Forward Referencing
[ ] Describe errors with mutually referential subprograms
[ ] Initialize variables with a one-time-only procedure
[ ] Identify persistent states in package variables and cursors
[ ] Identify restrictions on using Packaged functions in SQL statements
[ ] Invoke packaged functions from SQL
[ ] Use PL/SQL tables and records in Packages

Oracle Supplied Packages
[ ] Describe the benefits of Execute Immediate over DBMS_SQL for Native Dynamic SQL
[ ] Identify the flow of execution
[ ] Use EXECUTE IMMEDIATE
[ ] Describe the use and application of some Oracle server-supplied packages: DBMS_SQL, DBMS_OUTPUT, UTL_FILE

Manipulating Large Objects
[ ] Compare and contrast LONG and large object (LOB) data types
[ ] Describe LOB datatypes and how they are used
[ ] Differentiate between internal and external LOBs
[ ] Identify and Manage Bfiles
[ ] Migrate from LONG To LOB
[ ] Use the DBMS_LOB PL/SQL package
[ ] Create LOB columns and populate them
[ ] Perform SQL operations on LOBS: Update LOBs with SQL, Select from LOBS, Delete LOBS
[ ] Describe the use of temporary LOBs

Creating Database Triggers
[ ] Describe the different types of triggers
[ ] Describe database triggers and their uses
[ ] List guidelines for designing triggers
[ ] Create a DML trigger
[ ] List the DML trigger components
[ ] Describe the trigger firing sequence options
[ ] Use conditional predicates in a DML trigger
[ ] Create a row level trigger
[ ] Create a statement level trigger
[ ] Use the OLD and NEW qualifiers in a database trigger
[ ] Create an INSTEAD OF trigger
[ ] Describe the difference between stored procedures and triggers
[ ] Describe the trigger execution model
[ ] Alter a trigger status
[ ] Remove a trigger

More Trigger Concepts
[ ] Define what a database trigger is
[ ] Describe events that cause database triggers to fire
[ ] Create a trigger for a DDL statement
[ ] Create a trigger for a system event
[ ] Describe the functionality of the CALL statement
[ ] Describe the cause of a mutating table
[ ] List what triggers can be implemented for
[ ] List the privileges associated with triggers
[ ] View trigger information in the dictionary views

Managing Dependencies
[ ] Track procedural dependencies
[ ] Describe dependent objects and referenced objects
[ ] View dependency information in the dictionary views
[ ] Describe how the UTLDTREE script is used
[ ] Describe how the IDEPTREE and DEPTREE procedures are used
[ ] Describe a remote dependency
[ ] List how remote dependencies are governed
[ ] Describe when a remote dependency is unsuccessfully recompiled
[ ] Describe when a remote dependency is successfully recompiled
[ ] List how to minimize dependency failures

بالنسبه لاخر امتحان ال forms:
بالنسبه للامتحان ده مفيش chapters معيينين جه منهم الامتحان بالعكس بتيجى حاجات من خارج ال chapters وكاطريقه مذاكره بالنسبالى انا ذاكرت من نماذج الامتحانات على طول وكل سؤال كنت بحاول اجاوبه ولو معرفتش الاجابه بشوفها وبدور عليها سواء من ال help او المنتدى عشان اتأكد ان الاجابه صح وفي نفس الوقت خلانى اذاكر مواضيع مش موجوده في الكتاب وبجد مفيده جدا
والموضوع مش صعب خالص
ودى المواضييع المطلوبه في الامتحان في موقع اوراكل:

Introduction to Oracle Forms Developer and Oracle Forms Services
[ ] Describe the components of Oracle9i Developer Suite and the Oracle9i Application Server
[ ] Describe the features and benefits of Oracle Forms Services and Oracle Forms Developer
[ ] Describe the architecture of Oracle Forms Services
[ ] Describe Forms Builder components
[ ] Navigate the Forms Builder interface
[ ] Customize the Forms Builder session
[ ] Use the online help facilities

Running a Forms Developer Application
[ ] Describe the run-time environment
__ Explain the role of each
__ Modify Forms environment variables
__ Describe the appearance of a form at run time
[ ] Navigate a Forms application
[ ] Retrieve both restricted and unrestricted data
[ ] Describe the two modes of operation
[ ] Insert, update, and delete records
[ ] Display database errors

Creating LOVs and Editors
[ ] Describe LOVs and editors
[ ] Design, create, and associate LOVs with text items in a form module
__ Describe the relationship between LOVs and record groups
__ Explain the steps to create an LOV manually
__ Use the LOV Wizard to create an LOV
__ Set LOV properties
[ ] Create editors and associate them with text items in a form module

Creating Additional Input Items
[ ] Describe the item types that allow input
[ ] Create a check box
[ ] Create a list item
[ ] Create a radio group

Creating Noninput Items
[ ] Describe 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 item
[ ] Create a bean area item

Creating Windows and Content Canvases
[ ] Define windows, content canvases, and viewports
[ ] Describe the relationship between windows and content canvases
[ ] Create windows and content canvases
[ ] Display a form module in multiple windows and 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
[ ] Define triggers
[ ] Describe the different trigger categories
[ ] Describe the components of a trigger
[ ] Describe the types of statements used in trigger code
[ ] Describe the properties that affect the behavior of a trigger

Working in the Forms Developer Environment
[ ] Describe the main Forms Developer executables
[ ] Describe the main Forms Developer module types
[ ] Describe the main objects in a form module
[ ] Run a form from within Forms Builder
__ Start and stop an OC4J instance
__ Set Forms Builder preferences to use OC4J

Creating a Basic Form Module
[ ] Create a form module
[ ] Create data blocks, create data blocks with relationships and create control blocks
[ ] Use wizards in re-entrant mode to make changes to the data block and layout
[ ] Save and compile a form module
[ ] Describe Forms file formats and their characteristics
[ ] Explain how to deploy a form module
[ ] Produce text files and documentation
[ ] Run a master-detail form module

Working with Data Blocks and Frames
[ ] Describe the methods to modify object properties
[ ] Describe the features of the Property Palette
[ ] Manipulate properties through the Property Palette
__ Display the Property Palette
__ Describe the property controls for different types of properties
__ Display multiple Property Palettes
__ Set properties on multiple objects
__ Copy properties
[ ] Control the behavior and appearance of data blocks
__ Use visual attributes
__ Use font, pattern, and color pickers
__ Set navigation properties
__ Set records properties
__ Set database properties
__ Set scrollbar properties
[ ] Control frame properties
[ ] Delete data blocks and their components

Working with Text Items
[ ] Describe text items
[ ] Create a text item
[ ] manage and modify text items using the property palette
[ ] Display helpful messages

Producing Triggers
[ ] Write trigger code
__ Create a trigger of appropriate type and scope
__ Describe the features of the PL/SQL Editor
__ Describe the features of the Database Trigger Editor
__ Explain the structure of trigger code
__ Use variables in triggers
[ ] 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 methods to debug triggers in Forms Builder
[ ] Describe the components of the Debug Console
[ ] Run a form module in debug mode by using the Run Form Debug button
[ ] Debug PL/SQL code
__ Set breakpoints in code
__ Step through code
__ View variable values while form is running

Adding Functionality to Items
[ ] Describe item interaction triggers
[ ] Supplement the functionality of input items by using triggers and built-ins
__ Code interactions with radio groups
__ Code interactions with check boxes
__ Change list items at run time
__ Display an LOV from a button
[ ] Supplement the functionality of noninput items by using triggers and built-ins
__ Populate image items
__ Populate hierarchical trees
__ Code interactions with JavaBeans in the bean area item

Run Time Messages and Alerts
[ ] Describe the default messaging behavior of a form
[ ] Handle run time failure of built-in subprograms
[ ] Describe the different types of Forms Builder messages
[ ] Cause a trigger to fail in a controlled manner
[ ] 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
[ ] Control query array processing
[ ] Write triggers to modify query behavior
[ ] Control trigger action based on the form's query status
[ ] Obtain query information at run time
Validation
[ ] Describe the validation process
[ ] Control validation:
__ Using object properties
__ Explain the effects of the validation unit upon a form
__ Use an LOV for validation
__ Using triggers
__ Using Pluggable Java Components
[ ] Describe how Forms tracks validation status
[ ] Control when validation occurs

Navigation
[ ] Describe how navigation affects the navigation unit and the cursor
[ ] Distinguish between internal and external navigation
[ ] Control navigation with properties
[ ] Describe and use navigation triggers to control navigation
[ ] Explain how the cursor can become stuck between two items, resulting in a navigation trap
[ ] 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
[ ] Describe the characteristics and uses of commit triggers
[ ] Supplement transaction processing
__ Perform delete validation
__ Allocate sequence numbers to records as they are applied to tables
__ Keep an audit trail
[ ] Test the results of trigger DML
[ ] Override default transaction processing
[ ] Describe how to run against a non-Oracle data source
[ ] Get and set the commit status
[ ] Implement array DML
Writing Flexible Code
[ ] Describe flexible code
[ ] Use system variables to determine:
__ Cursor focus
__ Trigger focus
__ Commit status
[ ] Describe built-in subprograms that assist flexible coding
Write code to reference objects:
__ By internal ID
__ Indirectly

Sharing Objects and Code
[ ] Describe benefits of reusing objects and code
[ ] Create and use property classes
__ Describe property classes
__ Create property classes
__ Add properties to property classes
__ Inherit properties from property classes
__ Explain the inheritance symbols in the Property Palette
[ ] Group related objects for reuse
[ ] Copy and subclass objects
[ ] Reuse objects from an object library
__ Describe object libraries
__ Describe the benefits of using object libraries
__ Create object libraries
__ Populate object libraries
__ Modify objects in an object library
__ Create and use SmartClasses
[ ] Reuse PL/SQL code

Introducing Multiple Form Applications
[ ] Describe the characteristics of multiple form applications
[ ] Describe the benefits of multiple form applications
[ ] Call one form from another form module
[ ] Define multiple form functionality
[ ] Share data among open forms
[ ] Control opening and closing of multiple forms
[ ] Synchronize data among multiple 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

Programming Function Keys
[ ] Define key triggers and their uses
[ ] Program function keys
[ ] Describe the characteristics of key triggers
[ ] Classify key triggers
[ ] Associate function keys with interface controls

Building Multiple Form Applications
[ ] Describe the various ways of invoking additional forms modules
[ ] Open and close form modules
[ ] Navigate between form modules
[ ] Control open form modules
[ ] Choose the most appropriate method for invoking forms

Defining Data Sources
[ ] Describe the various datasource types
[ ] Base a data block on a FROM clause query
[ ] Discuss the advantages of using a FROM clause query
[ ] Base a data block on a stored procedure that returns a REF cursor
[ ] Return a table of records from a stored procedure
[ ] Define a Data Source with the Data Block Wizard
[ ] Select the appropriate data source for a data block

Working with Record Groups
[ ] Describe the record group object
[ ] Use record groups
[ ] Define record groups at design time
[ ] Control record groups by using built-in functions
[ ] Define query record groups programmatically and nonprogrammatically
[ ] Manipulate record group rows
[ ] Define lists of values (LOVs) programmatically
[ ] Implement dynamic list items and add values to combo boxes

Using Database Objects in Forms Applications
[ ] Recognize which object types are supported
[ ] Describe how object types are represented within Form Builder
[ ] Create a block based on relation table with an object or an REF column
[ ] Populate a REF column with an LOV

اسألكم الدعواااات

ملفات مرفقة

  • ملف مرفق  Desktop.rar   89.63كيلو   2800 عدد مرات التحميل

  • chairman معجب بهذا

#2 Ahmad.Hasan

Ahmad.Hasan

    مشرف قسم الـ Forms & Reports والمشاريع

  • فريق الإشراف
  • 4,871 مشاركة
  • الاسم الأول:Ahmad
  • اسم العائلة:Hasan
  • البـلـد: Country Flag
  • المنصب الحالي:Oracle HCM Consultant

تاريخ المشاركة 18 July 2009 - 01:11 AM

السلام عليكم
بارك الله فيكي اخت سارة على هذا المجهود الرائع..
وجزاكي الله كل خير...
وننتظر المزيد والى الامام..
بالتوفيق

.Oracle E-Business Suite R12 HCM Certified Implementation Specialist

 

.Oracle Fusion Human Capital Management 11g Human Resources Certified Implementation Specialist

 


#3 sara gamal

sara gamal

    عضو نشط

  • الأعضــاء
  • 411 مشاركة
  • البـلـد: Country Flag

تاريخ المشاركة 18 July 2009 - 01:21 AM

جزانا وأياكم اخى pali.oracle وربنا يوفقك

#4 mustafagamiel

mustafagamiel

    مشرف قسم النماذج والمشاريع

  • فريق الإشراف
  • 2,095 مشاركة
  • البـلـد: Country Flag

تاريخ المشاركة 18 July 2009 - 01:38 AM

السلام عليكم
جزاكي الله كل خير إختنا الكريمة عن هذا الموضوع الرائع الموضوع مثبت لأهميته وكثرة السؤال عليه
ونمتنى من له إضافة بخصوص امتحانات ال dba يتم وضع مثل هذا الموضوع

اللهم إن كان رزقي في الســــــــــماء فأنزله
وإن كان في الأرض فأخرجـه
وإن كان بعيدا فقربه وإن كان قريبا فيسره
وإن كان قليلا فكثره وإن كان كثيرا فبارك لي فيه

اللـــهم آمين
لا إله إلا الله وحده لاشريك له- له الملك وله الحمد وهو على كل شيء قدير
لا إله إلا أنت سبحانك-- إني كنت من الظالمين






#5 sara gamal

sara gamal

    عضو نشط

  • الأعضــاء
  • 411 مشاركة
  • البـلـد: Country Flag

تاريخ المشاركة 18 July 2009 - 02:09 AM

جزانا وأياكم اخى مصطفى وربنا يكرمك ويجزيك خير على مجهودك معانا

#6 mmsalman87

mmsalman87

    عضو مميز

  • الأعضــاء
  • 1,689 مشاركة
  • الاسم الأول:Maher
  • اسم العائلة:Salman
  • البـلـد: Country Flag
  • المنصب الحالي:Senior Oracle HCM SaaS Pre Sale Consultant

تاريخ المشاركة 18 July 2009 - 10:45 AM

مشكورة كثير على المجهود الرائع والطيب اتمنى لك التوفيق والى الامام

                                                                                             

                                                                                                                  Maher Salman

• Oracle Fusion Human Capital Management 11g Human Resources Certified Implementation Specialist 

Taleo (TEE): Onboarding Administration Ed 3 LVC, Oracle University.

• Taleo (TBE): Recruit Essentials Ed 4.1 LVC, Oracle University.

• Oracle Fusion HCM Implementation, Oracle University.

• Oracle Certified Professional Developer (OCP) - Oracle Forms: Build Internet Applications.

• Oracle Certified Associate Developer (OCA).

• Oracle E-Business Suite R12 Human Capital Management Certified Implementation Specialist (HCM)

                                                                                                                                        
                                                                                                           http://learnoracle.net                                                                                                                

                                                                                                                             
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

أهم مواضيعي ( Oracle Developer )

- برنامج حفظ الكودات - My Codes

- كيفية عمل نظام متعدد اللغات

- انشاء شاشة دخول وتغيير كلمة السر والتحكم بالمستخدمين

- Import And Export On Toad

- التحكم في النظام من خلال الملف Formsweb.cfg

​- Advanced Dynamic List

- توليد ارقام وحروف عشوائية 

 

 

أهم مواضيعي ( Oracle HRMS)

 

Using Special Value set in oracle hrms 


#7 abu_sami

abu_sami

    مشترك

  • الأعضــاء
  • 82 مشاركة

تاريخ المشاركة 18 July 2009 - 11:48 AM

مشكووووووور
على هذه المشاركة الرائعة
والشكر موصول لمصطفى جميل
ولكل المشاركين الفعالين في المنتدى
جزاك الله خير
ابو سامي
أمتي :هل لك بين الأمم ------- منبر للسيف أو للقلم

#8 @nana@

@nana@

    عضو نشط

  • الأعضــاء
  • 284 مشاركة
  • البـلـد: Country Flag
  • الاهتمامات:Don't Say ,I Don't Know..But Try&& Error :(
    I Adore Oracle 4 Ever :D

تاريخ المشاركة 24 July 2009 - 12:53 AM

شكرا اوى ياباشمهندسة سااااااااااااارة

جزاكى الله خيراااااااااااااااااااااااااا


FatmaElgzar
https://www.facebook...acleJavaAcademy

http://www.facebook....gDream.Computer
Try 2 Change Ur Life 2 The Best
---------------------------------------
ياحى ياقيوم برحمتك أستغيث ، أصلح لى شأنى كله ولاتكلنى الى نفسى طرفة عين .

حسبى الله لااله الا هو ، عليه توكلت وهو رب العرش العظيم
--------------------------------------------------
905527214.gif


#9 mmsalman87

mmsalman87

    عضو مميز

  • الأعضــاء
  • 1,689 مشاركة
  • الاسم الأول:Maher
  • اسم العائلة:Salman
  • البـلـد: Country Flag
  • المنصب الحالي:Senior Oracle HCM SaaS Pre Sale Consultant

تاريخ المشاركة 24 July 2009 - 10:32 PM

ما الفرق بين الامتحانين التاليين :

1Z0-051 وهو Oracle Database 11g: SQL Fundamentals I
introduction to Oracle 9i-SQL 1z0-007
اعرف ان الفرق ان الاول للنسخة 11g والثاني للنسخة 9i ولكن بما ان 11g هو الاحدث لماذا نأخذ Iz0-007
وشكرا

                                                                                             

                                                                                                                  Maher Salman

• Oracle Fusion Human Capital Management 11g Human Resources Certified Implementation Specialist 

Taleo (TEE): Onboarding Administration Ed 3 LVC, Oracle University.

• Taleo (TBE): Recruit Essentials Ed 4.1 LVC, Oracle University.

• Oracle Fusion HCM Implementation, Oracle University.

• Oracle Certified Professional Developer (OCP) - Oracle Forms: Build Internet Applications.

• Oracle Certified Associate Developer (OCA).

• Oracle E-Business Suite R12 Human Capital Management Certified Implementation Specialist (HCM)

                                                                                                                                        
                                                                                                           http://learnoracle.net                                                                                                                

                                                                                                                             
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

أهم مواضيعي ( Oracle Developer )

- برنامج حفظ الكودات - My Codes

- كيفية عمل نظام متعدد اللغات

- انشاء شاشة دخول وتغيير كلمة السر والتحكم بالمستخدمين

- Import And Export On Toad

- التحكم في النظام من خلال الملف Formsweb.cfg

​- Advanced Dynamic List

- توليد ارقام وحروف عشوائية 

 

 

أهم مواضيعي ( Oracle HRMS)

 

Using Special Value set in oracle hrms 


#10 جلال شواقفه

جلال شواقفه

    عضو مميز

  • الأعضــاء
  • 2,559 مشاركة
  • البـلـد: Country Flag

تاريخ المشاركة 25 July 2009 - 08:21 AM

شكرا لك على هذا التفصيل
ارجو من يستفيد من مشاركاتي الدعاء لوالدي ولاموات المسلمين بالمغفره والرحمه......

جلال محمود شواقفه
مدير دائرة الحاسوب
بلدية المفرق الكبرى
المملكه الاردنيه الهاشميه.

#11 Ahmad.Hasan

Ahmad.Hasan

    مشرف قسم الـ Forms & Reports والمشاريع

  • فريق الإشراف
  • 4,871 مشاركة
  • الاسم الأول:Ahmad
  • اسم العائلة:Hasan
  • البـلـد: Country Flag
  • المنصب الحالي:Oracle HCM Consultant

تاريخ المشاركة 25 July 2009 - 06:38 PM

ما الفرق بين الامتحانين التاليين :

1Z0-051 وهو Oracle Database 11g: SQL Fundamentals I
introduction to Oracle 9i-SQL 1z0-007
اعرف ان الفرق ان الاول للنسخة 11g والثاني للنسخة 9i ولكن بما ان 11g هو الاحدث لماذا نأخذ Iz0-007
وشكرا



السلام عليكم

Exam 1Z0-051 Oracle Database 11g: SQL Fundamentals I has just been released in full production.

This new exam is part of the Oracle Certified Oracle Database 11g Administrator track, combining training, experience, and testing to endorse candidates with a strong foundation and expertise in the industry’s most advanced database management system.

Exam 1Z0-051 covers topics such as:

  • retrieving data using SQL select statements
  • reporting aggregated data using group functions
  • displaying data from multiple tables
  • using subqueries to solve queries
  • using set operator
  • manipulating data
  • using DDL statements to create and manage tables, and
  • creating schema objects.

The exam contains 65 questions, 2 hours (120 minutes) allowed for completion, and requires a score of 60% to pass. Cost is $95 USD, with immediate registration available through Prometric testing centers worldwide.


Exam Number: 1Z0-007
Associated Certifications: Oracle9i DBA OCA
Application Developer R.6i OCP
Application Developer R.9i OCA
Exam Price: $95.00 USD
Exam available online


Duration: 120 minutes
Number of Questions: 52
Passing Score: 71%


اتمنى ان يكون الفرق واضح...
بالتوفيق

.Oracle E-Business Suite R12 HCM Certified Implementation Specialist

 

.Oracle Fusion Human Capital Management 11g Human Resources Certified Implementation Specialist

 


#12 mmsalman87

mmsalman87

    عضو مميز

  • الأعضــاء
  • 1,689 مشاركة
  • الاسم الأول:Maher
  • اسم العائلة:Salman
  • البـلـد: Country Flag
  • المنصب الحالي:Senior Oracle HCM SaaS Pre Sale Consultant

تاريخ المشاركة 25 July 2009 - 08:39 PM

اخواني مشكورين على ردودكم
يعني انا بدي ابدأ في اخذ امتحانات اوراكل ديفلوبر بالنسبة لاول امتحان وهو sql هل اخذ
1Z0-007
ولا اخذ
1Z0-051
لانو الواحد بما انو بدو يبلش امتحانات حرام يوخذ امتحانات قديمة لازم يوخد اخر نسخة ولا انا غلطان

                                                                                             

                                                                                                                  Maher Salman

• Oracle Fusion Human Capital Management 11g Human Resources Certified Implementation Specialist 

Taleo (TEE): Onboarding Administration Ed 3 LVC, Oracle University.

• Taleo (TBE): Recruit Essentials Ed 4.1 LVC, Oracle University.

• Oracle Fusion HCM Implementation, Oracle University.

• Oracle Certified Professional Developer (OCP) - Oracle Forms: Build Internet Applications.

• Oracle Certified Associate Developer (OCA).

• Oracle E-Business Suite R12 Human Capital Management Certified Implementation Specialist (HCM)

                                                                                                                                        
                                                                                                           http://learnoracle.net                                                                                                                

                                                                                                                             
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

أهم مواضيعي ( Oracle Developer )

- برنامج حفظ الكودات - My Codes

- كيفية عمل نظام متعدد اللغات

- انشاء شاشة دخول وتغيير كلمة السر والتحكم بالمستخدمين

- Import And Export On Toad

- التحكم في النظام من خلال الملف Formsweb.cfg

​- Advanced Dynamic List

- توليد ارقام وحروف عشوائية 

 

 

أهم مواضيعي ( Oracle HRMS)

 

Using Special Value set in oracle hrms 


#13 Ahmad.Hasan

Ahmad.Hasan

    مشرف قسم الـ Forms & Reports والمشاريع

  • فريق الإشراف
  • 4,871 مشاركة
  • الاسم الأول:Ahmad
  • اسم العائلة:Hasan
  • البـلـد: Country Flag
  • المنصب الحالي:Oracle HCM Consultant

تاريخ المشاركة 25 July 2009 - 08:50 PM

السلام عليكم
اخي ماهر...
هو ما فرق كبير بينهم تقريبا نفس المفاهيم والاتنين بدخلن ضمن الــ administration track
ولكن انا افضل ان تأخد 1Z0-051 حيث انه هو الاحدث...
اتمنالك التوفيق
تحياتي...

.Oracle E-Business Suite R12 HCM Certified Implementation Specialist

 

.Oracle Fusion Human Capital Management 11g Human Resources Certified Implementation Specialist

 


#14 sara gamal

sara gamal

    عضو نشط

  • الأعضــاء
  • 411 مشاركة
  • البـلـد: Country Flag

تاريخ المشاركة 26 July 2009 - 03:41 AM

السلام عليكم
انا اللفهمته من موقع اوركل ان امتحان 1z0-051 هو الامتحان الخاص بال sql بالنسبه لل 11g
1z0-144 وده امتحان الpl الخاص ب 11g
وال forms هو نفس امتحان "اذا في خطأ ياريت حد يصححه"
وده رابط للتوضيح
http://education.ora...p...=42&lang=US
بس مش عارفه هل الدرس 10g يروح يمتحن 11g طيب ازاي اكيد فيه اختلاف في المنهج ولا ايه؟؟؟؟

#15 mmsalman87

mmsalman87

    عضو مميز

  • الأعضــاء
  • 1,689 مشاركة
  • الاسم الأول:Maher
  • اسم العائلة:Salman
  • البـلـد: Country Flag
  • المنصب الحالي:Senior Oracle HCM SaaS Pre Sale Consultant

تاريخ المشاركة 26 July 2009 - 08:03 AM

فعلا كلامك صحيح اذا كيف نتأكد من هذا الموضوع
يعني لا اعتقد الاختلاف الكبير بين الامتحانين ولكن لست ادري ماذا امتحن منهم ؟

                                                                                             

                                                                                                                  Maher Salman

• Oracle Fusion Human Capital Management 11g Human Resources Certified Implementation Specialist 

Taleo (TEE): Onboarding Administration Ed 3 LVC, Oracle University.

• Taleo (TBE): Recruit Essentials Ed 4.1 LVC, Oracle University.

• Oracle Fusion HCM Implementation, Oracle University.

• Oracle Certified Professional Developer (OCP) - Oracle Forms: Build Internet Applications.

• Oracle Certified Associate Developer (OCA).

• Oracle E-Business Suite R12 Human Capital Management Certified Implementation Specialist (HCM)

                                                                                                                                        
                                                                                                           http://learnoracle.net                                                                                                                

                                                                                                                             
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

أهم مواضيعي ( Oracle Developer )

- برنامج حفظ الكودات - My Codes

- كيفية عمل نظام متعدد اللغات

- انشاء شاشة دخول وتغيير كلمة السر والتحكم بالمستخدمين

- Import And Export On Toad

- التحكم في النظام من خلال الملف Formsweb.cfg

​- Advanced Dynamic List

- توليد ارقام وحروف عشوائية 

 

 

أهم مواضيعي ( Oracle HRMS)

 

Using Special Value set in oracle hrms