Exam Code: 1z0-042

Course Name: Oracle Database 10g: Administration I

Vendor: Oracle

Passing Score: 700

Oracle Database 10g: Administration I, also known as 1z0-042 exam, is one of the important Oracle certifications. The 1z0-042 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.

The 1z0-042 exam provides you with the technical knowledge and skills of installing Oracle Database 10g Software. Orcale Database 10g also helps you to create Oracle database and explore Oracle database architecture. Moreover, the 1z0-042 exam also enables you to control the database environment. In order to monitor and resolve lock conflicts, one must take the 1z0-042 exam. The Oracle database 10 g also makes you an expert in implementing Oracle database security and Oracle net services. The 1z0-042 exam also trains you in executing proactive maintenance and performance monitoring. The Oracle Database 10g: Administration I exam also equips you with the abilities of creating database backups and managing database recovery.

The internet has so many exam websites. To find the right one is a big problem. Testking is supposedly the only website which can provide you guidance in every way possible for 1z0-042 exam or Oracle Database 10g: Administration I. Therefore, if you are looking for the website which has the quality study material, then you must visit Testking. In order to keep a track of the changes taking place in different courses with the passage of time, you must contact TestKing as it upgrades the courses as soon as some changes take place.

The Study materials for the Oracle certification available at Testking are very helpful for the candidates who are taking 1z0-042 Exam for Oracle Database 10g: Administration I. The study material available at Testking is logical. Testking study material provides you with everything that you require to take this exam.

C ourse Outline: Oracle Database 10g: Administration I

Installing Oracle Database 10g Software

Identify system requirements

Use Optimal Flexible Architecture

Install software with Oracle Universal Installer

Identify and configure commonly used environment variables

Creating an Oracle Database

Explain the Oracle database architecture

Explain the instance architecture

Use the management framework

Use DBCA to Create a database

Use DBCA to Configure a database

Use DBCA to Drop a database

Use DBCA to Manage templates

Managing Schema Objects

Create and modify tables

Define constraints

View the attributes of a table

View the contents of a table

Create indexes and views

Name database objects

Select appropriate data types

Create and use sequences

Managing Data

Manipulate data through SQL using INSERT, UPDATE, and DELETE

Use Data Pump to export data

Use Data Pump to import data

Load data with SQL Loader

Create directory objects

PL/SQL

Identify PL/SQL objects

Describe triggers and triggering events

Undo Management

Monitor and administer undo

Configure undo retention

Guarantee undo retention

Use the Undo Advisor

Describe the relationship between undo and transactions

Size the undo tablespace

Monitoring and Resolving Lock Conflicts

Detect and resolve lock conflicts

Manage deadlocks

Describe the relationship between transactions and locks

Explain lock modes within the Oracle Database 10g

Controlling the Database

Start and stop iSQL*Plus

Start and stop Enterprise Manager Database Control

Start and stop the Oracle Listener

Start up and shut down Oracle Database 10g

Describe startup and shutdown options for the Oracle Database

Handle Parameter files

Locate and view the Database alert log

Oracle Database Security

Apply the principal of least privilege

Manage default user accounts

Implement standard password security features

Audit database activity

Register for security updates

Oracle Net Services

Use Database Control to Create additional listeners

Use Database Control to Create Oracle Net service aliases

Use Database Control to Configure connect time failover

Use Listener features

Use the Oracle Net Manager to configure client and middle-tier connections

Use TNSPING to test Oracle Net connectivity

Describe Oracle Net Services

Describe Oracle Net names resolution methods

Backup and Recovery Concepts

Describe the basics of database backup, restore and recovery

Describe the types of failure that may occur in an Oracle Database

Describe ways to tune instance recovery

Identify the importance of checkpoints, redo log files, and archived log files

Configure ARCHIVELOG mode

Configure a database for recoverability

Storage Structures

Define the purpose of tablespaces and data files

Create tablespaces

Manage tablespaces (alter, drop, generate DDL, take offline, put on line, add data files, make read-only/read-write)

Obtain tablespace information from EM and the data dictionary

Drop tablespaces

Describe the default tablespaces

Administering Users

Create and manage database user accounts

Create and manage roles

Grant and revoke privileges

Control resource usage by users

Oracle Shared Servers

Identify when to use Oracle Shared Servers

Configure Oracle Shared Servers

Monitor Shared Servers

Describe the shared server architecture

Performance Monitoring

Troubleshoot invalid and unusable objects

Gather optimizer statistics

View performance metrics

React to performance issues

Proactive Maintenance

Set warning and critical alert thresholds

Collect and use baseline metrics

Use tuning and diagnostic advisors

Use the Automatic Database Diagnostic Monitor (ADDM)

Manage the Automatic Workload Repository

Describe server generated alerts

Database Backups

Create consistent database backups

Back up your database without shutting it down

Create incremental backups

Automate database backups

Monitor the flash recovery area

Describe the difference between image copies and backup sets

Describe the different types of database backups

Backup a control file to trace

Manage backups

Database Recovery

Recover from loss of a Control file

Recover from loss of a Redo log file

Recover from loss of a system-critical data file

Recover from loss of a non system-critical data file