|
|
Oracle 10g Database Administration II 1Z0-043
Join over 1 million people who learn
online, with these complete interactive computer training
courses.
|

See
How It Works
|
| This online course includes: |
Time Needed |
| Using Globalization Support Objectives |
1 hour |
| Configuring Recovery Manager |
1 hour |
| Recovering from User Errors |
1 hour |
| Dealing with Database Corruption |
1 hour |
| Automatic Database Management |
1 hour |
| Using Recovery Manager |
1 hour |
| Recovering from Non-Critical Losses |
1 hour |
| Monitoring and Managing Storage |
1 hour |
| Automatic Storage Management |
1 hour |
| Monitoring and Managing Memory |
1 hour |
| Database Recovery |
1 hour |
| Flashback Database |
1 hour |
| Managing Resources |
1 hour |
| Automating Tasks with the Scheduler |
1 hour |
| Practice Exam 1 |
1
hour |
| Practice Exam 2 |
1
hour |
| Practice Exam 3 |
1
hour |
| Practice Exam 4 |
1
hour |
| Practice Exam 5 |
1 hour |
| Estimated time needed to complete entire
course |
19
hours |
|
Receive your login ID to take the training courses online,
as many times as you wish, for 1 year.
Click
here for group orders.
| Buy this entire
online training course with one easy payment of $67 |
|
OR
| Buy the Technical
Pack, and receive this course
plus many more, for only $197
|
 |
|
Benefits |
- Unlimited access for
1 year
- Learn anytime,
anywhere
- You control the pace
- Start & stop
wherever you want
- No books to read
- No software needed
- Value Packs include
Free online tech support
- Double
guarantee
|
- 100% Money back
guarantee
- One time payment No
monthly fee
- Use the course index
for review anytime
- Answer course
questions with at least 70% accuracy and print
your own certificates of
completion to prove that you have mastered each training course.
- Free status reports
for company managers
|
|
|
Requirements |
All you need is a PC with Windows,
the Microsoft Internet Explorer (browser)
and an Internet connection.
Note: The online computer training is designed to
work only with Internet Explorer. Prices shown are per
user. |
|
What
You will Learn |
|
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.
Certification:
The test that this series prepares
students to take is a part of earning the Oracle Database 10g
Administrator Certified Professional certification.
|
|
Topic
Details |
- 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
- 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
- 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
- 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
- Describe
the different database advisors and their purpose
- Use
the SQL Tuning Advisor to improve database
performance
- Describe
how Oracle performs automatic undo retention
- 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
- Recover
temporary tablespaces
- Recover
Redo Log Members
- Recover
index tablespaces
|
- Recover
read-only tablespaces
- Recreate
a password file to the database
- 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
- 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
- Define
the System Global Area (SGA) and list its
components
- Describe
Automatic Shared Memory Management (ASMM)
- Define
the Program Global Area (PGA)
- Recover
a Control file
- Describe
reasons for incomplete recovery
- Perform
incomplete recovery using EM, RMAN, and SQL
- Perform
database recovery following a RESETLOGS operation
- 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
- Manage
resources using Resource Manager
- Assign
users to Resource Manager groups
- Create
resource plans within groups
- Specify
directives for allocating resources to consumer
groups
- 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
- Complete
the practice exam questions
|
|
|