ODA-I Certification Details - Zetlan Technologies

Oracle Database
Administration I

Build a strong foundation in Oracle Database Administration. This Oracle Certified Professional credential, the first of a two-exam path, validates your SQL programming, database administration and network administration skills for managing Oracle Database environments.

Database Architecture Storage & Tablespaces SQL & Joins User & Privilege Management Data Movement Career Defining

Course Content

Complete Database Administration I Curriculum

Click any module to expand and explore the topics covered in detail.

Understanding Oracle Database Architecture

4 Topics

Understanding Oracle Database Instance Configurations

Understanding Oracle Database Memory and Process Structures

Understanding Logical and Physical Database Structures

Understanding Oracle Database Server Architecture

Managing Database Instances

7 Topics

Starting Up Oracle Database Instances

Using Data Dictionary Views

Shutting Down Oracle Database Instances

Using Dynamic Performance Views

Using the Automatic Diagnostic Repository (ADR)

Using the Alert Log and Trace Files

Managing Initialization Parameter Files

Managing Users, Roles and Privileges

5 Topics

Assigning Quotas to Users

Applying the Principal of Least Privilege

Creating and Assigning Profiles

Administering User Authentication Methods

Managing Oracle Database Users, Privileges, and Roles

Managing Storage

8 Topics

Managing Resumable Space Allocation

Shrinking Segments

Deferring Segment Creation

Using Space-Saving Features

Deploying Oracle Database Space Management Features

Managing Different Types of Segments

Using Table and Row Compression

Understanding Block Space Management

Moving Data

3 Topics

Using External Tables

Using Oracle Data Pump

Using SQL*Loader

Accessing an Oracle Database with Oracle supplied Tools

5 Topics

Using the Database Configuration Assistant (DBCA)

Using Oracle Enterprise Manager Cloud Control

Using Oracle Enterprise Manager Database Express

Using SQL Developer

Using SQL Plus

Configuring Oracle Net Services

6 Topics

Using Oracle Net Services Administration Tools

Configuring Communication Between Database Instances

Configuring the Oracle Net Listener

Connecting to an Oracle Database Instance

Comparing Dedicated and Shared Server Configurations

Administering Naming Methods

Managing Tablespaces and Datafiles

5 Topics

Viewing Tablespace Information

Creating, Altering and Dropping Tablespaces

Managing Table Data Storage

Implementing Oracle Managed Files

Moving and Renaming Online Data Files

Managing Undo

5 Topics

Understanding Transactions and Undo Data

Storing Undo Information

Configuring Undo Retention

Comparing Undo Data and Redo Data

Understanding Temporary Undo

Restricting and Sorting Data

4 Topics

Applying Rules of precedence for operators in an expression

Limiting Rows Returned in a SQL Statement

Using Substitution Variables

Using the DEFINE and VERIFY commands

Using Conversion Functions and Conditional Expressions

4 Topics

Applying NVL, NULLIF, COALESCE functions

Understanding implicit and explicit data type conversion

Using TO_CHAR, TO_NUMBER, TO_DATE conversion functions

Nesting multiple functions

Displaying Data from Multiple Tables Using Joins

4 Topics

Using Self-joins

Using Various Types of Joins

Using Non equijoins

Using OUTER joins

Using SET Operators

5 Topics

Matching the SELECT statements

Using the ORDER BY clause in set operations

Using the INTERSECT operator

Using the MINUS operator

Using the UNION and UNION ALL operators

Understanding Data Definition Language

5 Topics

Using Data Definition Language

Managing Views

Working with CURRENT_DATE, CURRENT_TIMESTAMP, LOCALTIMESTAMP

Working with INTERVAL data types

Silent/Automated Installation

Retrieving Data using the SQL SELECT Statement

5 Topics

Using Column aliases

Using The DESCRIBE command

Using The SQL SELECT statement

Using the concatenation operator, literal character strings, alternative quote operator, and DISTINCT keyword

Using Arithmetic expressions and NULL values in the SELECT statement

Using Single-Row Functions to Customize Output

4 Topics

Manipulating strings with character functions in SELECT and WHERE clauses

Performing arithmetic with date data

Manipulating numbers with the ROUND, TRUNC, and MOD functions

Manipulating dates with date functions

Reporting Aggregated Data Using Group Functions

5 Topics

Restricting Group Results

Creating Groups of Data

Using Group Functions

Using Single Row Subqueries

Using Multiple Row Subqueries

Managing Tables using DML statements

8 Topics

Managing Database Transactions

Using Data Manipulation Language

Controlling transactions

Managing Indexes

Managing Synonyms

Managing Sequences

Creating and using temporary tables

Managing constraints

FAQs

Frequently Asked Questions

Who should take the 1Z0-082 exam?

Anyone starting an Oracle DBA career path, including SQL developers and system administrators moving into database administration roles.

Is this the first or second exam in the OCP path?

1Z0-082 (Database Administration I) is the first exam. Database Administration II (1Z0-083) completes the OCP DBA certification.

Is the 1Z0-082 exam proctored?

Yes. The exam is delivered as a proctored online exam, monitored to validate candidate identity and exam integrity.

What topics carry the most weight in this exam?

Database architecture, storage management, SQL fundamentals, and user/privilege administration are core focus areas across the 18 exam objectives.

Do I need prior SQL experience?

Basic SQL familiarity helps, but the course covers SQL fundamentals including SELECT statements, joins, functions and subqueries from the ground up.

How is the exam scored?

The exam consists of 72 multiple choice questions to be completed in 120 minutes, with a passing score of 60%.

Oracle Database
Administration I

The Gateway Certification for Oracle DBAs

Advance Your Oracle DBA Career

Exam 1Z0-082: Oracle Database Administration I

Complete Database Administration I Curriculum

Frequently Asked Questions

Begin Your Oracle DBA Journey

Oracle DatabaseAdministration I

The Gateway Certification for Oracle DBAs

Advance Your Oracle DBA Career

Exam 1Z0-082: Oracle Database Administration I

Complete Database Administration I Curriculum

Frequently Asked Questions

Begin Your Oracle DBA Journey

Oracle Database
Administration I