|
|
Oracle9i Database Fundamentals II 1Z0-032
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 |
| Networking Overview |
1 hour |
| Basic Oracle Net Architecture |
1 hour |
| Basic Oracle Net Server-Side Configuration |
1 hour |
| Basic Oracle Net Services Client-Side Configuration |
1 hour |
| Usage and Configuration of the Oracle Shared Server |
1 hour |
| Backup and Recovery Overview |
1 hour |
| Instance and Media Recovery Structures |
1 hour |
| Configuring the Database Archiving Mode |
1 hour |
| Oracle Recovery Manager Overview and Configuration |
1 hour |
| User-Managed Backups |
1 hour |
| RMAN Backups |
1 hour |
| User-Managed Complete Recovery |
1 hour |
| RMAN Complete Recovery |
1 hour |
| User-Managed Incomplete Recovery |
1 hour |
| RMAN Incomplete Recovery |
1 hour |
| RMAN Maintenance |
1
hour |
| Recovery Catalog Creation and Maintenance |
1
hour |
| Transporting Data Between Databases |
1
hour |
| Loading Data into a Database |
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 |
24
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 |
|
This study guide will prepare you to
take one of the two required Oracle9i tests to be certified as
an Oracle Certified Professional, Oracle9i Database
Administrator. 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 Oracle9i Database
Administrator Certified Professional certification.
|
|
Topic
Details |
- Describe
networking challenges in the business environment
- Describe
typical network configurations in the business
environment
- Identify
and describe Oracle's solutions to networking
issues
- Describe
the Open System Interconnection (OSI) architecture
- Describe
Oracle Net services
- Describe
Oracle Net layered architecture
- Describe
Web client services
- Describe
the components of the listener
- Describe
how to configure and control the listener
- Describe
dynamic service registration
- Describe
how to configure the listener for IIOP
- Describe
Oracle Net naming methods
- Configure
host naming and local naming methods
- Configure
net service names
- Perform
simple net troubleshooting
- Identify
components of the Oracle Shared Server
- Define
Oracle Shared Server architecture
- Define
how to configure Oracle Shared Server
- Define
how to query related dictionary views
- Define
the basics of Oracle database backup, restoration
and recovery
- Describe
Oracle backup and recovery strategies
- Create
and implement disaster recovery plans
- Implement
Oracle's high availability features
- Describe
Oracle memory structures
- Define
Oracle background processes
- Define
Oracle database files
- Describe
the importance of checkpoints during instance
recovery
- Describe
the differences between ARCHIVELOG and
NOARCHIVELOG mode
- Configure
a database for ARCHIVELOG mode
- Configure
multiple ARCHIVELOG processes
- Configure
multiple destinations, including remote
destinations
- Query
useful dynamic views
- Describe
the RMAN repository
- Describe
RMAN channel allocation
- Describe
the Media Management Library interface
- Connect
to RMAN without a recovery catalog
- Configure
the RMAN environment
- Demonstrate
how to perform user-managed closed and open
database backups
- Describe
how to perform user-managed backups of read-only
tablespaces, control files and archived redo logs
- Show
how to clean up after failed online backups
- Describe
the implications of LOGGING and NOLOGGING
operations
- Explain
how to use the DBVERIFY utility
- Describe
how to perform server-managed backup and recovery
- Demonstrate
how to create and use RMAN image copies and backup
sets
- Explain
how to create and use tags in backup sets and
image copies
- Describe
how to back up control files and archived redo log
files using RMAN
- Explain
how to query and interpret RMAN-related dynamic
performance views
- Demonstrate
how to perform user-managed complete recovery
- Describe
how to perform user-managed complete recovery in
NOARCHIVELOG mode
|
- Describe
how to perform user-managed complete recovery in
ARCHIVELOG mode
- Explain
how to restore data files to different locations
- Describe
how to relocate and restore a tablespace using
archived redo log files
- Describe
how to recover from the loss of an online inactive
redo log group
- Demonstrate
how to perform complete recovery using the
Recovery Manager
- Explain
how to perform complete recovery in NOARCHIVELOG
mode
- Describe
how to perform complete recovery in ARCHIVELOG
mode
- Explain
how to restore data files to different locations
using the Recovery Manager
- Describe
how to relocate and recover a tablespace using
archived redo log files
- Describe
how to perform block media recovery
- Demonstrate
how to perform incomplete recovery
- Explain
how to recover from a crash without applying all
available redo using RESTORE and RECOVER commands
- Describe
how to identify and recover from the loss of an
online redo log file
- Explain
how to perform media recovery in parallel
- Describe
dynamic performance views
- Demonstrate
how to perform incomplete recovery using the
Recovery Manager
- Describe
how to perform incomplete database recovery using
UNTIL TIME
- Explain
how to perform incomplete database recovery using
UNTIL SEQUENCE
- Describe
how the Recovery Manager performs restore
optimization
- Demonstrate
how to use the RMAN CROSSCHECK command to maintain
the RMAN repository
- Explain
how to perform crosscheck of backup sets and image
copies
- Describe
how to update the repository when backups have
been deleted
- Explain
how to change the availability status of backup
sets and image copies
- Demonstrate
how to exempt a backup set or an image copy from
the retention policy
- Describe
how to catalogue backups made with operating
system commands
- Explain
the benefits of creating and using a recovery
catalog database
- Describe
how to create and use a recovery catalog
- Demonstrate
how to use the Recovery Manager to register,
resynchronize and reset a database
- Describe
how to query the recovery catalog to generate
reports and lists
- Demonstrate
how to create, store and run scripts
- Explain
how to back up and recover the recovery catalog
- Describe
export and import concepts and structures
- Describe
methods to invoke export and import
- Define
guidelines for using export and import
- Describe
SQL*Loader usage and how to perform basic
SQL*Loader operations
- Describe
different loading methods in SQL*Loader
- Describe
the format of SQL*Loader files
- Explain
the guidelines for using SQL*Loader and direct
load insert
- Demonstrate
how to perform direct path insert operations
- Complete
the practice exam questions
|
|
|
