Oracle 10g Database Administration II 1Z0-043
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.
Using Globalization Support Objectives
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 and 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.
Configuring Recovery Manager
This course discusses the four main components of the Recovery Manager (RMAN) and its uses for interacting with databases and maintaining information and 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.
Recovering from User Errors
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 and 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.
Dealing with Database Corruption
This course provides information and instruction on database corruption, how it occurs, and how to handle it and 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.
Automatic Database Management
This course discusses the tools that help automate several routine administrative tasks, such as SQL tuning, space management, memory management, and overall performance diagnostics and 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.
Using Recovery Manager
This course discusses the Oracle database backup and recovery utility, Recovery Manager (RMAN) and 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.
Recovering from Non-Critical Losses
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 and 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.
Monitoring and Managing Storage
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 and 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.
Automatic Storage Management
This course discusses the use of Automatic Storage Management (ASM), and the different tools used to administer ASM and 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.
Monitoring and Managing Memory
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 and 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).
Database Recovery
This course provides information and instruction on how to perform various types of database recovery and 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.
Flashback Database
This course discusses the Flashback Database and related technologies that are used in database recovery situations and 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.
Managing Resources
This course provides information and instruction on resource management using the Resource Manager feature of Oracle 10g and 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.
Automating Tasks with the Scheduler
This course provides information and instruction on how to perform the automation of tasks with the Scheduler and 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.
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.