Syllabus

About - Syllabus

Syllabus

Syllabus - New Features of Oracle Database 12c

Chapter 1 - Enterprise Manager and Other Tools

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

Chapter 2 - Basics of Multitenant Container Database (CDB)

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

Chapter 3 - Configuring and Creating CDBs and PDBs

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

Chapter 4 - 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

Chapter 5 - Managing Tablespaces, Common and Local Users, Privileges and Roles

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

Chapter 6 - 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

Chapter 7 - Information Lifecycle Management and Storage Enhancements

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

Chapter 8 - In-Database Archiving and Valid-Time Temporal

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

Chapter 9 - Auditing

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

Chapter 10 - Privileges

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

Chapter 11 - Oracle Data Redaction

  • Use and manage Oracle Data Redaction policies

Chapter 12 - RMAN and Flashback Data Archive

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

Chapter 13 - Real-Time Database Operation Monitoring

  • Implement real-time database operation monitoring

Chapter 14 - SQL Tuning

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

Chapter 15 - 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

Chapter 16 - Resource Manager and Other Performance Enhancements

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

Chapter 17 - Index and Table Enhancements

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

Chapter 18 - ADR and Network Enhancements

  • Explain ADR enhancements

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

  • Use Oracle Data Pump enhancements
  • Use SQL*Loader and External table enhancements Chapter 20 - Partitioning Enhancements
  • Explain Partitioning enhancements
  • Explain Index enhancements for partitioned tables

Chapter 21 - SQL Enhancements

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

Chapter 22 - Key DBA Skills

Chapter 23 - 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
  1. Relocate SYSAUX occupants

        2.Create a default permanent tablespace

        3.Use the Redo Logfile Size Advisor

        4.Use Secure File LOBs

        5.Use Direct NFS

Chapter 24 - 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
  • Storage
  • Manage database structures
  • Administer ASM
  • Manage ASM disks and diskgroups
  • Manage ASM instance
  • Manage VLDB
  • Implement Space Management

Chapter 25 - Security

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

© 2015 by Learncertification All Rights Reserved. The certification names are the trademarks of their respective owners. Terms & Privacy Policy