ClickATest Assessment Services

Only £52.00


Sample reports

Sample certificates

Adobe Reader is required to view these sample reports

Oracle 8.0 Administration Test

Our Oracle 8.0 Administration test measures your knowledge of administering Oracle 8.0 databases. Designed for experienced administrators, this test covers the following topics: Architecture, Backup and Recovery, DBA Basics, Net8, RDBMS, SQL and PL/SQL, and Tuning and Troubleshooting.



Scope of the online Oracle 8.0 Administration Test

Architecture
Background Processes
Buffers
Database Objects
External Structures
Instance
Internal Database Structures
Internal Memory Structures
Redo Log Files
Backup and Recovery
High Availability
Import/Export
Internal Database Structures
Monitoring
Noarchivelog/Archivelog Mode
Physical Backups
Recovery
Recovery Catalog
Recovery Manager
RMAN Usage
Types of Failures
Types of Incomplete Recovery
DBA Basics
Auditing
Constraints
Control File
Data Dictionary
Data Integrity
Database Objects
Distributed Database
DML (Data Manipulation Language)
Index
Locks
Password Management
Privileges
Profiles
Redo Log Files
Rollback Segments
Segments
Table
Tablespace and Data Files
Temporary Segments
Trigger
Users
View
Net8
Names
Net8
Security
SQL*Net
RDBMS
Constraints
Direct-Path Insert
Directories
Index-Organized Tables
Large Objects (LOB)
Net8
New ROWID
Parallel DML
Partitioned Indexes
Partitioned Tables
Replication
Unrecoverable DML
User Accounts
SQL and PL/SQL
Exceptions
Explicit Cursor Attributes
Packages
Predefined Exceptions
Procedures and Functions
SQL
SQL Cursor Attributes
SQL Plus
SQL*Loader
Tuning and Troubleshooting
Analyzing Indexes
Analyzing Tables
Blocks
Buffer Cache
Contention
File I/O
Latch Contention
Latch/Lock Contention
Lock Contention
OEM
Optimizer
Rollback Segments
Shared Pool
Sorts
Statistics
Tools

Duration

40 minutes.

Assessment Method of Questions

Multiple choice questions

Each question has between 2 and 8 options out of which 1 or more may be correct.

More links

Related Professions

Database Administrator

Keywords

oracle 8.0 administration test, oracle 8.0 administration test online