About Exam
Exam number/code:
1Z0-035Exam name:
Oracle 7.3Exam 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<