分类: OCM

  • Oracle 10g OCM 考試大綱

    Oracle 10g  OCM  Exam Topics

    一 Server Configuration

    ﹡ Create the database 

    ﹡ Determine and set sizing parameters for database structures

    ﹡ Create and manage temporary, permanent, and undo tablespaces 

    ﹡ Stripe data files across multiple physical devices and locations 

    ﹡ Configure the database environment to support optimal data access performance 

    ﹡ Create and manage database configuration files 

    ﹡ Create and manage bigfile tablespaces 

    ﹡ Create and manage multiple network configuration files 

    ﹡ Create and configure a listener 

    ﹡ Configure the database instance to support shared server connections 

    ﹡ Set up network tracing 

    ﹡ Manage Oracle network processes (the Listener Control utility) 

    ﹡ Configure the network environment to allow connections to multiple databases 

    ﹡ Use configurationless connections 

      (更多…)

  • Oracle大師級認證:Oracle9i OCM

      OCM是Oracle公司在OCP這個專案上又推出的一個更高一級認證,全稱是Oracle Certified Master,許多業內人士都把它稱作Oracle認證的大師,是現今資料庫領域中最高級別的認證。

    OCM的定位:

      OCM是資深專家級的Oracle的認證考試,它重在實踐,與CCIE認證很相似,是Oracle公司推出的最高一級別的認證,獲取OCM認證的工程師在技能上更具有說服力。通過後將成為企業內的資深專家,這種認證的人員也是Oracle的一些諮詢公司以後的最佳人選。

    對參加OCM考試的人員的要求:

      主要有兩個要求。一、首先必須是OCP;二、參考人員應參加過Oracle原廠的至少兩門的OCM相關課程的培訓。
    參加OCM認證考試需要必備的知識:

    1、精通Oracle9i的SQL

    2、RedHat Advanced Server
    LINUX的一些操作知識,如格式並執行基本的作業系統的命令;創建並遍曆目錄;使用cp,mv及rm來拷貝、移動及刪除文件;linux環境下的文本編輯器的使用;設置環境變數。

    3、定位和執行Oracle一些應用程式的能力,

      它包括:RMAN應用程式;Oracle Net Manager;Oracle Net Configuration Assistant;OEM;Listener Utility;OMS;Oracle Password Utility;Database Creation Assistant(DBCA)。

    4、要熟練使用Oracle Enterprise Manager(OEM)

    5、熟練使用Oracle Net Manager和Oracle NetConfiguration Assistant來進行網路配置。

    6、熟悉Oracle9i(v9.0.1.3)的高級知識

    7、熟悉使用瀏覽器(netscape)來查閱oracle的幫助文檔。

    8、熟練使用Konqueror 2.2 browser軟體

  • Oracle認證所有考試科目

    Oracle認證所有考試科目

    1Z0-001 9i Internet Application Developer Introduction to Oracle: SQL and PL/SQL
    1Z0-007 Introduction to Oracle9i: SQL
    1Z0-020 Oracle8l:new features for administrators
    1Z0-030 orcacle9i database:new features for administrators
    1Z0-031 orcacle9i database:fundamentals i
    1Z0-032 orcacle9l database:fundamentals ii
    1Z0-033 Oracle9i Database:Performance Tuning
    1Z0-035 orcacle9i dba new features for Oracle7.3 and Oracle9 ocps
    1Z0-036 Managing Oracle9i on linux
    1Z0-040 Oracle database 10g:new features for adminsitrators
    1Z0-042 Oracle database 10g:Administration I
    1Z0-043 Oracle database 10g:Administration ii
    1Z0-045 Oracle database 10g:new features for Oracle8i ocps
    1Z0-046 Oracle Database 10g: Managing Oracle on Linux for DBAs
    1Z0-047 Oracle Database SQL Expert
    1Z0-048 Oracle Database 10g R2: Administering RAC
    1Z0-050 Oracle Database 11g: New Features for Administrators
    1Z0-051 Oracle Database: SQL Fundamentals I
    1Z0-052 Oracle Database 11g: Administrator I : 1z1-052 Exam
    1Z0-055 Oracle Database 11g: New Features for 9i OCPs
    1Z0-101 Develop pl/sql program units
    1Z0-108 Oracle WebLogic System Administration
    1Z0-131 9i Internet Application Developer Oracle9i, Build Internet Applications I
    1Z0-132 9i Internet Application Developer Oracle9i, Build Internet Applications II
    1Z0-140 Oracle9i forms Developer:new features
    1Z0-141 Oracle9i forma Developer:build internet applications
    1Z0-147 Oracle9i program with pl/sql
    1Z0-200 Oracle 11i.E-Business Essentials
    1Z0-202 Siebel 8 Consultant Exam
    1Z0-204 Oracle EBS R12: E-Business Essentials
    1Z0-207 Oracle comm.billing & revenue mgmt:pricing
    1Z0-208 Oracle comm.billing & revenue mgmt:server Developer
    1Z0-209 Oracle comm.billing & revenue mgmt:System Administrator
    1Z0-211 Oracle 11i general ledgerfundamentals
    1Z0-212 Oracle payables 11i funfamentats
    1Z0-213 Oracle receivables 11i fundamentals
    1Z0-221 Oracle 11i inventory management fundamentals
    1Z0-222 Oracle Purchasing 11i Fundamentals
    1Z0-223 Oracle order management 11i fundamentals
    1Z0-226 Oracle EBS R12: Inventory and Order Management Fundamentals
    1Z0-231 Oracle implement workflow 11i/2.6
    1Z0-232 Oracle 11i system Administration fundamentals
    1Z0-233 Oracle 11i install. patch and maintain applications
    1Z0-235 Oracle 11i applications DBA:Fundamentals I
    1Z0-236 11i Applications DBA Fundamentals II
    1Z0-241 PeopleSoft Application Develper I: PeopleTools & PeopleCode
    1Z0-242 PeopleSoft Application Developer II: App Engine & Integration
    1Z0-255 Hyperion Essbase 7.1.2 Cnsultant
    1Z0-257 Hyperion Financial Management 4.1 Consultant
    1Z0-259 Hyperion Planning 4.1 Consultant
    1Z0-262 Hyperion Planning 4.1 Administrator
    1Z0-264 Hyperion Essbase Analytics 9.3 Developer
    1Z0-301 Oracle9ias:basic Administration
    1Z0-311 Oracle application server 10g:Administration
    1Z0-312 Oracle Application Server 10g: Administrator II
    1Z0-402 Oracle Enterprise Linux: Fundamentals
    1Z0-615 Siebel 7.7 Consultant Core Exam
    1Z0-620 Siebel7.7 Analytics App.Developer Professional Core Exam
    1Z0-630 Siebel7.7 Analytics Server Architect Professional Core Exam
    1Z0-640 Siebel7.7 Analytics DataWarehouse Dev.Prof.Core Exam
    1Z1-225 Oracle EBS R12: Inventory and Purchasing Fundamentals
    1Z1-226 Oracle EBS R12: Inventory and Order Management Fundamentals
    1Z1-238 R12 Oracle: install,Patch and Maintain Oracle Applications
    1Z0-273 Hyperion Financial Management 4.1 Administrator I&II
    1Z0-225 Oracle EBS R12: Inventory and Purchasing Fundamentals
    1Z0-238 R12 Oracle: install,Patch and Maintain Oracle Applications
    1Z0-054 Oracle Database 11g: Performance Tuning
    1Z1-054 Oracle Database 11g: Performance Tuning
    1Z1-051 Oracle Database: SQL Fundamentals I
    1Z1-051 Oracle Database: SQL Fundamentals I

    如需購買Oracle考古題請到TestPassPort官方網站購買(www.testpassport.net),TestPassPort優惠活動購買上述考題可以享受特殊優惠,購買時輸入”testpassport”即可享受九五折優惠,購買壹科優惠5% 兩科優惠10% 三科優惠15% 四科優惠20% 五科優惠… 可以累積計算,無時間限制.免費提供Demo下載,可以預覽使用考題!

  • Oracle OCM認證資深專家考試方法和要求

    對參加OCM考試的人員的要求:

     
    主要有兩個要求。一、首先必須是OCP;二、參考人員應參加過Oracle原廠的至少兩門的OCM相關課程的培訓。
     
    OCM-參加OCM認證考試需要必備的知識:
     
    1、精通Oracle9i的SQL
     
    2、RedHat Advanced Server
     
    LINUX的一些操作知識,如格式並執行基本的操作系統的命令;創建並遍歷目錄;使用cp,mv及rm來拷貝、移動及刪除文件;linux環境下的文本編輯器的使用;設置環境變量。
     
    3、定位和執行Oracle一些應用程序的能力,
     
    它包括:RMAN應用程序;Oracle Net Manager;Oracle Net Configuration Assistant;OEM;Listener Utility;OMS;Oracle Password Utility;Database Creation Assistant(DBCA)。
     
    4、要熟練使用Oracle Enterprise Manager(OEM)
     
    5、熟練使用Oracle Net Manager和Oracle NetConfiguration Assistant來進行網絡配置。
     
    6、熟悉Oracle9i(v9.0.1.3)的高級知識
     
    7、熟悉使用瀏覽器(netscape)來查閱oracle的幫助文檔。
     
    8、熟練使用Konqueror 2.2 browser軟件
     
    實踐課考試環境:
     
    實踐課的考試在oracle統一專用的教室內進行。由一個oracle的教授來負責監考、佈置場景、收集考試的結果。考生將被隨意指定一個坐位來完成當天的實踐考試。考生不允許使用自帶私人的文檔和筆記,不許與其它的考生商量。移動電話,自帶紙張和PDA都不允許在考試教室內使用。每個考生都將提供一個安裝在redhat Advanced Server 2.1 LINUX環境上的Oracle的server軟件,一個完備的Oracle聯機文檔。

  • Oracle官方教材下載

    Oracle 9i教材:
    20000GC10:Data Modeling and Relational Database Design
    40054GC10 – Introduction to Oracle9i:PL/SQL
    40054GC11 – Oracle9i:Program with PL/SQL
    40055GC11 – Oracle9i:PL/SQL Fundamentals
    40056GC11 – Oracle9i:Develop PL/SQL Program Units
    40058GC11 – Oracle 9i :Advanced SQL
    40060GC10 – Oracle9i:SQL for End Users
    40061GC10 – Oracle9i:Advanced PL/SQL [PPT]
    D11299GC21 – Oracle9i Performance Tuning Version 2.1(1Z0-033)
    D11318GC20 – Oracle9i:New Features for Administrators第二版(1Z0-030)
    Introduction to Oracle9i:SQL Version 2.0(1Z0-007)
    Oracle9i Database Administration Fundamentals II Version 2.0[含中文版1.1](1Z0-032)
    Oracle9i Database Administration Fundamentals I Version 2.0[含中文版1.1](1Z0-031)

    Oracle 9i高級培訓:
    D16001GC10 – Oracle9i Database:Using OLAP
    D13289GC10 – Oracle9i:Data Warehouse Administration
    D12204CN10 – Oracle9iAS:基本管理[中文版](1Z0-301)
    D12210GC10 – Oracle9iAS:Wireless Enable Portals and Applications
    D11803GC10 – Data Warehouse Database Design
    12837GC10 – Oracle9i:Real Application Clusters
    D12215GC20 – Oracle Enterprise Manager 9i
    D12619GC10 – Oracle9i Database:Data Guard Administration
    D12611GC10 – Oracle 9i:Implement Advanced Queuing
    D12848GC10 – Oracle9i: Spatial
    D13287GC10 – Oracle9i Database:Implement Partitioning
    D16442GC10 – Oracle9i Database:Advanced Instance Tuning
    D16335GC10 – Oracle9i Database:Real Application Clusters on Linux

    Oracle 10g教材:
    D17079GC20 – Oracle Database 10g:New Features for Administrators Version 2(1Z0-040)
    D17389GC10 – Oracle Database 10g:New Features for Oracle8i DBAs(1Z0-045)
    Oracle Database 10g:Administration Workshop I(1Z0-042)
    Oracle Database 10g:Administration Workshop II(1Z0-043)(PDF格式)

    Oracle 10G高級培訓:
    D17276GC10 – Oracle Database 10g:Real Application Clusters
    D17244GC11 – Oracle Enterprise Manager 10g Grid Control

    Java相關教材:
    40003GC50 – Java Programming
    D11678GC31 – Oracle9i:Access the Database with Java and JDBC
    D12867GC10 – Oracle9i JDeveloper:Develop Applications with BC4J
    D12871GC10 – Oracle9i:Create Servlets and JavaServer Pages

    其它
    其它一些文檔,無法歸類
    EClass

    APP 11i系列:
    14217GC10 – Installing Oracle Applications,Release 11i
    14226GC10 – 11i Extend:Customization Standards
    14431GC20 – R11i Oracle Applications AD Utilities
    14433GC10 – Oracle Applications Architecture,Release 11i & 14433GC21 – R11i Oracle Applications Architecture
    14437GC20 – R11i Patching and Maintaining Oracle Applications
    14464GC11 – R11i Extend Oracle Applications:Forms
    14465GC11 – R11i System Administration
    14466GC11 – R11i Defining Flexfields
    14468GC11 – R11i Navigating Oracle Applications
    14889GC30 – 11i Implement and Administer Marketing Online
    14491GC10 – R11i Oracle Account Generator
    14492GC11 – R11i Oracle Alert
    15001GC10 – 11i e-Commerce Gateway
    D11101GC10 – 11i 2.6 Workflow Business Event System
    D11102GC10 – 11i Extend:CUSTOM Library
    14263GC20(PPT)
    14433GC30 – 11i Oracle Applications Architecture(PPT)
    14440GC30及14440GC40 – 11i Upgrade Oracle Applications(PPT)
    14452GC21 – E-BI(PPT)
    14468CN20 -使用Oracle Applications 11i(PPT)
    14468GC11及14468GC20 – 11i Navigating Oracle Applications(PPT)
    14566GC10(PPT)
    14590GC31 – 11i HRMS System Administration(PPT)
    14591GC10(PPT)
    14676GC40 – Implement Oracle Configurator(PPT)
    14677GC40 – Oracle iStore(PPT)
    14801GC40 – 11i Implement and Administer CRM Application Foundation(PPT)
    14805GC20 – Work Structures HRMS Release 11i(PPT)
    14815GC30(PPT)
    14828GC30 – 11i Implement and Administer iSupport(PPT)
    14834GC10 – Oracle Project:Project Billing(含中文版)(PPT)
    14846GC20 – 11i Oracle Receivables(PPT)
    14848GC10 – Oracle Cash Management R11i(PPT)
    14854GC40 – 11i Implement Scripting(PPT)
    14858CN10 – R11i實施和使用Oracle Engineering和Bills of Material(含英文版)(PPT)
    14859GC10 – Work In Process(PPT)

    點擊下載

  • Oracle 9iDBA 1Z0-007題庫下載

    Oracle目前提供了4種適於不同人員的認證:Oracle DBA認證、Oracle網絡應用開發人員認證、Oracle Jxdya開發人員認證和Internet數據庫操作人員認證(iDBO)。其中,Oracle DBA認證是最重要也是最為普及的壹種認證類型。在最新公布的Oracle 9i DBA認證考試當中,也由上至下依次地劃分為OCMOCPOCA三層,如下圖所示,以下將把此項認證作為討論的重點。

    killtest提供1z0-007題庫下載:Oracle 9iDBA 1Z0-007題庫下載

    1Z0-007的SQL Exam當中有60道題,現行的計分方式是只看答對的百分率,如果妳答對了45道題,答對的百分率是75%,也就通過了這門考試(見下表)。以前則不然,由於妳得到的是壹個位置分數,那麽每壹期考試的通過與否就不單單是妳個人的能力問題了,它還跟其他與妳同期參與考試的人有關系,有可能妳甚至達到80%的答對率都不能通過——因為有很多的其他人達到了81%的答對率!Oracle公司也壹直在搖擺不定,說不準哪壹天會回到老路,這是那些目前對Oracle考試采取觀望態度的人應該註意的壹點。從表1中可以看出,Fundamentals(1Z0-031)分成兩個部分,Mastery Section要稍微難壹些,考生同時達到Basic Section和Mastery Section兩部分的要求才算是真正地通過了該門考試。

    1Z0-007屬於Oracle 9i DBA的壹項考試編號。全稱:Introduction to Oracle9i: SQL。考試時間:120分鐘,1Z0-007包含52道考試題目,只需要壹個及格分數的71%,考生便可通過1Z0-007的認證考試。1Z0-007題庫包含129真題,1Z0-007考題題庫是由考試內容的更新而隨之更新,更新時間:2008年9月1日。 考試內容涵蓋以下幾個方面:寫作基本的SQL SELECT語句;子查詢;創建意見;制約和排序數據;生產可讀輸出與iSQL *加; 創建其他數據庫對象;單排職能;數據顯示從多個表;操作數據;創建和管理表;包括約束。