Oracle 1Z0-034

Free Questions in OTE format

About Oracle 1Z0-034 dump

Backup and Recovery
Backup and Recovery Concepts

• Identify the types of failure that can occur in an Oracle database
  
• Describe ways to tune instance recovery
  
• Identify the importance of checkpoints, redo log files, and archived log files
  
• Configure ARCHIVELOG mode
  
• Perform backup and recovery in NOARCHIVELOG mode
  

Configuring for Recoverability

• Configure multiple archive log file destinations to increase availability
  
• Define, apply and use a retention policy
  
• Configure Fast Recovery Area
  
• Use the Fast Recovery Area
  

Using the RMAN Recovery Catalog

• Identify situations that require RMAN recovery catalog
  
• Create and configure a recovery catalog
  
• Synchronize the recovery catalog
  
• Create and use RMAN stored scripts
  
• Back up the recovery catalog
  
• Create and use a virtual private catalog
  

Configuring Backup Specifications

• Configure backup settings
  
• Allocate channels to use in backing up
  
• Configure backup optimization
  

Using RMAN to Create Backups

• Create image file backups
  
• Create a whole database backup
  
• Enable fast incremental backup
  
• Create duplex backup and back up backup sets
  
• Create an archival backup for long-term retention
  
• Create a multisection,compressed and encrypted backup
  
• Report on and maintain backups
  

Diagnosing the Database

• Set up Automatic Diagnostic Repository
  
• Detect database corruptions using ANALYZE and DBVERIFY
  
• Detect database corruptions using the dbms_repair package
  
• Implement the DB_BLOCK_CHECKING parameter to detect corruptions
  
• Repair corruptions using RMAN
  

Using RMAN to Perform Recovery

• Perform complete recovery from a critical or noncritical data file loss using RMAN
  
• Perform incomplete recovery using RMAN
  
• Recover using incrementally updated backups
  
• Switch to image copies for fast recovery
  
• Restore a database onto a new host
  
• Recover using a backup control file
  
• Perform Disaster recovery
  

Performing Tablespace Point-in-Time Recovery

• Identify the situations that require TSPITR
  
• Perform automated TSPITR
  

Using Flashback Technology

• Restore dropped tables from the recycle bin
  
• Perform Flashback Query
  
• Use Flashback Transaction
  

Additional Flashback Operations

• Perform Flashback Table operations
  
• Configure, Monitor Flashback Database and Perform Flashback Database operations
  
• Set up and use a Flashback Data Archive
  

Transport Data and Tablespaces

• Describe the concepts of transportable tablespaces and databases
  
• Transport tablespaces across different platforms
  

Using RMAN to Duplicate a Database

• Creating a duplicate database
  
• Using a duplicate database
  

Monitoring and Tuning RMAN

• Monitoring RMAN sessions and jobs
  
• Tuning RMAN
  
• Configure RMAN for Asynchronous I/O
  

Database Architecture and ASM

• Describe Automatic Storage Management (ASM)
  
• Set up initialization parameter files for ASM and database instances
  
• Start up and shut down ASM instances
  
• Administer ASM disk groups
  
• Setup ASM fast mirror resync
  
• Use the md_backup, md_restore, and repair ASMCMD extensions
  

Performing User-Managed Backup and Recovery

• Recover from a lost TEMP file
  
• Recover from a lost redo log group
  
• Recover from the loss of password file
  
• Perform user-managed complete database recovery
  
• Perform user-managed incomplete database recovery
  
• Perform user-managed and server managed backups
  
• Identify the need of backup mode
  
• Back up and recover a control file
  

Database Administration
Installing and Upgrading

• Install Oracle Database 11g
  
• Upgrade your database to Oracle Database 11g
  
• Oracle Direct NFS
  
• Use online patching
  

Memory Management

• Implement Automatic Memory Management
  
• Manually configure SGA parameters
  
• Configure automatic PGA memory management
  

Storage Management

• Create and maintain bigfile tablespaces
  
• Rename tablespaces
  
• Create a default permanent tablespace
  

Space Management

• Manage resumable space allocation
  
• Reclaim wasted space from tables and indexes by using the segment shrink functionality
  
• Rebuild indexes online
  
• Reduce space related error conditions through proactively managing tablespace usage
  
• Use different storage options to improve the performance of queries
  
• Use automatic undo retention tuning and temporary undo
  
• Implement partitioning methods
  

Security

• Configure the password file to use case sensitive passwords
  
• Encrypt a tablespace
  
• Configure fined grained access to network services
  
• Use Secure File LOBS to store documents with Compression, Encryption, De-duplication, Caching
  

Using Globalization Support

• Customize language-dependent behavior for the database and individual sessions
  
• Specify different linguistic sorts for queries
  
• Use datetime datatypes
  
• Query data using non-case-sensitive and accent-insensitive searches
  
• Obtain globalization support configuration information
  

Automating Tasks with the Scheduler

• Create a job, program, and schedule
  
• Use a time-based or event-based schedule for executing Scheduler jobs
  
• Create lightweight jobs
  
• Use job chains to perform a series of related tasks
  
• Create Windows and Job Classes
  
• Use advanced Scheduler concepts to prioritize jobs
  

Loading and Unloading Data

• Explain Data Pump architecture
  
• Monitor a Data Pump job
  
• Use Data Pump export and import
  
• Create external tables for data population
  

Managing Resources

• Configure the Resource Manager
  
• Assign users to Resource Manager groups
  
• Create resource plans within groups
  
• Specify directives for allocating resources to consumer groups
  

Managing Database Performance

• Use the SQL Tuning Advisor
  
• Use the SQL Access Advisor to tune a workload
  
• Use Database Replay
  
• Gather and use optimizer statistics
  
• Use Adaptive Cursor Sharing
  
• Diagnose performance issues using ASH