Oracle Database Administration I (1Z0-082)

• Understanding Oracle Database Instance Configurations
• Understanding Oracle Database Memory and Process Structures
• Understanding Logical and Physical Database Structures
• Understanding Oracle Database Server Architecture

• 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

• 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 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

Using External Tables

Using Oracle Data Pump

Using SQL*Loader

• Using the Database Configuration Assistant (DBCA)
• Using Oracle Enterprise Manager Cloud Control
• Using racle enterprise Manager Database Express
• Using SQL Developer
• Using SQL Plus

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

Viewing Tablespace Information

Creating, Altering and Dropping Tablespaces

Managing Table Data Storage

Implementing Oracle Managed Files

Moving and Renaming Online Data Files

• Understanding Transactions and Undo Data
• Storing Undo Information
• Configuring Undo Retention
• Comparing Undo Data and Redo Data
• Understanding Temporary Undo

• 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

• Applying the NVL, NULLIF, and COALESCE functions to data
• Understanding implicit and explicit data type conversion
• Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
• Nesting multiple functions

• Using Self-joins
• Using Various Types of Joins
• Using Non equijoins
• Using OUTER joins

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

• Using Data Definition Language 

• Managing Views 

• Working with CURRENT_DATE, CURRENT_TIMESTAMP, and LOCALTIMESTAMP
• Working with INTERVAL data types

• Using Column aliases
• Using The DESCRIBE command
• Using The SQL SELECT statement
• Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
• Using Arithmetic expressions and NULL values in the SELECT statement

• Manipulating strings with character functions in SQL SELECT and WHERE clauses
• Performing arithmetic with date data
• Manipulating numbers with the ROUND, TRUNC and MOD functions
• Manipulating dates with the date function

• Restricting Group Results
• Creating Groups of Data
• Using Group Functions

• Using Single Row Subqueries
• Using Multiple Row Subqueries

• Managing Database Transactions
• Using Data Manipulation Language
• Controlling transactions

• Managing Indexes
• Managing Synonyms
• Managing Sequences

• Creating and using temporary tables
• Managing constraints