Oracle OCA Exam 1Z0-052
Database Architecture
Architectural Components of the Oracle Database
Memory Structures
Server Processes and Background Processes
Logical and Physical Storage Structures
Module Summary
Review Quiz
Installing the Oracle Software
Database Administrator Tasks and Tools
Planning a Oracle Database Installation
Using Optimal Flexible Architecture
Installing the Oracle Software using OUI
Module Summary
Review Quiz
Creating an Oracle Database
Planning for Database Creation
Configuring the Listener
Creating a Database
Module Summary
Review Quiz
The Oracle Instance
Starting and Stopping the Oracle Database
Using the Oracle Enterprise Manager
Access a Database with SQL*Plus
Modify Database Initialization Parameters
Database Startup
Database Shutdown
Viewing the Alert Log and Dynamic Performance Views
Module Summary
Review Quiz
Oracle Network Environment
Creating and Configuring Additional Listeners
Creating Oracle Net Service Aliases
When to Use Shared and Dedicated Servers
Module Summary
Review Quiz
Database Storage Structures
Describe Table Row Data and Define Tablespaces
Creating and Managing Tablespaces
Automatic Storage Management
Module Summary
Review Quiz
User Security
Create and Manage User Accounts
Grant and Revoke Privileges
Create and Manage Roles
Create and Manage Profiles
Module Summary
Review Quiz
Schema Objects
Defining Schema Objects and Data Types
Creating and Modifying Tables
Defining Constraints
Viewing Columns and Contents of a Table
Creating Indexes
Creating Views
Creating Sequences
Using Temporary Tables
Module Summary
Review Quiz
Data and Concurrency
Managing data Using SQL
Identifying and Administering PL/SQL Objects
Monitoring and Resolving Locking Conflicts
Module Summary
Review Quiz
Undo Data
Implementing Undo Data
Working with Undo Data
Module Summary
Review Quiz
Security
DBA Security and Privileges
Enabling Auditing
Audit Options and Information
Fine Grained Auditing
Auditing the DBA and Maintaining the Audit Trail
Module Summary
Review Quiz
Maintenance
Managing Optimizer Statistics
Managing Automatic Workload Repository
Using the Automatic Database Diagnostic Monitor
Setting Alerts and Thresholds
Module Summary
Review Quiz
Oracle Performance
Performance Monitoring with the Enterprise Manager
Using Automatic Memory Management
Viewing Performance Related Dynamic Views
Troubleshooting invalid and Unusable Objects
Module Summary
Review Quiz
Backup and Recovery
Types of Database Failure
Checkpoints, Redo Log Files, and Archive Log Files
Instance Recovery
Configuring for Recoverability
Configuring Archive Log Mode
Module Summary
Review Quiz
Database Backups
Backup Solutions Overview
Configuring Backup Settings
Scheduling Backups
Backing up Control Files to a Trace File
Managing Backups and the Flash Recovery Area
Using the RMAN Command Line
Module Summary
Review Quiz
Recovery
Recovering From a Lost Control File
Recovering Redo Log Files
Recovering Non Critical and Critical Data Files
Using the Data Recovery Advisor
Module Summary
Review Quiz
Moving Data
Moving Data and Creating Directory Objects
Loading Data with the SQL Loader
Creating and Reading External Tables
Using Oracle Data Pump Export and Import
Data Pump Performance and Monitoring
Module Summary
Review Quiz
Database Maintenance
Using the Enterprise Manager Support Workbench
Metalink Integration and Managing Patches
Module Summary
Review Quiz
Course Review
Oracle Database/ SQL Expert: Exam 1Z0-047
Introduction to Oracle SQL
Relational Database Systems
Examining SQL
SQL Developer and SQL Plus
Examining the Database and Schema
Module Summary
Review Quiz
Select Statements
Basic Select Statements
Selecting Columns and Using Arithmetic Operators
Operator Precedence
Concatenation Operator
Displaying the Table Structure
Module Summary
Review Quiz
Where and Order By Clauses
Implementing the Where Clause
Comparison Operators
Logical Operators
Rules of Precedence
Substitution Variables
Module Summary
Review Quiz
Single Row Functions
Types of Single Row Functions
Working with Dates
Module Summary
Review Quiz
Group Functions
Types of Group Functions
Creating Groups of Data
Multi Column Grouping
Module Summary
Review Quiz
Joins
Natural Joins
Nonequijoins and Outer Joins
Cartesian Joins
Module Summary
Review Quiz
Sub-Queries
Single Row Subqueries
Multiple Row Subqueries
Null Values
Module Summary
Review Quiz
Set Operators
Union and Union All Operators
Intersect and Minus Operators
Select Statements and the Order By Clause
Module Summary
Review Quiz