PROGRAM OF 082 72 questions 60% for pass

1- Understanding Oracle Database Architecture - Oracle Database: Administration Workshop

 Understanding Oracle Database Instance Configurations

 Understanding Oracle Database Memory and Process Structures

 Understanding Logical and Physical Database Structures

 Understanding Oracle Database Server Architecture

2- Managing Database Instances - Oracle Database: Administration Workshop

 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

3- Managing Users, Roles and Privileges - Oracle Database: Administration Workshop

 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

4- Managing Storage - Oracle Database: Administration Workshop

 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

6- Accessing an Oracle Database with Oracle supplied Tools - Oracle Database: Administration
Workshop

 Using the Database Configuration Assistant (DBCA)

 Using Oracle Enterprise Manager Cloud Control

 Using racle enterprise Manager Database Express

 Using SQL Developer

 Using SQL Plus

7- Configuring Oracle Net Services - Oracle Database: Administration Workshop

 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

8- Managing Tablespaces and Datafiles - Oracle Database: Administration Workshop

 Viewing Tablespace Information

 Creating, Altering and Dropping Tablespaces

 Managing Table Data Storage

 Implementing Oracle Managed Files

 Moving and Renaming Online Data Files

9- Managing Undo - Oracle Database: Administration Workshop

 Understanding Transactions and Undo Data

 Storing Undo Information

 Configuring Undo Rentention

 Comparing Undo Data and Redo Data

10-Restricting and Sorting Data - Oracle Database: Introduction to SQL

 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

11-Using Conversion Functions and Conditional Expressions - Oracle Database: Introduction to

 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

12-Displaying Data from Multiple Tables Using Joins - Oracle Database: Introduction to SQL

 Using Self-joins

 Using Various Types of Joins

 Using Non equijoins

 Using OUTER joins

13-Using SET Operators - Oracle Database: Introduction to SQL

 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

14-Understanding Data Definition Language - Oracle Database: Introduction to SQL

 Using Data Definition Language

Managing Views - Oracle Database: Introduction to SQL

 Managing Views

15-Managing Data in Different Time Zones - Oracle Database: Introduction to SQL

 Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP

16-Retrieving Data using the SQL SELECT Statement - Oracle Database: Introduction to SQL

 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

17-Using Single-Row Functions to Customize Output - Oracle Database: Introduction to SQL

 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

18-Reporting Aggregated Data Using Group Functions - Oracle Database: Introduction to SQL

 Restricting Group Results

 Creating Groups of Data

 Using Group Functions

19-Using Subqueries to Solve Queries - Oracle Database: Introduction to SQL

 Using Single Row Subqueries

 Using Multiple Row Subqueries

20-Managing Tables using DML statements - Oracle Database: Introduction to SQL

 Managing Database Transactions

 Using Data Manipulation Language

 Controlling transactions

21-Managing Sequences, Synonyms, Indexes - Oracle Database: Introduction to SQL

 Managing Indexes

 Managing Synonyms

 Managing Sequences
22-Managing Schema Objects - Oracle Database: Introduction to SQL

 Creating and using temporary tables

 Managing constraints