Oracle 12c Admin Exam Prep Nagpur | Unisoft India
Exam Details
| Exam Title: | Oracle Database 12c Administration |
|---|---|
| Exam Number: | 1Z0-062 |
| Exam Price: | ₹10,475.00 More on exam pricing |
| Format: | Multiple Choice |
| Duration: | 120 Minutes |
|---|---|
| Number of Questions: | 67 |
| Passing Score: | 64% |
| Validated Against: This exam has been validated against Oracle Database 12.1.0.1.0. |
Course Content / Exam(s)
- Course
- Suggested Schedule
- Oracle Database Innovation
- Enterprise Cloud Computing
- Course Examples: HR Sample Schema
- 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
- 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
- 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
- Oracle Net Services: Overview
- Oracle Net Listener: Overview
- Establishing Oracle Network Connections
- Connecting to an Oracle Database
- Name Resolution
- Establishing a Connection
- User Sessions
- Naming Methods
- Easy Connect
- Local Naming
- Directory Naming
- External Naming Method
- Tools for Configuring and Managing Oracle Net Services
- Defining Oracle Net Services Components
- Using Enterprise Manager Cloud Control
- Using Oracle Net Manager
- Using Oracle Net Configuration Assistant
- Using the Listener Control Utility
- Listener Control Utility Syntax
- Advanced Connection Options
- Testing Oracle Net Connectivity
- Comparing Dedicated Server and Shared Server Configurations
- User Sessions: Dedicated Server Process
- User Sessions: Shared Server Processes
- SGA and PGA Usage
- Shared Server Configuration Considerations
- Configuring Communication Between Databases
- Connecting to Another Database
- 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
- 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
- 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?
- 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
- Locks
- Locking Mechanism
- Data Concurrency
- DML Locks
- Enqueue Mechanism
- Lock Conflicts
- Possible Causes of Lock Conflicts
- Detecting Lock Conflicts
- Resolving Lock Conflicts
- Resolving Lock Conflicts by Using SQL
- Deadlocks
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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