Upgrade to Oracle Database 12c
цена: 13000 руб.
Для юридических лиц: 13000 руб.

Чтобы забронировать место авторизуйтесь на сайте или пройдите регистрацию.

Upgrade to Oracle Database 12c

Код: 1Z0-060
продолжительность: 120 минут
Язык обучения: English
Тестовая система: Pearson VUE
Филиал: Москва


Exam Topics:

Section 1 - New Features of Oracle Database 12c

Enterprise Manager and Other Tools

  • Use EM Express
  • Use OUI, DBCA for installation and configuration

Basics of Multitenant Container Database (CDB)

  • Identify the benefits of the multitenant container database
  • Explain root and multitenant architecture

Configuring and Creating CDBs and PDBs

  • Create and configure a CDB
  • Create and configure a PDB
  • Migrate a non-CDB to a PDB database

Managing CDBs and PDBs

  • Establish connection to a CDB/PDB
  • Start up and shut down a CDB/PDB
  • Change instance parameters for a CDB/PDB

Managing Tablespaces, Common and Local Users, Privileges and Roles

  • Manage tablespaces in a CDB/PDB
  • Manage users and privileges for CDB/PDB

Backup, Recovery and Flashback for a CDB/PDB

  • Perform backup of CDB and PDB
  • Perform recovery of CDB and PDB
  • Perform Flashback for a CDB

Information Lifecycle Management and Storage Enhancements

  • Use ILM features
  • Perform tracking and automated data placement
  • Move a data file online

In-Database Archiving and Valid-Time Temporal

  • Differentiate between ILM and Valid-Time Temporal
  • Set and use Valid Time Temporal
  • Use In-Database archiving


  • Enable and configure Unified Audit Data Trail
  • Create and enable audit policies


  • Use administrative privileges
  • Create, enable and use privilege analysis

Oracle Data Redaction

  • Use and manage Oracle Data Redaction policies

RMAN and Flashback Data Archive

  • Use RMAN enhancements
  • Implement the new features in Flashback Data Archive

Real-Time Database Operation Monitoring

  • Implement real-time database operation monitoring

SQL Tuning

  • Use Adaptive Execution Plans
  • Use enhanced features of statistics gathering
  • Use Adaptive SQL Plan Management

Emergency Monitoring, Real-Time ADDM, Compare Period ADDM, and Active Session History (ASH) Analytics

  • Perform emergency monitoring and real-time ADDM
  • Generate ADDM Compare Period
  • Diagnose performance issues using ASH enhancements

Resource Manager and Other Performance Enhancements

  • Use Resource Manager for a CDB and PDB
  • Explain Multi-process Multi-threaded Oracle architecture
  • Use Flash Cache

Index and Table Enhancements

  • Use Index enhancements
  • Use Table enhancements
  • Use Online operation enhancements

ADR and Network Enhancements

  • Explain ADR enhancements

Oracle Data Pump, SQL*Loader, External Tables and Online Operations Enhancements

  • Use Oracle Data Pump enhancements
  • Use SQL*Loader and External table enhancements

Partitioning Enhancements

  • Explain Partitioning enhancements
  • Explain Index enhancements for partitioned tables

SQL Enhancements

  • Use Oracle Database Migration Assistant for Unicode
  • Use Row limiting clause, and secure file LOBs enhancements
  • Configure extended datatypes

Section 2 - Key DBA Skills

Core Administration

  • Explain the fundamentals of DB architecture
  • Install and configure a database
  • Configure server and client network for a database
  • Monitor database alerts
  • Perform daily administration tasks
  • Apply and review patches
  • Back up and recover the database
  • Troubleshoot network and database issues
  • Detect and repair data failures with Data Recovery Advisor
  • Implement Flashback Technology
  • Load and Unload Data
  • Miscellaneous
  • Relocate SYSAUX occupants
  • Create a default permanent tablespace
  • Use the Redo Logfile Size Advisor
  • Use Secure File LOBs
  • Use Direct NFS

Performance Management

  • Design the database layout for optimal performance
  • Monitor performace
  • Manage memory
  • Analyze and identify performance issues
  • Perform real application testing
  • Use Resource Manager to manage resources
  • Implement Application Tuning


  • Manage database structures
  • Administer ASM
  • Manage ASM disks and diskgroups
  • Manage ASM instance
  • Manage VLDB
  • Implement Space Management


  • Develop and implement a security policy
  • Configure and manage auditing
  • Create the password file
  • Implement column and tablespace encryption

По вашему запросу ничего не найдено. Попробуйте изменить условия поиска.

Оставить отзыв
Об этом экзамене отзывов пока нет. Будьте первым.