Oracle 1Z0-042 Oracle Database 10g: Administration I
About Exam
Exam number/code: 1Z0-042Exam name: Oracle Database 10g: Administration I
Exam no. of questions: 84 Questions
Duration: 120 minutes
Passing score: 68%
Question types: Multiple choice questions (MCQ's), Multiple choice single answer, Multiple choice multiple answer, Drag and drop & Simulations (optional)
- Architecture
- Installing the Oracle Database Software
- Creating an Oracle Database
- Managing the Oracle Instance
- Managing Database Storage Structures
- Administering User Security
- Managing Schema Objects
- Managing Data and Concurrency
- Managing Undo Data
- Implementing Oracle Database Security
- Configuring the Oracle Network Environment
- Proactive Maintenance
- Backup and Recovery Concepts
- Performance Management
- Performing Database Backup
- Performing Database Recovery
- Performing Flashback
- Moving Data
Exam Objectives
Architecture- Outline the Oracle Architecture and its main Components
- Explain the Oracle instance architecture
- Identify common database administrative tools available to a DBA (1)
- Use optimal flexible architecture
- Install software with Oracle Universal Installer
- Identify and configure commonly used environment variables
- Use Installer Log (2)
- Use DBCA to Create a database
- Use DBCA to Delete a database
- Use DBCA to manage templates
- Use Enterprise Manager
- Use SQL*Plus and iSQL*Plus to access the Oracle Database
- Modify database initialization parameters
- Describe the stages of database startup
- Describe the database shutdown options
- View the database alert log
- Use dynamic performance views (3)
- Describe how table row data is stored in blocks (4)
- Define the purpose of tablespaces and data files
- Explain space management in tablespaces
- Create tablespaces
- Manage tablespaces: alter, drop, take offline, put online, add data files, make read-only or read-write, generate DDL
- Obtain tablespace information
- Explain key features and benefits of ASM (5)
- Create and manage database user accounts
- Create and manage roles
- Grant and revoke privileges
- Create and manage profiles (6)
- Create and modify tables
- Define constraints and states of constraints (7)
- Dropping and truncating tables (7)
- Create and use B-Tree and Bitmap indexes (8)
- Create Views
- Create sequences
- Use data dictionary
- Manipulate data through the use of SQL
- Identify and administer PL/SQL objects
- Describe triggers and triggering events
- Define levels of locking
- List possible causes of lock conflict
- Monitor and resolve lock conflicts
- Monitor and administer undo
- Configure undo retention
- Describe the relationship between undo and transactions
- Size the undo tablespace
- Apply the principle of least privilege
- Audit database activity
- Implement Fine-Grained Auditing
- Use Database Control to Create additional listeners
- Use Database Control to Create Oracle Net service aliases
- Control Oracle Net Listeners
- Identify when to use shared servers versus dedicated servers
- Gather optimizer statistics
- Manage the Automatic Workload Repository
- Use the Automatic Database Diagnostic Monitor (ADDM)
- Set warning and critical alert thresholds
- React to performance issues
- Use enterprise manager to view performance (9)
- Tune SQL by using SQL tuning advisor (10)
- Tune SQL by using SQL access advisor
- Use automatic shared memory management (11)
- Use the memory advisor to size memory buffer (11)
- Descri
Oracle Database 10g: Administration I Product(s)
Included products in 1Z0-042 discount pack
Actual Tests Cram 1Z0-042 Practice Questions and AnswersWritten with the non-certified professional in mind
Written in plain English
Like actual certification exams; our product is in multiple-choice questions (MCQs)
in PDF Format
These questions and answers are backed by our GUARANTEE
Comprehensive questions with complete details (if available)
Format: PDF
Included in Pack:

Actual Tests Cram 1Z0-042 Self Test SoftwareInteractive representations in exhibits
Supports Windows Vista, XP, NT, ME, 98
Download and practice offline
2 types of questions
Accurate and updated Actual Tests Cram training tool
Free updates downloadable
Format: Interactive Software
Included in Pack:

Actual Tests Cram 1Z0-042 Online Practice Testing EngineWritten in simple English
Best training and practice tool
Q&A updated regularly
free updates
Interactive representations in exhibits and graphical images
100% guaranteed success
Format: Online Software
Included in Pack:

Actual Tests Cram 1Z0-042 EBookVery easy to understand and preparation
Excellent resource to study on Notebook
Portable anywhere
Detail explanation of every topic
in PDF format
Format: PDF
Included in Pack:

Special Discount Package Deal
![]() |
|
||||||||
| Home / Free Downloads / Guarantee / Testimonials / Premium Packages / Shopping Cart | |||||||||
|
|||||||||





