1Z0-053 Practice Exam: Oracle Database 11g Administration II
3.7 (4 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
24 students enrolled

1Z0-053 Practice Exam: Oracle Database 11g Administration II

More than 200+ practice questions for Oracle 1Z0-053 exam to attain Oracle Certified Profession (OCP) certification
3.7 (4 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
24 students enrolled
Created by Arun Kumar
Last updated 1/2018
English
1Z0-053 Practice Exam: Oracle Database 11g Administration II
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 Practice Tests
  • Full lifetime access
  • Access on mobile
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
Requirements
  • Oracle Database 11g Database Administration
  • Working knowledge of SQL and how to use PL/SQL packages
  • Must have OCA certification completed
Included in This Course
+ Practice Tests
2 Tests 126 questions

100 Questions

Test Practice 1
100 questions

100 Questions

Test Practice 2
26 questions
Description

Passing Oracle 1Z0-053 exam is required to earn Oracle Database 11g Administrator Certified Professional. 

Exam Details:

  • Duration: 120 Minutes
  • No. of questions: 78
  • Passing score: 66%
  • Format: Multiple Choice


Exam Topics:

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

Configuring for Recoverability 

  • Configure multiple archive log file destinations to increase availability
  • Define, apply and use a retention policy 
  • Configure the Flash Recovery Area 
  • Use Flash 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 

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 

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 

Using RMAN to Duplicate a Database

  • Creating a duplicate database
  • Using a duplicate database 

Performing Tablespace Point-in-Time Recovery

  • Identify the situations that require TSPITR 
  • Perform automated TSPITR

Monitoring and Tuning RMAN

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

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 

Diagnosing the Database

  • Set up Automatic Diagnostic Repository
  • Using Support Workbench  
  • Perform Block Media Recovery 

Managing Memory

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

Managing Database Performance

  • Use the SQL Tuning Advisor
  • Use the SQL Access Advisor to tune a workload  
  • Understand Database Replay 

Space Management

  • Manage resumable space allocation
  • Describe the concepts of transportable tablespaces and databases  
  • Reclaim wasted space from tables and indexes by using the segment shrink functionality 

Managing Resources

  • Understand the database resource manager
  • Create and use Database Resource Manager Components

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 

Administering the Scheduler

  • Create Windows and Job Classes
  • Use advanced Scheduler concepts to prioritize jobs
Who this course is for:
  • Database Administrators who are appearing for 1Z0-053 certification exam
  • Support Engineer / Technical Consultant / Administrator
  • Anyone who is planning to attain OCP certification