Oracle 10g Database Administration II 1Z0-043 - Online Course

The Oracle Database 10g: Administration II study guide will prepare you for the test to be certified as an Oracle Certified Professional, Oracle Database 10g Administrator. This series will cover some of the more in-depth database administration topics, such as troubleshooting, problem recovery, and managing storage and memory. Practice exams are also included, which will allow you to answer questions in the same format that the test will use on exam day, and will provide in-depth instructional feedback on each question to thoroughly cover every subject you'll need to master.

This series is for anyone who wants to achieve Oracle 10g 1Z0-043 certification. This online course contains 14 lessons and 5 practice exams and should take approximately 19 hours to complete.

Lesson 1: Using Globalization Support Objectives (1.0) hour

Using Globalization Support Objectives teaches you how to customize language-dependent behavior for the Database and individual sessions, specify different linguistic sorts for queries, use Datetime Datatypes, query data using case insensitive and accent insensitive searches, and obtain Globalization support configuration information. This course discusses the purpose and importance of Globalization Support, which allows Oracle users to interact with applications in their native languages using the conventions of those languages for displaying data. This course also covers the date and time functionalities offered by Oracle to specify local time. Topics include Using Globalization Support Objectives.

Lesson 2: Configuring Recovery Manager (1.0) hour

Configuring Recovery Manager teaches you how to configure database parameters that affect RMAN operations, change RMAN default settings with CONFIGURE, manage RMAN's persistent settings, and start the RMAN utility and allocate channels. This course discusses the four main components of the Recovery Manager (RMAN) and its uses for interacting with databases and maintaining information. Topics include Configuring Recovery Manager.

Lesson 3: Recovering from User Errors (1.0) hour

Recovering from User Errors teaches you how to recover a dropped table using Flashback technology, perform a Flashback table operation, manage the Recycle Bin, recover from user errors using Flashback Versions Query, and perform transaction level recovery using Flashback Transaction Query. This course discusses using the Flashback Database feature to recover a table dropped by a user. This course also covers the Recycle Bin and how it can be used to recover dropped tables, nested tables, constraints, indexes, and other objects. Topics include Recovering from User Errors.

Lesson 4: Dealing with Database Corruption (1.0) hour

Dealing with Database Corruption teaches you how to define block corruption, list the causes and symptoms of block corruption, detect database corruptions using ANALYZE, use DBVERIFY, detect database corruptions using DBMS_REPAIR, implement the DB_BLOCK_CHECKING parameter to detect corruptions, and repair corruptions using RMAN. This course provides information and instruction on database corruption, how it occurs, and how to handle it. Topics include Dealing with Database Corruption.

Lesson 5: Automatic Database Management (1.0) hour

Automatic Database Management teaches you how to describe the different database advisors and their purpose, use the SQL Tuning Advisor to improve database performance, and describe how Oracle performs automatic undo retention. This course discusses the tools that help automate several routine administrative tasks, such as SQL tuning, space management, memory management, and overall performance diagnostics. Topics include Automatic Database Management.

Lesson 6: Using Recovery Manager (1.0) hour

Using Recovery Manager teaches you how to use RMAN to create backup sets and image copies using the RMAN BACKUP command, describe the use of and how to enable block change tracking within RMAN, and manage the backups and image copies taken with RMAN using the LIST and REPORT commands. This course discusses the Oracle database backup and recovery utility, Recovery Manager (RMAN). Topics include Using Recovery Manager.

Lesson 7: Recovering from Non-Critical Losses (1.0) hour

Recovering from Non-Critical Losses teaches you how to recover temporary tablespaces, recover Redo Log Members, recover index tablespaces, recover read-only tablespaces, and recreate a password file to the database. This course discusses not only how to recover from non-critical losses, but also how good architecture and backup policies can assure that certain media losses remain non-critical. Topics include Recovering from Non-Critical Losses.

Lesson 8: Monitoring and Managing Storage (1.0) hour

Monitoring and Managing Storage teaches you how to describe the use of Redo and Archive logs, suspend transactions that hit space problems, size the tables appropriately using the Segment Advisor, and rebuild indexes online. This course discusses the tools used to monitor and manage storage in an Oracle 10g Database, such as the Segment Advisor, the Undo Advisor, and the Redo Logfile Size Advisor. This course also covers index-organized tables, clustered tables, sorted hash clusters, and Resumable Space Allocation. Topics include Monitoring and Managing Storage.

Lesson 9: Automatic Storage Management (1.0) hour

Automatic Storage Management teaches you how to describe how to use Oracle Automatic Storage Management, set up the initialization parameter file for ASM, execute SQL commands with ASM file names, start up and shut down ASM instances, and administer ASM disk groups and use RMAN to migrate to ASM. This course discusses the use of Automatic Storage Management (ASM), and the different tools used to administer ASM. Topics include Automatic Storage Management.

Lesson 10: Monitoring and Managing Memory (1.0) hour

Monitoring and Managing Memory teaches you how to define the System Global Area (SGA) and list its components, describe Automatic Shared Memory Management (ASMM), and define the Program Global Area (PGA). This course discusses the System Global Area (SGA) and its uses for shared memory management, as well as the Program Global Area (PGA) and its uses for private memory storage. Topics include Monitoring and Managing Memory.

Lesson 11: Database Recovery (1.0) hour

Database Recovery teaches you how to recover a Control file, describe reasons for incomplete recovery, perform incomplete recovery using EM, RMAN, and SQL, and perform database recovery following a RESETLOGS operation. This course provides information and instruction on how to perform various types of database recovery. Topics include Database Recovery.

Lesson 12: Flashback Database (1.0) hour

Flashback Database teaches you how to determine which Flashback technology to use for each recovery situation, configure, use, and monitor Flashback Database, use the Enterprise Manager Recovery Wizard to Flashback Database, and manage and maintain the Flash Recovery Area. This course discusses the Flashback Database and related technologies that are used in database recovery situations. Topics include Flashback Database.

Lesson 13: Managing Resources (1.0) hour

Managing Resources teaches you how to manage resources using Resource Manager, assign users to Resource Manager groups, create resource plans within groups, and specify directives for allocating resources to consumer groups. This course provides information and instruction on resource management using the Resource Manager feature of Oracle 10g. Topics include Managing Resources.

Lesson 14: Automating Tasks with the Scheduler (1.0) hour

Automating Tasks with the Scheduler teaches you how to simplify management tasks by using the Scheduler, create a job, program, schedule, and window, re-use the Scheduler components for similar tasks, and view information about job executions and job instances. This course provides information and instruction on how to perform the automation of tasks with the Scheduler. Topics include Automating Tasks with the Scheduler.

5 Practice Exams

This course presents questions that will help you prepare for the Oracle 10g Database Administration II 1Z0-043 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.