Oracle Database 12c Administration - Exam Code 1Z0-062

Share this page:

Exam Details

Exam Title:	Oracle Database 12c Administration
Exam Number:	1Z0-062
Exam Price:	₹10,475.00 More on exam pricing
Format:	Multiple Choice

Validated Against: This exam has been validated against Oracle Database 12.1.0.1.0.
Duration:	120 Minutes
Number of Questions:	67
Passing Score:	64%

Course Content / Exam(s)

1. Introduction

Course
Suggested Schedule
Oracle Database Innovation
Enterprise Cloud Computing
Course Examples: HR Sample Schema

2. Exploring Oracle Database Architecture

Oracle Database Server Architecture: Overview
Oracle Database Instance Configurations
Connecting to the Database Instance
Oracle Database Memory Structures
Shared Pool
Database Buffer Cache
Redo Log Buffer
Large Pool
Java Pool
Streams Pool
Program Global Area (PGA)
In-Memory Column Store: Introduction
In-Memory Column Store: Overview
Full Database In-Memory Caching
Process Architecture
Process Structures
Database Writer Process (DBWn)
Log Writer Process (LGWR)
Checkpoint Process (CKPT)
System Monitor Process (SMON)
Process Monitor Process (PMON)
Recoverer Process (RECO)
Listener Registration Process (LREG)
Archiver Processes (ARCn)
Database Storage Architecture
Logical and Physical Database Structures
Segments, Extents, and Blocks
Tablespaces and Data Files
SYSTEM and SYSAUX Tablespaces
Oracle Container Database: Introduction
Multitenant Architecture
Automatic Storage Management
ASM Storage Components
Interacting with an Oracle Database: Memory, Processes, and Storage

3. Oracle Database Management Tools

Oracle Database Management Tools: Introduction
Using SQL*Plus
Calling SQL*Plus from a Shell Script
Calling a SQL Script from SQL*Plus
Oracle SQL Developer: Connections
Oracle SQL Developer: DBA Actions
Oracle Enterprise Manager Database Express Architecture
Configuring Enterprise Manager Database Express
Logging In to Oracle Enterprise Manager Database Express
Using the Database Home Page
Using Enterprise Manager Database Express Menus
Oracle Enterprise Manager Cloud Control Components
Controlling the Enterprise Manager Cloud Control Framework
Starting the Enterprise Manager Cloud Control Framework
Stopping the Enterprise Manager Cloud Control Framework
Types of Enterprise Manager Cloud Control Targets
Enterprise Manager Cloud Control
Using Enterprise Manager Cloud Control

4. Managing the Database Instance

Initialization Parameter Files
Types of Initialization Parameters
Initialization Parameters: Examples
Using SQL*Plus to View Parameters
Changing Initialization Parameter Values
Changing Parameter Values: Examples
Starting Up an Oracle Database Instance: NOMOUNT
Starting Up an Oracle Database Instance: MOUNT
Starting Up an Oracle Database Instance: OPEN
Startup Options: Examples
Shutdown Modes
Shutdown Options
Shutdown Options: Examples
Viewing the Alert Log
Using Trace Files
Administering the DDL Log File
Understanding the Debug Log File
Using Dynamic Performance Views
Dynamic Performance Views: Usage Examples
Dynamic Performance Views: Considerations
Data Dictionary: Overview
Data Dictionary Views
Data Dictionary: Usage Examples

6. Administering User Security

Database User Accounts
Predefined Administrative Accounts
Administrative Privileges
Protecting Privileged Accounts
Authenticating Users
Administrator Authentication
OS Authentication and OS Groups
Managing Users
Creating a User
Unlocking a User Account and Resetting the Password
Privileges
System Privileges
Revoking System Privileges with ADMIN OPTION
Granting Object Privileges
Object Privileges
Revoking Object Privileges with GRANT OPTION
Using Roles to Manage Privileges
Assigning Privileges to Roles and Assigning Roles to Users
Predefined Roles
Creating a Role
Secure Roles
Assigning Roles to Users
Privilege Analysis
Privilege Analysis Flow
Profiles and Users
Implementing Password Security Features
Creating a Password Profile
Supplied Password Verification Functions
Modifications to the Default Profile
Assigning Quotas to Users
Applying the Principle of Least Privilege

7. Managing Database Storage Structures

How Table Data Is Stored
Database Block: Contents
Exploring the Storage Structure
Creating a New Tablespace
Tablespaces Created by Default: Overview
Altering a Tablespace
Adding a Data File to a Tablespace
Making Changes to a Data File
Dropping Tablespaces
Viewing Tablespace Information
Oracle Managed Files (OMF)
Enlarging the Database
Moving or Renaming an Online Data File

8. Managing Space

Space Management: Overview
Block Space Management
Row Chaining and Migration
Free Space Management Within Segments
Types of Segments
Allocating Extents
Understanding Deferred Segment Creation
Viewing Deferred Segment Information
Controlling Deferred Segment Creation
Restrictions and Exceptions
Additional Automatic Functionality
Table Compression: Overview
Compression for Direct-Path Insert Operations
Advanced Row Compression for DML Operations
Specifying Table Compression
Using the Compression Advisor
Using the DBMS_COMPRESSION Package
Proactive Tablespace Monitoring
Thresholds and Resolving Space Problems
Monitoring Tablespace Space Usage
Shrinking Segments
Results of Shrink Operation
Reclaiming Space Within ASSM Segments
Using the Segment Advisor
Automatic Segment Advisor
Shrinking Segments by Using SQL
Shrinking Segments by Using Enterprise Manager
Managing Resumable Space Allocation
Using Resumable Space Allocation
Resuming Suspended Statements
What Operations Are Resumable?

9. Managing Undo Data

Undo Data: Overview
Transactions and Undo Data
Storing Undo Information
Comparing Undo Data and Redo Data
Managing Undo
Configuring Undo Retention
Categories of Undo
Guaranteeing Undo Retention
Changing an Undo Tablespace to a Fixed Size
Temporary Undo: Overview
Temporary Undo: Benefits
Enabling Temporary Undo
Monitoring Temporary Undo
Viewing Undo Information
Viewing Undo Activity
Using the Undo Advisor

10. Managing Data Concurrency

11. Implementing Oracle Database Auditing

Database Security
Monitoring for Compliance
Types of Activities to be Audited
Mandatorily Audited Activities
Understanding Auditing Implementation
Administering the Roles Required for Auditing
Database Auditing: Overview
Understanding the Audit Architecture
Enabling Unified Auditing
Configuring Auditing
Using Enterprise Manager Cloud Control
Creating a Unified Audit Policy
Creating an Audit Policy: System-Wide Audit Options
Creating an Audit Policy: Object-Specific Actions
Creating an Audit Policy: Specifying Conditions
Enabling and Disabling Audit Policies
Altering a Unified Audit Policy
Viewing Audit Policy Information
Setting the Write Mode for Audit Trail Records
Value-Based Auditing
Fine-Grained Auditing
FGA Policy
Audited DML Statement: Considerations
FGA Guidelines
Archiving and Purging the Audit Trail
Purging Audit Trail Records

12. Backup and Recovery: Concepts

DBA Responsibilities
Categories of Failure
Statement Failure
User Process Failure
Network Failure
User Error
Flashback Technology
Instance Failure
Understanding Instance Recovery: Checkpoint (CKPT) Process
Understanding Instance Recovery: Redo Log Files and Log Writer
Understanding Instance Recovery
Phases of Instance Recovery
Tuning Instance Recovery
Using the MTTR Advisor
Media Failure
Comparing Complete and Incomplete Recovery
Complete Recovery Process
Point-in-Time Recovery Process
Oracle Data Protection Solutions

13. Backup and Recovery: Configuration

Configuring for Recoverability
Configuring the Fast Recovery Area
Monitoring the Fast Recovery Area
Multiplexing Control Files
Redo Log Files
Multiplexing the Redo Log
Creating Archived Redo Log Files
Archiver (ARCn) Process
Archived Redo Log Files: Naming and Destinations
Configuring ARCHIVELOG Mode

14. Performing Database Backups

Backup Solutions: Overview
Oracle Secure Backup
User-Managed Backup
Understanding Backup Terminology
Understanding Types of Backups
RMAN Backup Types
Using Recovery Manager (RMAN)
Configuring Backup Settings
Oracle-Suggested Backup
Selecting a Backup Strategy
Backing Up the Control File to a Trace File
Managing Backups
Using RMAN Commands to Create Backups

15. Performing Database Recovery

Opening a Database
Keeping a Database Open
Data Recovery Advisor
Loss of a Control File
Loss of a Redo Log File
Loss of a Data File in NOARCHIVELOG Mode
Loss of a Noncritical Data File in ARCHIVELOG Mode
Loss of a System-Critical Data File in ARCHIVELOG Mode

16. Moving Data

Moving Data: General Architecture
Oracle Data Pump: Overview
Oracle Data Pump: Benefits
Directory Objects for Data Pump
Creating Directory Objects
Data Pump Export and Import Clients: Overview
Data Pump Utility: Interfaces and Modes
Performing a Data Pump Export by Using Enterprise Manager Cloud Control
Performing a Data Pump Import
Data Pump Import: Transformations
Using Enterprise Manager Cloud Control to Monitor Data Pump Jobs
SQL*Loader: Overview
SQL*Loader Control File
Loading Methods
Loading Data by Using Enterprise Manager Cloud Control
SQL*Loader Express Mode
External Tables
External Table: Benefits
Defining an External Tables with ORACLE_LOADER
External Table Population with ORACLE_DATAPUMP
Using External Tables
Data Dictionary

17. Database Maintenance

Database Maintenance
Viewing the Alert History
Terminology
Automatic Workload Repository (AWR): Overview
AWR Infrastructure
Automatic Workload Repository
AWR Baselines
Accessing the AWR Page
Managing the AWR
Statistic Levels
Automatic Database Diagnostic Monitor (ADDM)
ADDM Findings in Enterprise Manager Cloud Control
ADDM Findings in Enterprise Manager Database Express
Advisory Framework
Viewing the Advisor Central Page in Enterprise Manager Cloud Control
Using Packages to Invoke the Advisors
Automated Maintenance Tasks
Automated Maintenance Tasks Configuration
Server-Generated Alerts
Setting Metrics Thresholds
Reacting to Alerts
Alert Types and Clearing Alerts

18. Managing Performance

Performance Monitoring
Tuning Activities
Performance Planning
Instance Tuning
Performance Tuning Methodology
Performance Tuning Data
Using the Enterprise Manager Database Express Performance Hub Page
Using the Enterprise Manager Cloud Control Performance Home Page
Monitoring Session Performance
Performance Monitoring: Top Sessions
Displaying Session-Related Statistics
Performance Monitoring: Top Services
Displaying Service-Related Statistics
Viewing Wait Events
Oracle Wait Events
Memory Management: Overview
Managing Memory Components
Efficient Memory Usage: Guidelines
Automatic Memory Management: Overview
Oracle Database Memory Parameters
Enabling Automatic Memory Management (AMM) by Using Enterprise Manager
Cloud Control
Monitoring Automatic Memory Management
Automatic Shared Memory Management: Overview
Enabling Automatic Shared Memory Management (ASMM)
Understanding Automatic Shared Memory Management
Automatic Shared Memory Advisor
Enabling Automatic Shared Memory Management
Disabling Automatic Shared Memory Management
Using V$PARAMETER to View Memory Component Sizes
Managing the Program Global Area (PGA)
Dynamic Performance Statistics
Troubleshooting and Tuning Views

19. Managing Performance: SQL Tuning

SQL Tuning
Oracle Optimizer: Overview
Optimizer Statistics
Optimizer Statistics Collection
Using the Optimizer Statistics Console
Setting Global Preferences by Using Enterprise Manager Cloud Control
Gathering Optimizer Statistics Manually
Setting Optimizer Statistics Preferences
Concurrent Statistics Gathering
Viewing Statistics Information
SQL Plan Directives
Adaptive Execution Plans
Using the SQL Advisors
Automatic SQL Tuning Results
Implementing Automatic Tuning Recommendations
SQL Tuning Advisor: Overview
Using the SQL Tuning Advisor
SQL Tuning Advisor Recommendations
Duplicate SQL
SQL Access Advisor: Overview
Using the SQL Access Advisor
Workload Source
Recommendation Options
Reviewing Recommendations
SQL Performance Analyzer: Overview
SQL Performance Analyzer: Use Cases
Using SQL Performance Analyzer

20. Using Database Resource Manager

Database Resource Manager: Overview
Database Resource Manager: Concepts
Using the Resource Manager
Default Plan for Maintenance Windows
Default Plan
Creating a Simple Resource Plan
Creating a Complex Resource Plan
Specifying Resource Plan Directives
Resource Allocation Methods for Resource Plans
Comparison of EMPHASIS and RATIO
Active Session Pool Mechanism
Specifying Thresholds
Setting Idle Timeouts
Limiting CPU Utilization at the Database Level
Limiting CPU Utilization at the Server Level: Instance Caging
Instance Caging: Examples
Monitoring Instance Caging
Runaway Queries and Resource Manager
Resource Consumer Group Mapping
Activating a Resource Plan
Database Resource Manager Information
Viewing Resource Manager Statistics
Monitoring the Resource Manager

21. Using Oracle Scheduler to Automate Tasks

Simplifying Management Tasks
Understanding a Simple Job
Oracle Scheduler Core Components
Using Oracle Scheduler
Persistent Lightweight Jobs
Using a Time-Based or Event-Based Schedule
Creating a Time-Based Job
Creating an Event-Based Schedule
Creating Event-Based Schedules by Using Enterprise Manager
Cloud Control
Creating an Event-Based Job
Event-Based Scheduling
Creating Complex Schedules
Using Email Notification
Adding and Removing Email Notifications
Creating Job Chains
Example of a Chain
Using Advanced Scheduler Features
Job Classes
Windows
Prioritizing Jobs Within a Window
Creating a Job Array
Creating a File Watcher and an Event-Based Job
Enabling File Arrival Events from Remote Systems
Scheduling Remote Database Jobs
Creating Remote Database Jobs
Scheduling Multiple Destination Jobs
Viewing Scheduler Meta Data

22. Oracle Database Cloud Service: Overview

Database as a Service Architecture
Database as a Service: Features and Tooling
Software Editions: Included Database Options and Management Packs
Accessing the Oracle Database Cloud Service Console
Automated Database Provisioning
Accessing Tools from the Service Console
Managing the Compute Node Associated With a Database Deployment
Managing Network Access to Database as a Service
Enabling Access to a Compute Node Port
Scaling a Database Deployment
Patching Database as a Service
Using the Oracle Database Cloud Service Console to Manage Patches