اقتباس:
--------------------------------------------------------------------------------
لا يوجد أي دوره تمهيديه
أول دوره خاصه بالأوراكل هي
Sql Oracle
وثاني دوره
Oracle Devolipore 2003
وثالث دوره
Oracle Diesaynire
والدوره الرابعه
Oracle Administrator
__________
|
اشكر اخوي علي التوضيح بس حبب ازيد عليه انوا الاوراكل مقسم الي قسمين واحد تقريبن
1 (1.1)Oracle9i Database Administrator Certified Associate
وهي ocp ومقسم الي 4
1 sql
2 pl/sql
3 forms
4 report
2 oca الي هي Oracle Administrator
1- 1Z0-007 (Introduction to Oracle9i: SQL
ويغطي هذا الإختبار المواضيع التالية :
• SELECT statements
• DML statements (INSERT, UPDATE, MERGE, DELETE)
• transaction control statements (COMMIT, ROLLBACK)
• DDL statements (for example, CREATE TABLE, ALTER TABLE, DROP TABLE)
• DCL statements (GRANT, REVOKE)
2- 1Z0-031 (Oracle9i Database: Fundamentals I)
ويغطي هذا الإختبار المواضيع التالية :
• Oracle database structures, both physical and logical
• Oracle software architecture, including memory structures and processes
• the Oracle Universal Installer
• administration tools and utilities, including SQL*Plus/iSQL*Plus, Oracle Enterprise Manager, SQL*Loader, Export/Import, and the LogMiner
• server startup and shutdown
• system-level event triggers
• initialization parameter files
• the database alert file
• trace files
• database creation
• the database control file and control file configuration
• online transaction (redo) log structure and configuration
• offline (archived) log configuration
• logical and physical database space management, including tablespace and data file management
• object space management, including segments, extents, and data blocks
• undo tablespace and rollback segment configuration
• temporary tablespace configuration
• tables and their storage settings
• integrity constraints and database triggers
• indexes (B*-tree, reverse-key, bitmap, and function-based) and their storage settings
• clusters (indexed and hash)
• index-organized tables
• partitioned tables and indexes (range, hash, and composite partitioning schemes)
• database security, including users, privileges, roles, and PUBLIC
• resource limit profiles and user password management
• database auditing
• Globalization (National Language Support, NLS) configuration
• Basic SGA memory structure configuration (buffer cache and pools, shared pool, large pool, etc.)
• parallel execution
• Oracle Managed Files (OMF)