OpenExamsFREE PRACTICE — ANY EXAM

Oracle Database Administration II — Information & Free Practice

100 free questions · Answer explanations · No signup required

Start free practice →

Exam Review

About Oracle Database Administration II

Oracle Database Administration II · US

Key exam facts

Provider
Oracle University; proctored online
Format
Multiple Choice
Exam questions
Total questions: 68.
Time limit
120 Minutes
Passing score
57%

Topics covered

  • Creating CDBs and Regular PDBs

    • Configure and create a CDB
    • Create a new PDB from the CDB seed
    • Explore the structure of PDBs

  • Manage CDBs and PDBs

    • Manage PDB service names and connections
    • Manage startup, shutdown and availability of CDBs and PDBs
    • Change the different modes and settings of PDBs
    • Evaluate the impact of parameter value changes
    • Performance management in CDBs and PDBs
    • Control CDB and PDB resource usage with the Oracle Resource Manager

  • Backup and Duplicate

    • Perform Backup and Recover CDBs and PDBs
    • Duplicate an active PDB
    • Duplicate a Database

  • Upgrading and Transporting CDBs and Regular PDBs

    • Upgrade an Oracle Database
    • Transport Data

  • Manage Application PDBs

    • Explain the purpose of application root and application seed
    • Define and create application PDBs
    • Install, upgrade and Patch applications
    • Create and administer Application PDBS
    • Clone PDBs and Application containers
    • Plug and unplug operations with PDBs and application containers
    • Comparing Local Undo Mode and Shared Undo Mode

  • Manage Security in Multitenant databases

    • Manage Security in Multitenant databases
    • Manage PDB lockdown profiles
    • Audit Users in CDBs and PDBs
    • Manage other types of policies in application containers

  • Recovery and Flashback

    • Restore and Recovering Databases with RMAN
    • Perform CDB and PDB flashback

  • Backup Strategies and Terminology

    • Perform Full and Incremental Backups and Recoveries
    • Compress and Encrypt RMAN Backups
    • Use a media manager
    • Create multi-section backups of very large files
    • Create duplexed backup sets
    • Create archival backups
    • Backup of recovery files
    • Backup non database files
    • Back up ASM meta data

  • Restore and Recovery Concepts

    • Employ the best Oracle Database recovery technology for your failure situation
    • Describe and use Recovery technology for Crash, Complete, and Point-in-time recovry

  • Using Flashback Technologies

    • Configure your Database to support Flashback
    • Perform flashback operations

  • Duplicating a Database

    • Duplicate Databases

  • Configuring and Using RMAN

    • Configure RMAN and the Database for Recoverability
    • Configureand Using an RMAN recovery catalog

  • Diagnosing Failures

    • Detect and repair database and database block corruption
    • Diagnosing Database Issues

  • Performing Recovery

    • Restore and Recovering Databases with RMAN
    • Perform Non RMAN database recovery

  • Transporting Data

    • Transport Data

  • RMAN Troubleshooting and Tuning

    • Interpret the RMAN message output
    • Diagnose RMAN performance issues

  • Install Grid Infrastructure and Oracle Database

    • Install Grid Infrastructure for a Standalone server
    • Install Oracle Database software

  • Patching Grid Infrastructure and Oracle Database

    • Patch Grid Infrastructure and Oracle Database

  • Upgrading to Oracle Grid Infrastructure

    • Upgrade Oracle Grid Infrastructure

  • Oracle Database 18c: New Features

    • Image and RPM based Database Installation

  • Creating an Oracle Database by using DBCA

    • Create, Delete and Configure Databases using DBCA

  • Oracle Restart

    • Configure and use Oracle Restart to manage components

  • Upgrade the Oracle Database

    • Plan for Upgrading an Oracle Database
    • Upgrade an Oracle Database
    • Perform Post-Upgrade tasks

  • Install Grid Infrastructure for a Standalone server

    • Rapid Home Provisioning

  • Using General Overall Database Enhancements

    • Install Oracle Database software
    • Create, Delete and Configure Databases using DBCA
    • Creating CDBs and Regular PDBs
    • Use Miscellaneaous 19c New Features

  • Using Availability Enhancements

    • Use an RMAN recovery catalog
    • Use Flashback Database

  • Using Diagnosibility Enhancements

    • Use new Diagnoseability Features

  • Monitoring and Tuning Database Performance

    • Managing Memory Components
    • Understanding The Automatic Workload Repository (AWR)
    • Understanding The Advisory Framework
    • Monitoring Wait Events, Sessions, and Services
    • Managing Metric Thresholds and Alerts
    • Understanding and Using The Performance Tuning Methodology
    • Performing Performance Planning
    • Understanding The Automatic Database Diagnostic Monitor (ADDM)

  • Tuning SQL Statements

    • Understanding The Oracle Optimizer
    • Using The SQL Tuning Advisor
    • Managing Optimizer Statistics
    • Using The SQL Access Advisor
    • Understanding The SQL Tuning Process

How to prepare

Work through the topics, read the explanation after each answer, and revisit the areas where you miss questions. Use the official outline and reference materials below to guide your study.

These independent practice questions are not actual exam items and do not guarantee a passing result.

Frequently asked questions

What is the exam format?

Multiple Choice

How many questions are on the exam?

Total questions: 68.

How long is the exam?

120 Minutes

What is the passing score?

57%

Official sources and references

  • Oracle MyLearn examination details

    Exam Overview: controlling link to all topics, followed by Prepare for the exam / Review exam topics

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[1]/text():41

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[2]/text():45

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[3]/text():52

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[4]/text():56

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[5]/text():59

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[6]/text():67

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[7]/text():72

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[8]/text():75

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[9]/text():85

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[10]/text():88

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[11]/text():91

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[12]/text():93

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[13]/text():96

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[14]/text():99

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[15]/text():102

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[16]/text():104

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[17]/text():107

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[18]/text():110

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[19]/text():112

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[20]/text():114

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[21]/text():116

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[22]/text():118

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[23]/text():120

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[24]/text():124

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[25]/text():126

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[26]/text():131

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[27]/text():134

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[28]/text():136

  • Oracle MyLearn examination details

    /html[1]/body[1]/app-root[1]/div[3]/oj-module[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/div[1]/oj-module[1]/div[1]/div[1]/div[2]/div[1]/div[2]/div[2]/oj-accordion[1]/oj-collapsible[1]/div[2]/div[1]/div[1]/p[29]/text():145

  • Oracle MyLearn examination details

    Exam facts: Format, Duration, Number of Questions and Passing Score

  • Oracle MyLearn examination details

    After the exam

  • Oracle MyLearn examination details

    Exam facts: Delivery

  • Oracle MyLearn examination details

    Register for online exam

  • Oracle Database Certification Questions Answered

    PDF page 2, FAQ 5: examination order, both columns visually read

  • Oracle MyLearn examination details

    Take recommended training

  • Oracle MyLearn examination details

    Things to do before your exam session: computer and identification

  • Oracle Certification Program Guidelines

    Export Restrictions Policy, first paragraph

  • Oracle Certification Program Guidelines

    Export Restrictions Policy: exceptions and review

  • Oracle Database Administration II official exam details: language options

    試験詳細 / 試験名 and 試験番号

  • Oracle Database Administration II official exam details: language options

    試験詳細 / language-specific purchase instructions immediately after 試験のお申込みと受験

  • Oracle University Japan: exam application and delivery

    オラクル配信試験の予約と受験 / introductory prose

Confirm current exam arrangements with the exam provider.