Exam Code: 1z0-040

Course Name: Oracle Database 10g: New Features for Administrators

Vendor: Oracle

Passing Score: 73%

Oracle Database 10g: New Features for Administrators, also known as 1z0-040 exam, is one of the important Oracle certifications. The 1z0-040 exam is for those IT Professionals who wish to work as Oracle database administrators. Moreover, senior database developers can take the benefit by understanding the architecture of the Oracle database with which they interface. This Oracle certification is recommended for those IT Professionals who have completed ora10g008 or equivalent as well as ora10g009. Actually this certification is a DBA OCP upgrade path to Oracle Database 10g.

The 1z0-040 exam provides you with the technical knowledge and skills of installing Oracle Database 10g Software with new feature support and also enhancements in installation performance. Oracle Database 10g also helps you to create Oracle database and explore Oracle data pump architecture. Moreover, the 1z0-040 exam also enables you to control the database environment, automatic management, manageability infrastructure, application tuning, server configuration. In order to monitor system resource management, automating tasks with the scheduler, space management, improved VLDB Support, and backup and recovery enhancement, one must take the 1z0-040 exam. The Oracle database 10 g also makes you an expert in implementing Oracle database security policies and other new miscellaneous features. The 1z0-040 exam also trains you in executing proactive maintenance of tablespace usage and performance monitoring. Oracle Database 10g: New Features for Administrators exam also equips you with the abilities to manage General Storage enhancement, automatic storage management and configure and use flashback database. Recovery and flashback is very important in any databases and in oracle Database 10g: New Feautres for administrators exam you will be trained against all these new feature. So as a 1z0-040 certified professional one can secure his career in Oracle Database jobs. As prominent organizations prefer a certified person as compare to non-certified.

There are many websites on the internet which work as exam guides. Testking is also one such website which is the best exam guide and has the best study materials for 1z0-040 exam or Oracle Database 10g: New Features for Administrators. The study material for 1z0-040 exam (Oracle Database 10g: New Features for Administrators) available at Testking is precise. Whenever some changes take place in the certification course material of any vendor, TestKing is the leading website to update the courses.

If you want to experience the same way as if you are sitting in Prometric Examination room, then you must visit Testking and try its exam guide having questions and confirmed correct answers to these questions. TestKing is the only leading website that updates the courses as soon as some changes take place in the exam course.

Course Outline: Oracle Database 10g: New Features for Administrators

Installation

Describe installation new features support

Describe installation performance enhancements

Server Configuration

Simplify instance configuration using a subset of initialization parameters

Use policy-based database configuration framework

View database usage statistics through EM

Load and Unload Data

Transport tablespaces across different platforms

Explain Data Pump architecture

Monitor a Data Pump job

Use Data Pump export and import

Create external tables for data population

Define your external table properties

Automatic Management

Use Automatic Database Diagnostic Monitor

Use Automatic Shared Memory Management

Use Automatic Optimizer Statistics Collection

Use Automatic Undo Retention Tuning

Manageability Infrastructure

Monitor and maintain the AWR

Use the Active Session History (ASH)

Monitor and manage server-generated alerts

Explain the automated tasks feature

Describe the advisory framework

Application Tuning

Use the new optimizer statistics

Use the SQL Tuning Advisor

Use the SQLAccess Advisor

Use the performance pages of Database Control

System Resource Management

Automatically switch a session back to the original consumer group at the end of the top call

Set idle time-outs for consumer groups

Create mappings for the automatic assignment of sessions to consumer groups

Automating Tasks with the Scheduler

Simplify management tasks by using the Scheduler

Create a job, program, schedule and window

Reuse scheduler components for similar tasks

View information about job executions and job instances

Space Management

Reduce space related error conditions through proactively managing tablespace usage

Reclaim wasted space from tables and indexes using the segment shrink functionality

Use the Segment Advisor

Use the Undo Advisor

Use sorted hash clusters

Improved VLDB Support

Create and maintain bigfile tablespaces

Create temporary tablespace groups

Assign temporary tablespace groups to users

Skip unuseable indexes

Specify storage characteristics for index partitions in the table partition DML commands

Create hash-partitioned global indexes

Maintain hash-partitioned global indexes

Backup and Recovery Enhancements

Simplify file management for all recovery-related files

Reduce restore time by applying incremental backups to data file image copies

Simplify recovery after opening the database with the RESETLOGS option

Speed backup times by creating faster incremental backups

Minimize load requirements by specifying limits in backup time windows

Save storage space through writing compressed backup sets

Flashback Any Error

Configure and use Flashback Database

Recover dropped tables with the Flashback Drop feature

Retrieve row history information with the Flashback Versions Query feature

Audit or recover FROM transactions with the Flashback Transaction Query feature

Recover tables to a point in time with the Flashback Table feature

General Storage Enhancement

Create the SYSAUX tablespace

Relocate SYSAUX occupants

Rename tablespaces

Create a default permanent tablespace

Copy files using the Database Server

Use the Redo Logfile Size Advisor

Automatic Storage Management

Describe 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

Maintain Software

Understand the supported upgrade paths to Oracle Database 10g

Use new utility to perform pre-upgrade validation checks

Use simplified upgrade process that automatically determines components to be upgraded

Start up the database using a new mode when upgrading

Security

Apply a column level VPD policy

Apply static and non-static policies

Share VPD policy functions

Use the unified audit trails

Use fine-grained auditing for DML statements

Miscellaneous New Features

Provide greater flexibility by enabling resumable timeout at the instance level

Use regular expression support in SQL and PL/SQL for string searching, matching and replacing

Use additional linguistic comparison and sorting methods in SQL

Use SQL to flush the buffer cache