About Exam

Exam number/code: 1Z0-035
Exam name: Oracle 7.3
Exam no. of questions: 84 Questions
Duration: 120 minutes
Passing score: 69%
Question types: Multiple choice questions (MCQ's), Multiple choice single answer, Multiple choice multiple answer, Drag and drop & Simulations (optional)

• Using Partitioning: Conceptual Overview
• Implementing Partitioned Indexes
• Supporting Commands and Guidelines for Partitioned Tables and Indexes
• Parallelizing INSERT, UPDATE, and DELETE Operations
• Identifying New ROWID Structure
• Managing Large Objects
• Oracle Universal Installer: Migration and Upgrade
• Database Resource Manager
• Manageability Enhancements
• Availability and Recoverability Enhancements
• Online Operations
• Segment Management
• Performance Improvements
• Implementing Oracle Advanced Queuing
• Using Additional New Features
• Introduction to Recovery Manager
• Enhancements to Networking
• Implementing Password Management
• SQL*Plus, PL/SQL, and National Language Support Enhancements
• Database Security
• Oracle Server Security
• General High Availability Technology
• Real Application Clusters
• File Management
• Tablespace Management
• Memory Management
• Optimizer and Query Improvements
• Summary Management
• Indexes and Index-Organized Tables
• Partitioning Improvements
• LOBs
• Oracle9i LogMiner Enhancements
• Backup and Recovery
• Oracle9i Data Guard
• Database Resource Manager Enhancements
• Enterprise Manager Enhancements
• SQL Enhancements
• Globalization Support
• Database Workspaces

Exam Objectives

Using Partitioning: Conceptual Overview

• Describe the general partioning rules

Implementing Partitioned Indexes

• Describe the different types of partitioned indexes

Supporting Commands and Guidelines for Partitioned Tables and Indexes

• Describe restrictions that apply to certain operations

Parallelizing INSERT, UPDATE, and DELETE Operations

• Enable parallel DML for a session

Identifying New ROWID Structure

• Describe the new ROWID format

Managing Large Objects

• Differentiate between internal and external LOBs

Oracle Universal Installer: Migration and Upgrade

• Upgrade a database to Oracle9i

Database Resource Manager

• Explain the features of the database resource manager

Manageability Enhancements

• Relocate and reorganize tables
• Remove unused columns from a table
• Define temporary tables

Availability and Recoverability Enhancements

• Implement duplex and multiple archive logs
• Describe the functionality of LogMiner
• Implement fast-start fault recovery
• Manage corrupt block detection and repair

Online Operations

• Explain online index rebuild new functionality
• Describe online table redefinitions
• Explain online analyze validate
• Describe the use of the Server Parameter File (SPFILE)

Segment Management (Part I)

• Use the automatic global index maintenance feature
• Explain the use of external tables
• Use the new LIST partitioning method
• Explain the basics of meta data Application Programming Interface

Segment Management (Part II)

• Explain and use the new Automatic Segment-Space Management functionality
• Create and use bitmap join indexes

Performance Improvements

• Use the indexes monitoring feature
• Describe the cursor sharing enhancements
• Identify cached execution plans
• Gather system statistics

Implementing Oracle Advanced Queuing

• Define the advanced queuing concepts

Using Additional New Features

• Implement reverse key indexes
• Create and use index-organized tables

Introduction to Recovery Manager

• Discuss the benefits of using Recovery Manager
• Identify the types of backups

Enhancements to Networking

• Describe the concept of multiplexing
• Describe the concept of connection pooling

Implementing Password Management

• Implement password aging and expiry

SQL*Plus, PL/SQL, and National Language Support Enhancements

• Describe the use of PL/SQL for: Event Triggers, Autonomous Transactions, Native Dynamic SQL

Database Security

• Implement fine-grained access control

Oracle Server Security

• Explain the new privileged connection options
• Describe the new security features and their application: Secure Application Role, Global Context, Partitioned Fine Grain Access Control, Fine Grained Auditing

General High Availability Technology

• Describe fast-start time-based recovery limit
• Explain the new Oracle Flashback feature
• Describe Resumable Space Allocation
• Describe the new Export/Import features

Real Application Clusters

• Explain Cache Fusion
• Configure a shared<