Skip to Content

Certification Products
 
Customer Quotes

I used the Examguru guides only after my friend recommended it to me. The quality of questions and the explanations were good to forget the price I paid for it. The features have been really useful and really worthy. I will definitely recommend your products to all my friends and associates.


Read More...

Oracle Database 10g Administrator Exam - 1Z0-043 Oracle Database 10g: Administration II Objectives
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 RMANs 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
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 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
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

 
Continue
Member Login


Forgot password? | Register
 
Shopping Cart

  •    0 items
 
Certification Resources

 
Smart Shopping