Create Account

Oracle 1Z0-034

Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP

Free Questions in OTE format

File Date Q&A Votes Size  
Oracle.1Z0-034.v2018-11-15.149q.ote 2018-11-15 149 0/0 4.20 Mb
Oracle.1Z0-034.v2016-02-08.148q.ote 2016-02-08 148 0/0 4.15 Mb

Notification about new Oracle 1Z0-034 files

Subscribe to Oracle 1Z0-034 dump here, you will be informed about new OTE files.

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


  • 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

© 2006 ExamBrainDumps