考点
Installing Oracle Database 10g Software
[ ] Identify system requirements
[ ] Use Optimal Flexible Architecture
[ ] Install software with Oracle Universal Installer
[ ] Identify and configure commonly used environment variables

Creating an Oracle Database
[ ] Explain the Oracle database architecture
[ ] Explain the instance architecture
[ ] Use the management framework
[ ] Use DBCA to Create a database
[ ] Use DBCA to Configure a database
[ ] Use DBCA to Drop a database
[ ] Use DBCA to Manage templates

Managing Schema Objects
[ ] Create and modify tables
[ ] Define constraints
[ ] View the attributes of a table
[ ] View the contents of a table
[ ] Create indexes and views
[ ] Name database objects
[ ] Select appropriate data types
[ ] Create and use sequences

Managing Data
[ ] Manipulate data through SQL using INSERT, UPDATE, and DELETE
[ ] Use Data Pump to export data
[ ] Use Data Pump to import data
[ ] Load data with SQL Loader
[ ] Create directory objects

PL/SQL
[ ] Identify PL/SQL objects
[ ] Describe triggers and triggering events

Undo Management
[ ] Monitor and administer undo
[ ] Configure undo retention
[ ] Guarantee undo retention

www.ixdba.net

[ ] Use the Undo Advisor
[ ] Describe the relationship between undo and transactions
[ ] Size the undo tablespace

Monitoring and Resolving Lock Conflicts
[ ] Detect and resolve lock conflicts
[ ] Manage deadlocks
[ ] Describe the relationship between transactions and locks
[ ] Explain lock modes within the Oracle Database 10g Controlling the Database
[ ] Start and stop iSQL*Plus
[ ] Start and stop Enterprise Manager Database Control
[ ] Start and stop the Oracle Listener
[ ] Start up and shut down Oracle Database 10g
[ ] Describe startup and shutdown options for the Oracle Database
[ ] Handle Parameter files
[ ] Locate and view the Database alert log

Oracle Database Security
[ ] Apply the principal of least privilege
[ ] Manage default user accounts
[ ] Implement standard password security features
[ ] Audit database activity
[ ] Register for security updates


Oracle Net Services
[ ] Use Database Control to Create additional listeners
[ ] Use Database Control to Create Oracle Net service aliases
[ ] Use Database Control to Configure connect time failover
[ ] Use Listener features
[ ] Use the Oracle Net Manager to configure client and middle-tier connections
[ ] Use TNSPING to test Oracle Net connectivity
[ ] Describe Oracle Net Services
[ ] Describe Oracle Net names resolution methods

Backup and Recovery Concepts
[ ] Describe the basics of database backup, restore and recovery
[ ] Describe the types of failure that may occur in an Oracle Database
[ ] Describe ways to tune instance recovery
[ ] Identify the importance of checkpoints, redo log files, and archived log files
[ ] Configure ARCHIVELOG mode
[ ] Configure a database for recoverability

Storage Structures
[ ] Define the purpose of tablespaces and data files