Exam Number: 1Z0-034
Exam Title: Upgrade Oracle9i/10g to Oracle Database 11g OCP
Associated Certification Paths Oracle Database 11g Administrator Certified Professional (upgrade)
Duration: 120
Number of Questions: 98
Passing Score: 61%
Validated Against: This exam has been validated against Oracle Database 11g.
Format: Multiple Choice
Complete Recommended Training
Complete the training below to prepare for your exam (optional):
Both courses are recommended to best prepare for this exam.
Oracle Database 11g: Administration Workshop II
Oracle Database 11g: New Features for Administrators DBA
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Exam Preparation Seminars and Packages
Certification Exam Prep Seminar: Oracle Database Administration II
Certification Exam Prep Seminar: Upgrade Oracle Certified Professional (OCP) to Oracle Database 11g
Exam Prep Seminar Package: Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP
Practice Exams
Practice Exams: Oracle Authorized practice exam from Kaplan IT Training: 1Z0-034 - Oracle Upgrade Oracle 9i, 10g OCA to 11g OCP
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
QUESTION 1
Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization
parameter to a nonzero value?
A. The MTTR advisor will be disabled.
B. Automatic checkpoint tuning will be enabled.
C. The value for the LOG_CHECKPIONT_INTERVAL initialization parameter will be override the
value for FAST_START_MTTR_TARGET.
D. The time taken to recover the instance after the crash is always exactly the same as the value
given for the FAST_START_MTTR_TARGET initialization parameter.
Answer: B,C
Explanation:
QUESTION 2
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The
default format of which two data types would be affected by this setting?
A. DATE
B. TIMESTAMP
C. INTERVAL YEAR TO MONTH
D. INTERVAL DAY TO SECOND
E. TIMESTAMP WITH LOCAL TIME ZONE
Answer: B,E
Explanation:
QUESTION 3
Which two statements are true regarding the functionality of the remap command in ASMCMD?
A. It repairs blocks that have read disk I/O errors.
B. It checks whether the alias metadata directory and the file directory are linked correctly.
C. It repairs blocks by always reading them from the mirror copy and writing them to the original
location.
D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate
location on disk if the blocks on the original location cannot be read properly.
Answer: A,D
Explanation:
QUESTION 4
What happens when you run the SQL Tuning Advisor with limited scope?
A. Access path analysis is not performed for SQL statements.
B. SQL structure analysis is not performed for SQL statements.
C. SQL Profile recommendations are not generated for SQL statements.
D. Staleness and absence of statistics are not checked for the objects in the query supplied to the
SQL Tuning Advisor.
Answer: C
Explanation:
QUESTION 5
Which options would you consider while configuring a flash recovery area (fast recovery area in
11g Release 2) for your production database that is running in ARCHIEVELOG mode? (Choose all
that apply.) (Choose all that apply.)
A. setting the FAST_START_MTTR_TARGET to set the mean time to recover
B. setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
C. using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
D. using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the
recovery files created in the flash recovery area.
Answer: C,D
Explanation:
Exam Title: Upgrade Oracle9i/10g to Oracle Database 11g OCP
Associated Certification Paths Oracle Database 11g Administrator Certified Professional (upgrade)
Duration: 120
Number of Questions: 98
Passing Score: 61%
Validated Against: This exam has been validated against Oracle Database 11g.
Format: Multiple Choice
Complete Recommended Training
Complete the training below to prepare for your exam (optional):
Both courses are recommended to best prepare for this exam.
Oracle Database 11g: Administration Workshop II
Oracle Database 11g: New Features for Administrators DBA
Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.
Exam Preparation Seminars and Packages
Certification Exam Prep Seminar: Oracle Database Administration II
Certification Exam Prep Seminar: Upgrade Oracle Certified Professional (OCP) to Oracle Database 11g
Exam Prep Seminar Package: Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP
Practice Exams
Practice Exams: Oracle Authorized practice exam from Kaplan IT Training: 1Z0-034 - Oracle Upgrade Oracle 9i, 10g OCA to 11g OCP
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
QUESTION 1
Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization
parameter to a nonzero value?
A. The MTTR advisor will be disabled.
B. Automatic checkpoint tuning will be enabled.
C. The value for the LOG_CHECKPIONT_INTERVAL initialization parameter will be override the
value for FAST_START_MTTR_TARGET.
D. The time taken to recover the instance after the crash is always exactly the same as the value
given for the FAST_START_MTTR_TARGET initialization parameter.
Answer: B,C
Explanation:
QUESTION 2
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The
default format of which two data types would be affected by this setting?
A. DATE
B. TIMESTAMP
C. INTERVAL YEAR TO MONTH
D. INTERVAL DAY TO SECOND
E. TIMESTAMP WITH LOCAL TIME ZONE
Answer: B,E
Explanation:
QUESTION 3
Which two statements are true regarding the functionality of the remap command in ASMCMD?
A. It repairs blocks that have read disk I/O errors.
B. It checks whether the alias metadata directory and the file directory are linked correctly.
C. It repairs blocks by always reading them from the mirror copy and writing them to the original
location.
D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate
location on disk if the blocks on the original location cannot be read properly.
Answer: A,D
Explanation:
QUESTION 4
What happens when you run the SQL Tuning Advisor with limited scope?
A. Access path analysis is not performed for SQL statements.
B. SQL structure analysis is not performed for SQL statements.
C. SQL Profile recommendations are not generated for SQL statements.
D. Staleness and absence of statistics are not checked for the objects in the query supplied to the
SQL Tuning Advisor.
Answer: C
Explanation:
QUESTION 5
Which options would you consider while configuring a flash recovery area (fast recovery area in
11g Release 2) for your production database that is running in ARCHIEVELOG mode? (Choose all
that apply.) (Choose all that apply.)
A. setting the FAST_START_MTTR_TARGET to set the mean time to recover
B. setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
C. using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
D. using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the
recovery files created in the flash recovery area.
Answer: C,D
Explanation:
