Webucator personnel did a great job meeting our specific needs and in putting our class together. More Testimonials »

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


Save money by buying eLearning courses in packages.

Packages include multiple eLearning courses that are bundled together for a great value.

Of course, you can buy this Oracle 10g Database Administration II 1Z0-043 eLearning course individually as well. Just click on the "Register Now" button below.


Oracle 10g Database Administration II 1Z0-043 eLearning Course Series (19 hours)

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.

Self-Paced eLearning Course Benefits

Only $99.95

12-month subscription!

Register Now

  • Learn online with these interactive online courses.
  • Affordable Pricing (Only $99.95 for the complete series)
  • A full year to complete the courses
  • Retake the courses as many times as you like
  • Measure your progress with assessment tests after each course
  • Earn completion certificates after passing each assessment test

1. Oracle 10g Database Administration II 1Z0-043:1 Using Globalization Support Objectives (Time: 1 hours)

This eLearning 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.

Course Objectives

  • 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
  • Obtain Globalization support configuration information

Course Topics

  • Using Globalization Support Objectives

2. Oracle 10g Database Administration II 1Z0-043:2 Configuring Recovery Manager (Time: 1 hours)

This eLearning course discusses the four main components of the Recovery Manager (RMAN) and its uses for interacting with databases and maintaining information.

Course Objectives

  • Configure database parameters that affect RMAN operations
  • Change RMAN default settings with CONFIGURE
  • Manage RMAN's persistent settings
  • Start the RMAN utility and allocate channels

Course Topics

  • Configuring Recovery Manager

3. Oracle 10g Database Administration II 1Z0-043:3 Recovering from User Errors (Time: 1 hours)

This eLearning 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.

Course Objectives

  • Recover a dropped table using Flashback technology
  • Perform a Flashback table operation
  • Manage the Recycle Bin
  • Recover from user errors using Flashback Versions Query
  • Perform transaction level recovery using Flashback Transaction Query

Course Topics

  • Recovering from User Errors

4. Oracle 10g Database Administration II 1Z0-043:4 Dealing with Database Corruption (Time: 1 hours)

This eLearning course provides information and instruction on database corruption, how it occurs, and how to handle it.

Course Objectives

  • 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
  • Repair corruptions using RMAN

Course Topics

  • Dealing with Database Corruption

5. Oracle 10g Database Administration II 1Z0-043:5 Automatic Database Management (Time: 1 hours)

This eLearning course discusses the tools that help automate several routine administrative tasks, such as SQL tuning, space management, memory management, and overall performance diagnostics.

Course Objectives

  • Describe the different database advisors and their purpose
  • Use the SQL Tuning Advisor to improve database performance
  • Describe how Oracle performs automatic undo retention

Course Topics

  • Automatic Database Management

6. Oracle 10g Database Administration II 1Z0-043:6 Using Recovery Manager (Time: 1 hours)

This eLearning course discusses the Oracle database backup and recovery utility, Recovery Manager (RMAN).

Course Objectives

  • 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
  • Manage the backups and image copies taken with RMAN using the LIST and REPORT commands

Course Topics

  • Using Recovery Manager

7. Oracle 10g Database Administration II 1Z0-043:7 Recovering from Non-Critical Losses (Time: 1 hours)

This eLearning 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.

Course Objectives

  • Recover temporary tablespaces
  • Recover Redo Log Members
  • Recover index tablespaces
  • Recover read-only tablespaces
  • Recreate a password file to the database

Course Topics

  • Recovering from Non-Critical Losses

8. Oracle 10g Database Administration II 1Z0-043:8 Monitoring and Managing Storage (Time: 1 hours)

This eLearning 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.

Course Objectives

  • Describe the use of Redo and Archive logs
  • Suspend transactions that hit space problems
  • Size the tables appropriately using the Segment Advisor
  • Rebuild indexes online

Course Topics

  • Monitoring and Managing Storage

9. Oracle 10g Database Administration II 1Z0-043:9 Automatic Storage Management (Time: 1 hours)

This eLearning course discusses the use of Automatic Storage Management (ASM), and the different tools used to administer ASM.

Course Objectives

  • 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
  • Administer ASM disk groups and use RMAN to migrate to ASM

Course Topics

  • Automatic Storage Management

10. Oracle 10g Database Administration II 1Z0-043:10 Monitoring and Managing Memory (Time: 1 hours)

This eLearning 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.

Course Objectives

  • Define the System Global Area (SGA) and list its components
  • Describe Automatic Shared Memory Management (ASMM)
  • Define the Program Global Area (PGA)

Course Topics

  • Monitoring and Managing Memory

11. Oracle 10g Database Administration II 1Z0-043:11 Database Recovery (Time: 1 hours)

This eLearning course provides information and instruction on how to perform various types of database recovery.

Course Objectives

  • Recover a Control file
  • Describe reasons for incomplete recovery
  • Perform incomplete recovery using EM, RMAN, and SQL
  • Perform database recovery following a RESETLOGS operation

Course Topics

  • Database Recovery

12. Oracle 10g Database Administration II 1Z0-043:12 Flashback Database (Time: 1 hours)

This eLearning course discusses the Flashback Database and related technologies that are used in database recovery situations.

Course Objectives

  • 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
  • Manage and maintain the Flash Recovery Area

Course Topics

  • Flashback Database

13. Oracle 10g Database Administration II 1Z0-043:13 Managing Resources (Time: 1 hours)

This eLearning course provides information and instruction on resource management using the Resource Manager feature of Oracle 10g.

Course Objectives

  • Manage resources using Resource Manager
  • Assign users to Resource Manager groups
  • Create resource plans within groups
  • Specify directives for allocating resources to consumer groups

Course Topics

  • Managing Resources

14. Oracle 10g Database Administration II 1Z0-043:14 Automating Tasks with the Scheduler (Time: 1 hours)

This eLearning course provides information and instruction on how to perform the automation of tasks with the Scheduler.

Course Objectives

  • Simplify management tasks by using the Scheduler
  • Create a job, program, schedule, and window
  • Re-use the Scheduler components for similar tasks
  • View information about job executions and job instances

Course Topics

  • Automating Tasks with the Scheduler

15. Oracle 10g Database Administration II 1Z0-043:15 Practice Exam 1 (Time: 1 hours)

This eLearning 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.

Course Objectives

  • Complete the practice exam questions

Course Topics

  • Practice exam

16. Oracle 10g Database Administration II 1Z0-043:16 Practice Exam 2 (Time: 1 hours)

This eLearning 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.

Course Objectives

  • Complete the practice exam questions

Course Topics

  • Practice exam

17. Oracle 10g Database Administration II 1Z0-043:17 Practice Exam 3 (Time: 1 hours)

This eLearning 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.

Course Objectives

  • Complete the practice exam questions

Course Topics

  • Practice exam

18. Oracle 10g Database Administration II 1Z0-043:18 Practice Exam 4 (Time: 1 hours)

This eLearning 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.

Course Objectives

  • Complete the practice exam questions

Course Topics

  • Practice exam

19. Oracle 10g Database Administration II 1Z0-043:19 Practice Exam 5 (Time: 1 hours)

This eLearning 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.

Course Objectives

  • Complete the practice exam questions

Course Topics

  • Practice exam
Client Success
  1. Independent Survey
  2. Client List
  3. Testimonials
Join The Team
  1. Learn how you can become a Webucator Trainer
  2. Career Opportunities
Locations
Watch 3-minute Demo Video
of Live Online Training:
Learn the benefits of online training with Webucator

Free Webinars

A Crash Course in CSS

Wed, 3/21 1:00 PM EST

Project Management Institute Partner

Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.

© Webucator, Inc. All rights reserved. | Toll Free: 1-877-932-8228 | From outside the USA: 315-849-2724| Fax: 315-849-2723