Oracle Database 11g Essentials

Содержание

Exam Topics:

Oracle Database Implementation

• Explain the features of security options in Oracle Database 11g
• Implement edition-based redefinition
• Explain the grid-enabling features in Oracle Database 11g
• Explain the enhanced manageability features in Oracle Database 11g

Overview of Oracle Database Administration

• Describe the structure of a relational database and use of SQL
• Identify the components of an Oracle instance and database
• Describe the basic tasks that an Oracle DBA performs
• Define the tools that are used to administer an Oracle database

Installing and Creating Oracle Database

• Install the Oracle Database software
• Create an Oracle database

Using Enterprise Manager Database Control & SQL*Plus

• Start the Enterprise Manager dbconsole process
• Access Enterprise Manager Database Control
• Navigate in Enterprise Manager Database Control
• Grant Enterprise Manager administrative privileges
• Use SQL*Plus to access your database

Configuring the Oracle Network Environment

• Describe the Oracle Network configuration
• Use the Enterprise Manager Net Services Administration page for Oracle Network configuration
• Use the Listener Control utility
• Configure a client to access an Oracle database

Managing the Oracle Instance

• Start up and shut down the Oracle instance
• View the parameters that are used to configure the Oracle instance
• Manage Oracle instance memory components

Managing Database Storage Structures

• Use Oracle Enterprise Manager to view database storage structures
• Create and manage storage structures in your database
• Reclaim unused space in your database
• Manage structures used to undo the changes that are made to the database and maintain consistency

Administering Users and Security

• Create and administer users
• Grant privileges to users to perform database operations
• Create and manage roles

Managing Schema Objects

• Create and modify database tables
• View data in the database
• Create additional database objects
• Load data into tables

Performing Backup and Recovery

• Configure the database for backup and recovery operations
• Create and manage database backups
• Restore and recover the database
• Use flashback features

Performing Backup and Recovery

• Describe the Oracle Self-Monitoring Architecture
• Use the performance advisors to optimize database performance

Investigating,Reporting, and Resolving Problems

• Use the Support Workbench to view critical error alerts
• Package diagnostic data for uploading to Oracle Support

Managing Oracle Database Software

• Keep your Oracle Database software up-to-date with patch and software releases
• Upgrade a database