OCP Database

Oracle 已公佈考生必須通過以下 2 個 Oracle Database 19c 相關科目的考試，才可獲發 Oracle Database Administration 2019 Certified Professional 國際認可證書：

本中心為 Oracle 指定的考試試場。報考時請致電本中心，登記欲報考之科目、考試日期及時間 (最快可即日報考)。臨考試前考生須出示身份證及繳付考試費。

第 1 科：考試編號 1Z0-082，考試費為 HK$1,898。
第 2 科：考試編號 1Z0-083，考試費為 HK$1,898。

考試題目由澳洲考試中心傳送到你要應考的電腦，考試時以電腦作答。所有考試題目均為英文，而大多數的考試題目為選擇題。作答完成後會立即出現你的分數，結果即考即知！

考試合格後會收到來自 Oracle 的作實電郵，並進入該電郵內的連結，登入 https://certview.oracle.com 下載您的證書。

考試不合格便可重新報考，不限次數。欲知道作答時間、題目總數、合格分數等詳細考試資料，可瀏覽本中心網頁 "各科考試分數資料"。

1Z0-082 Oracle Database Administration I (36 hours)

1. Oracle Server Technologies and Relational Paradigm
1.1 Prerequisite knowledge to Oracle Servers
1.2 The Oracle Server Architecture
1.3 The Oracle Application Server
1.4 The Oracle Enterprise Manager

2. Deploying Oracle Database Server
2.1 Requirements for Oracle Database 19c
2.2 Computer (Virtual Machines) Requirement
2.3 Database Installation using Oracle Universal Installer on Windows Server
2.4 Database Installation using Oracle Universal Installer on Oracle Enterprise Linux Server

3. Oracle Database Management Consoles
3.1 Tools available to manage an Oracle Database Server
3.2 SQL*Plus
3.3 SQL Developer
3.4 Enterprise Manager: Database Control

4. Relational Data
4.1 Normalization

5. Demonstration Schema
5.1 Addressing the Demonstration Schema
5.2 Definition of a Database Schema
5.3 The HR and OE Schema
5.4 Enabling the HR and OE user

6. Data Retrieval Using the SQL SELECT Statement
6.1 The DESCRIBE table command
6.2 Describing the HR schema
6.3 Capabilities of SELECT Statement
6.4 Executing the SELECT Statement

7. Restricting and Sorting Data
7.1 Introduction
7.2 Limit the Rows Retrieved by a Query
7.3 Sort the Rows Retrieved by a Query
7.4 Ampersand Situation

8. Single Row Functions
8.1 Introduction to Single Row Functions
8.2 Describing Various Types of Functions Available in SQL
8.3 Types of Functions
8.4 Working with Dates

9. Using Conversion Functions and Conditional Expressions
9.1 Introduction
9.2 Describing Various Types of Conversion Functions Available in SQL
9.3 Using TO_CHAR, TO_NUMBER and TO_DATE
9.4 Apply Conditional Expressions in a SELECT Statement

10. Reporting Aggregated Data Using Group Functions
10.1 Introduction
10.2 Describe the Group Functions
10.3 Identify the Available Group Functions
10.4 Restrictions of using Nested Group Functions
10.5 Group Data Using the GROUP BY Clause
10.6 Include or Exclude Grouped Rows Using the HAVING Clause

11. Displaying Data From Multiple Tables
11.1 Introduction
11.2 Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
11.3 Types of Joins
11.4 Natural Joins
11.5 Oracle Join Syntax
11.6 Joining Tables Using SQL:1999 Syntax
11.7 Qualifying Ambiguous Column Names (Optional Knowledge)
11.8 N-Way Joins and Additional Join Conditions
11.9 Nonequijoins (Optional Knowledge)
11.10 Join a Table to Itself Using a Self-Join (Optional Knowledge)
11.11 View Data That Does Not Meet a Join Condition by Using Outer Joins
11.12 Left Outer Join
11.13 Right Outer Join
11.14 Full Outer Join
11.15 Cross Join

12. Using Sub Queries to Solve Problems
12.1 Introduction
12.2 Define Subqueries
12.3 Describe the Types of Problem that Subqueries Can Solve
12.4 List the Types of Subqueries
12.5 Write Single-Row and Multiple-Row Subqueries

13. Using the Set Operator
13.1 Introduction
13.2 Describe the Set Operators
13.3 Set and Venn Diagram (Optional Knowledge)
13.4 Trying the Set Operators
13.5 Use a Set Operator to Combine Multiple Queries into a Single Query
13.6 General Principals of using Set Operators (Optional Knowledge)
13.7 More Complex Examples

14. Creating Schema Objects
14.1 Introduction
14.2 Create Simple and Complex Views
14.3 Reasons of using views
14.4 Simple and Complex Views
14.5 CREATE VIEW
14.6 Private and Public Synonyms
14.7 Sequences

15. Exploring the Oracle Database Architecture
15.1 Introduction
15.2 Description of a Single-Instance Architecture
15.3 Description of a Distributed System Architectures (Optional Knowledge)
15.4 Description of Memory Structures
15.5 Investigating the Memory Structures of the Instance
15.6 Description of Oracle Background Process Structures
15.7 Investigating the Processes Running in your instance
15.8 Summarize the Storage Structures
15.9 Logical Database Structures
15.10 Investigating the Storage Structures in your database

16. Creating an Oracle Database
16.1 Various tasks about Creating an Oracle Database
16.2 Using the Database Configuration Assistant (DBCA) to Create a Database
16.3 Scripts and Other Files Created by the DBCA

17. Managing the Oracle Instance
17.1 Introduction
17.2 Configuring EM Express for new instance
17.3 Managing the Oracle Listener
17.4 Database Startup and Shutdown
17.5 Set Database Initialization Parameters
17.6 Use the Alert Log and Trace Files
17.7 Using Data Dictionary and Dynamic Performance Views

18. Configuring the Oracle Network Environment
18.1 Introduction
18.2 Oracle Net and Communication Protocols
18.3 Creating a Listener
18.4 Techniques for Name Resolution
18.5 Database Registration
18.6 Database Link

19. Managing Database Storage Structures
19.1 Introduction
19.2 Identifying Oracle Storage Structures
19.3 Managing Tablespaces
19.4 The Oracle Data Block format
19.5 Managing Datafiles

20. Administering User Security
20.1 Database User Account
20.2 Choosing Authentication Methods
20.3 Choosing a Default Tablespace
20.4 Choosing a Temporary Tablespace
20.5 Choosing a Profile for a User
20.6 Creating a database user
20.7 About Database Schema
20.8 Granting and Revoking Privileges
20.9 Roles
20.10 Controlling Access to Applications by Secured Application Role
20.11 Quotas
20.12 Data Dictionary Views (Optional Knowledge)

21. Implementing Oracle Database Security
21.1 Introduction
21.2 Database Security and Principle of Least Privilege
21.3 PUBLIC privileges
21.4 Security-Critical Instance Parameters
21.5 Working with Traditional Database Auditing

22. Unified Auditing
22.1 Introduction to Oracle Database Unified Auditing
22.2 Implementing Mixed Auditing Mode
22.3 Implementing Unified Auditing
22.4 Creating Unified Audit Policy for Datapump example
22.5 Auditing RMAN
22.6 Cleaning up Audit Data

23. Real-Time Database Operation Monitoring
23.1 Monitoring in previous generations vs 19c
23.2 Definition of Database Operation
23.3 Control_Management_Pack_Access
23.4 Using Database Operation Monitoring
23.5 Emergency Monitoring and Real-Time ADDM
23.6 End-To-End Application Tracing

24. Managing Undo Data
24.1 Purpose of Undo Data
24.2 Compatibility of Undo Data
24.3 Understanding How Transactions Generate Undo
24.4 Work with Transactions and Flashback query
24.5 Managing Undo
24.6 Computing the Minimum Undo Tablespace Size Using the Undo Advisor

1Z0-083 Oracle Database Administration II (30 hours)

1. Basic Concept of Backup and Recovery in Oracle Database 19c
1.1 Introduction
1.2 Understanding and Configuring Recovery Components
1.3 Understanding Checkpoints
1.4 Redo Log Files
1.5 The Fast Recovery Area
1.6 Database Backup and Recovery Plan
1.7 Recovery Manager

2. Performing Database Backup and Disaster Recovery
2.1 Configuring RMAN for backup
2.2 Performing Disaster Recovery using Data Recover Advisor
2.3 Scheduling Oracle Suggested Backup plan
2.4 Performing Point-in-time recovery of database

3. Core Concepts of the Oracle Database 19c Recovery Manager (RMAN)
3.1 Oracle DBA Tools for Backup and Recovery
3.2 Connecting to Oracle Recovery Manager (RMAN)
3.3 Quick Start: A Problem-Solution Approach
3.4 Configuring for Recoverability

4. RMAN commands
4.1 Configuring and managing persistent settings
4.2 Using the Fast Recovery Area (FRA)
4.3 Control File
4.4 Redo Log File
4.5 Archiving Logs
4.6 Using the RMAN Recovery Catalog

5. Creating and Configuring the Recovery Catalog
5.1 Managing Target Database Records in the Recovery Catalog
5.2 Using RMAN Stored Scripts
5.3 Maintaining and Protecting the Recovery Catalog
5.4 Virtual Private Catalogs
5.5 Backup Strategies and Terminology

6. Backup Solutions Overview and Terminology
6.1 Balancing Backup and Restore Requirements
6.2 Backing Up Read-Only Tablespaces
6.3 Best Practices for Data Warehouse Backups
6.4 Additional Backup Terminology
6.5 Performing Backups

7. RMAN Backup Types
7.1 Incrementally Updated Backups
7.2 Fast Incremental Backup
7.3 Block Change Tracking
7.4 Oracle-Suggested Backup
7.5 Reporting on Backups
7.6 Managing Backups
7.7 Improving Your Backups

8. Compressing Backups
8.1 Using a Media Manager
8.2 Creating RMAN Multisection Backups, Proxy Copies, Duplexed Backup Sets and Backups of Backup Sets
8.3 Creating and Managing Archival Backups
8.4 Backing Up Recovery Files
8.5 Backing Up the Control File to a Trace File
8.6 Cataloging Additional Backup Files
8.7 Backing Up ASM Disk Group Metadata
8.8 Using RMAN-Encrypted Backups

9. Creating RMAN-Encrypted Backups
9.1 Using Transparent-Mode Encryption
9.2 Using Password-Mode Encryption
9.3 Using Dual-Mode Encryption
9.4 Diagnosing Database Failures

10. Reducing Problem Diagnosis Time
10.1 Automatic Diagnostic Repository
10.2 Interpreting RMAN Message Output and Error Stacks
10.3 Data Recovery Advisor
10.4 Diagnosing Data File Loss (file system and ASM)
10.5 Handling Block Corruption
10.6 Restore and Recovery Concepts

11. Restoring and Recovering
11.1 Instance Failure and Instance/Crash Recovery
11.2 Media Failure
11.3 Complete Recovery (Overview)
11.4 Point-in-Time Recovery (Overview)
11.5 Recovery Through RESETLOGS
11.6 Performing Recovery

12. RMAN Recovery in NOARCHIVELOG Mode
12.1 Performing Complete Recovery (of critical and noncritical data files)
12.2 Restoring ASM Disk Groups
12.3 Recovery with Image Files
12.4 Performing Point-in-Time (PITR) or Incomplete Recovery
12.5 Table Recovery from Backups
12.6 Performing Recovery in NOARCHIVELOG mode

13. Recovery of Server Parameter File, Control File
13.1 Redo Log File Loss and Recovery
13.2 Password Authentication File Re-creation
13.3 Index, Read-Only Tablespace, and Tempfile Recovery
13.4 Restoring the Database to a New Host
13.5 Disaster Recovery
13.6 Restoring RMAN Encrypted Backups
13.7 RMAN and Oracle Secure Backup

14. Oracle Secure Backup Overview
14.1 Oracle Database Disk and Tape Backup Solution
14.2 Backing Up the Fast Recovery Area to Tape
14.3 Defining Retention for RMAN Backups
14.4 RMAN and Oracle Secure Backup Basic Process Flow
14.5 Integration with Cloud Control
14.6 RMAN Database Backup to Tape
14.7 Performing Tape Backups and Restores

15. Scheduling Backups with EM
15.1 Oracle-Suggested Backup
15.2 RMAN and OSB Process Flow
15.3 RMAN and Oracle Secure Backup Jobs
15.4 Managing Database Tape Backups
15.5 Performing Database Recovery
15.6 RMAN Automatic Failover to Previous Backup
15.7 Using Flashback Technologies

16. Flashback Technology: Overview and Setup
16.1 Using Flashback Technology to Query Data
16.2 Flashback Table
16.3 Flashback Transaction (Query and Backout)
16.4 Flashback Drop and the Recycle Bin
16.5 Flashback Data Archive
16.6 Using Flashback Database

17. Flashback Database Architecture
17.1 Configuring Flashback Database
17.2 Performing Flashback Database
17.3 Best Practices for Flashback Database
17.4 Managing Backup Space or Transporting Data

18. Transporting Tablespaces
18.1 Transporting Databases
18.2 Duplicating a Database

19. Using a Duplicate Database
19.1 Choosing Database Duplication Techniques
19.2 Creating a Backup-up Based Duplicate Database
19.3 Understanding the RMAN Duplication Operation
19.4 Using Cloud Control to Clone a Database
19.5 RMAN Performance and Tuning

20. Tuning Principles
20.1 RMAN Multiplexing
20.2 Diagnosing Performance Bottlenecks
20.3 Restore and Recovery Performance Best Practices
20.4 Backup and Recovery Workshop

21. Multitenant Database Architecture
21.1 Introduction to Multitenant Database Architecture
21.2 More about Multitenant Container Database
21.3 The Root Container, Seed Container and Pluggable Container
21.4 Instance and Storage Organization of Containers
21.5 Types of Containers during CDB and PDB initialization

22. Configuring and Managing Multitenant Databases
22.1 Creating a Container Database (CDB)
22.2 Creating and Configuration a PDB
22.3 Status and Open Mode of a Pluggable Database
22.4 Unplugging and Plugging a Pluggable Databases
22.5 Cloning a Pluggable Database from another Pluggable Database
22.6 Plugging a Normal Non-CDB into a CDB

23. RMAN Backup and Recovery for Multitenant Architecture
23.1 Backup and Recover PDBs and CDB
23.2 Restoring a Tablespace in a Pluggable Database
23.3 Recovering Temporary Tablespace on CDB or PDBs
23.4 Recovering SYSAUX tablespace of the Root Container
23.5 Instance Recovery of lost Control Files
23.6 More about Point In Time Recovery (PITR) of PDB tablespaces

24. Managing Users, Roles and Privileges for Multitenant Architecture
24.1 Local Users and Common Users
24.2 Local Roles and Common Roles
24.3 Creating Local User in a PDB
24.4 Creating Common Users
24.5 Managing Privileges in a Multitenant Architecture
24.6 Managing Roles in a Multitenant Architecture

The course content above may change at any time without notice in order to better reflect the content of the examination.

以下是最近成功取得 OCP 認證的本中心部份學員名單：

• Cao Siu Kwong
• Chan Kit Man
• Chan Lok Man
• Chan Sin Keung
• Cheung Fu Wing
• Cheung Wai Leung
• Cheung Wing Chiu
• Choi Chin Ching
• Choy Chi Fai
• Chu Wing Tat
• Chung Tak Wa
• Feng Haobin
  
• Fong Wai Wah
• Ho Kwan Ho
• Ho Pak Hei
• Hung Ka Kam
• Ko Hung Chi
• Kong Tak Fung
• Ku Man Wah
• Lai Ka Chun
• Lai Yiu Ming
• Lam Chung Wai
• Lau Hon Cheong
• Lau Kin Pong
• Lau King Sum
• Lau Wai Ho
• Lau Wing Tai
• Law Wai Kit
• Law Wai Kwong
• Lee Chi Wai
• Leung Hi Yung
• Leung Ho Sum
• Leung Wing Tat
• Lo Tai Wai
• Ng Shek Kei
• Ng Wai Ying
• Ng Yick Bun
• Ngan Chun Yu
• Pang Wai Hon
• Poon Chun To
• See Kwok Leung
• Shek Kin Yu
• Tam Kin Sang
• Tam Siu Yun
• Tang Chi Ming
• Tang Ho Wing
• Tong Kwan Ho
• Tse Chung Kei
• Wai Ho Cheong
• Wong Ho Yin
• Wong Hung Bun
• Wong Leung Shing
• Wong Tak Kei
• Wong Ting Kit
• Wong Wai Tong
• Wu Ping Kee
• Yeung Kam Lung
• Yuen Wai Kit

......由於人數眾多，因此未能盡錄。