|Oracle 10g OCP|
Training at Nhames Limited is a wonderful experience.
ORACLE 10g OCP Certification Exam and Courses Highlight:
Database Administrator: Database Administrators are responsible for administrative activities like installing database, taking backups, managing and fine-tuning performance over the network, and data recovery. They have the knowledge of basic architecture of the Oracle database.
OCP Exam #1Z0-043
Oracle Database 10g: Administration II
Using Globalization Support Objectives
Customize language-dependent behavior for the database and individual sessions
Specify different linguistic sorts for queries
Use datatime datatypes
Query data using case insensitive and accent insensitive searches
Obtain Globalization support configuration information
Securing the Oracle Listener
Secure the listener
Remove default EXTPROC entry and add a separate listener to handle external procedure calls
Configuring Recovery Manager
Configure database parameters that affect RMAN operations
Change RMAN default settings with CONFIGURE
Manage RMAN’s persistent settings
Start RMAN utility and allocate channels
Recovering from User Errors
Recover a dropped table using Flashback technology
Perform Flashback table operation
Manage the recycle bin
Recover from user errors using Flashback versions query
Perform transaction level recovery using Flashback Transaction query
Dealing with Database Corruption
Define block corruption and list its causes and symptoms
Detect database corruptions using the following utilities: ANALYZE
DBVERIFY
Detect database corruptions using the dbms_repair package
Implement the DB_BLOCK_CHECKING parameter to detect corruptions
Repair corruptions using RMAN
Automatic Database Management
Use the Database Advisors to gather information about your database
Use the SQL Tuning Advisor to improve database performance
Use automatic undo retention tuning
Using Recovery Manager
Use the RMAN BACKUP command to create backup sets and image copies
Enable block change tracking
Manage the backups and image copies taken with RMAN with the LIST and REPORT commands
Diagnostic Sources
Use the alert log and database trace files for diagnostic purposes
View alerts using Enterprise Manager
Adjust thresholds for tracked metrics
Control the size and location of trace files
Monitoring and Managing Storage
Tune redo writing and archiving operations
Issue statements that can be suspended upon encountering space condition errors
Reduce space-related error conditions by proactively managing tablespace usage
Reclaim wasted space from tables and indexes using the segment shrink functionality
Estimate the size of new table and indexes
Use different storage options to improve the performance of queries
Rebuild indexes online
Automatic Storage Management
Set up initialization parameter files for ASM and database instances
Execute SQL commands with ASM file names
Start up and shut down ASM instances
Administer ASM disk groups
Use RMAN to migrate your database to ASM
Recovering from Non-Critical Losses
Recover temporary tablespaces
Recover a redo log group member
Recover index tablespaces
Recover read-only tablespaces
Recreate the password file
Monitoring and Managing Memory
Implement Automatic Shared Memory Management
Manually configure SGA parameters for various memory components in the SGA
Use Automatic PGA Memory Management
Database Recovery
Recover the control file
Explain reasons for incomplete recovery
Perform incomplete recovery using EM
Perform incomplete recovery using RMAN
Perform incomplete recovery using SQL
Perform database recovery following a RESETLOGS operation
Flashback Database
Determine which flashback technology to use for each recovery situation
Configure and sue Flashback Database
Monitor the Flashback Database
Use the Enterprise Manager Recovery Wizard to flashback database
Manage (or maintain) the Flash Recovery Area