1.0 Installing Software
1.1 Identify system requirements
1.2 Use Optimal Flexible Architecture
1.3 Install software with Oracle Universal Installer
1.4 Identify and configure commonly used environment variables
2.0 Create a Database
2.1 Oracle Database Architecture
2.2 Oracle Instance Architecture
2.3 Management framework
2.4 Create database with DBCA
2.5 Configure database with DBCA
2.6 Drop database with DBCA
2.7 Manage Templates with DBCA
3.0 Database Interfaces
3.1 Accessing10g Database
3.2 Describing logical structures
3.3 Query and Manipulate data and structures
3.4 Common Database Interfaces
3.5 Describe a Transaction
4.0 Managing Objects
4.1 Create and modify tables
4.2 Define constraints
4.3 View attributes of a table
4.4 View contents of a table
4.5 Create indexes and views
4.6 Name database objects
4.7 Selecting appropriate database objects
4.8 Create and use sequences
4.9 Define the purpose of tablespaces and data files
4.10 Create tablespace
4.11 Manage tablespaces
4.12 Obtain tablespace information
4.13 Drop tablespaces
4.14 Describe default Tablespaces
5.0 Managing and Accessing Data
5.1 Manipulating data through SQL
5.2 Using data pump to export
5.3 Using data pump to import
5.4 SQL Loader
5.5 Create directory objects
5.6 Identify PL/SQL objects
5.7 Describe triggers and triggering events
5.8 Configuration options that effect PL/SQL performance
6.0 Undo Management
6.1 Monitor and administer undo
6.2 Configure undo retention
6.3 Guarantee undo retention
6.4 Undo advisor
6.5 Relationship between undo and transactions
6.6 Sizing the undo tablespace
7.0 Database Security
7.1 Principal of least privilege
7.2 Default user accounts
7.3 Implement standard passwordsecurity features
7.4 Audit database activity
7.5 Register for security updates |
8.0 Oracle net services
8.1 TNSPING to test connectivity
8.2 Describe Oracle Net Services
8.3 Describe Oracle Net Names resolution methods
8.4 Use database control to create additional listeners
8.5 Use database control to create Oracle Net Service aliases
8.6 Use database control to configure connect time failover
8.7 Use listener features
8.8 Create and configure client and middle tier connections with Oracle Net Manager
9.0 Backup and Recovery
9.1 Describe basics of backup, restore and recovery
9.2 Describe types of failure that can occur in an Oracle Database
9.3 Tuning instance recovery
9.4 The importance of checkpoints, redo logs and archive log files
9.5 Configure archivelog mode
9.6 Configure the database for recoverability
9.7 Backing up
9.8 Consistent database backups
9.9 Hot Backups
9.10 Incremental backups
9.11 Automating backups
9.12 Monitoring flash recovery
9.13 Image copies and backup sets
9.14 Different types of backups
9.15 Backing up the controlfile
9.16 Manage recoveries
9.17 Recover from loss of a control file
9.18 Recover from loss of a redo log
9.19 Recover from loss of a system critical data file
9.20 Recover from loss of a non-system critical data file
10.0 Administering users
10.1 Create and manage user accounts
10.2 Create and manage roles
10.3 Grant and revoke privileges
10.4 Controlling resources
11.0 Oracle Shared Servers
11.1 When to use
11.2 Configure shared servers
11.3 Monitor shared servers
11.4 Shared server architecture
12.0 Performance monitoring
12.1 Invalid and unusable objects
12.2 Optimizer statistics
12.3 Performance metrics
12.4 React to performance issues
12.5 Setting warning and alert thresholds
12.6 Collect baseline metrics
12.7 Automatic Database Diagnostic Monitor
12.8 Tuning and diagnostic advisors
12.9 Automatic Workload Repository
12.10 Server generated alerts
12.11 Detect and resolve lock conflicts
12.12 Manage deadlocks
12.13 Transactions and locks
12.14 Lock Modes in10g |
