Oracle Database 10g: Administrator Workshop II (exam 1Z0-043)

• Recognize situations that are suited to the use of Flashback Database.
• Execute a Flashback Database operation
• Enable Flashback features and perform a Flashback Database operation
• Identify the recommended steps to perform a Flashback Table operation in a given scenario
• Identify the appropriate Flashback Query feature to be used for given scenarios
• Use Flashback features to audit and fix tables
• Use the Recycle Bin to perform a Flashback Drop operation and to purge items
• Determine suitable uses of appropriate Flashback features for given scenarios

• Identify the characteristics of an example RMAN command
• Use the RMAN command line to create basic backups
• Implement a suitable backup strategy in a given scenario
• Implement a suitable backup strategy in a given scenario
• Use appropriate commands to manage backups in RMAN
• Use RMAN commands to create and manage backups

• Distinguish between the steps to recover non-critical files
• Perform a suitable incomplete recovery in a given scenario
• Perform an appropriate incomplete recovery and recoveries of non-critical files in a given scenario
• Select the appropriate detection method for database corruption scenarios
• Rank appropriate steps and their associated procedures for using DBMS_REPAIR
• Use the BLOCKRECOVER command to restore data blocks
• Implement an appropriate recovery strategy for database corruption

• Set the listener password and specify who can access a database
• Improve the security for external procedures
• Tighten security for the Oracle 10g listener
• Use Net Services to connect to a database
• Create database links and view information about them
• Recognize situations when manual resolution of distributed transactions is required
• Use database links and transactions

• Recognize how Oracle's architecture supports globalization features
• Recognize the appropriate NLS parameter to use in a given scenario
• Specify character sets and use appropriate datatypes to standardize timestamps across timezones
• Determine appropriate methods for implementing a globalization solution for a given database
• Use the appropriate method for configuring linguistic sorting in a given scenario
• Recognize suitable methods for implementing linguistic comparisons and case-insensitive searches, and distinguish between methods to display linguistic settings
• Use the appropriate methods to utilize linguistic support in a given scenario

• View and configure alerts
• Identify situations when trace files and SQL tracing are useful
• Use Oracle Database 10g diagnostic tools to resolve database problems in a given scenario
• Recognize situations to run ADDM
• Recognize when to use the SQL Tuning Advisor and Access Advisor
• Use the Segment Advisor and Undo Advisor to implement appropriate space management settings
• Use appropriate Oracle advisor tools in given scenarios

• Define the components of the Automatic Storage Management architecture in Oracle Database 10g
• Identify the processes associated with ASM instance administration, startup, and shutdown
• Create and manage disk groups
• Create a disk group and add a disk in a given scenario
• Create a basic database resource plan
• Recognize suitable Resource Manager configuration options to use in given scenarios
• Create and implement a resource management plan

• Define the components of the Oracle Database 10g Scheduler and identify the SQL used to assign privileges to them
• Create jobs, programs, and schedules in Oracle Database 10g
• Create job classes, windows, and job priorities in Oracle Database 10g
• Create a job, job class, and window in Oracle Database 10g Enterprise Manager in a given scenario
• Use the GUI and code-based tools to manage Scheduler components in Oracle Database 10g
• View information about jobs and purge jobs in Oracle Database 10g.
• Use the appropriate tools in Enterprise Manager to drop a job, change Scheduler attributes, and view job details in a given scenario

• Identify the steps required to use the resumable statements feature
• Create an external table
• Create and configure materialized views
• Enable resumable statements and create external tables and materialized views

De training bevat een speciale kennistest als afronding. Tijdens deze kennistest wordt al het geleerde nog een keer getest en krijgt u een goed beeld of u uzelf alle lesstof eigen heeft gemaakt.