Oracle Database 12c: Mastering Multitenant Architecture Exam 1Z0-063
Exam Details
| Duration: | 120 minutes |
|---|---|
| Number of Questions: | 80 |
| Passing Score: | 60% View passing score policy |
| Validated Against: | This exam has been validated against Oracle Database 12.1.0.1.0. |
| Format: | Multiple Choice |
| Exam Price: | ₹10,265.00 More on exam pricing |
Course Content / Exam(s)
- Course Structure
- Suggested Schedule
- Enterprise Manager Cloud Control and Other Tools
- Target Discovery: Multitenant Container Database
- Enterprise Manager Cloud Control
- Enterprise Manager Database Express
- Configuring Enterprise Manager Database Express
- Database Configuration Assistant
- SQL*Plus
- Oracle SQL Developer: Connections
- Oracle SQL Developer: DBA Tasks
- Course Structure
- Challenges
- Non-CDB Architecture
- New Multitenant Architecture: Benefits
- Other Benefits of Multitenant Architecture
- Configurations
- Oracle Container Database
- A Pristine Installation
- User Data Is Added
- Separating SYSTEM and User Data
- SYSTEM Objects in the USER Container
- Naming the Containers
- Provisioning a Pluggable Database
- Interacting Within Multitenant Container Database
- Multitenant Container Database Architecture
- Containers
- Questions: root Versus PDBs
- Questions: PDBs Versus root
- Terminology
- Common and Local Users
- Common and Local Privileges and Roles
- Shared and Non-shared Objects
- Data Dictionary Views
- Impacts
- Multitenant Architecture General Architecture Poster
- Course Structure
- Goals
- Tools
- Steps to Create a Multitenant Container Database
- Create a Multitenant Container Database: Using SQL*Plus
- Create a Multitenant Container Database: Using DBCA
- New Clause: SEED FILE_NAME_CONVERT
- New Clause : ENABLE PLUGGABLE DATABASE
- After CDB Creation: What’s New in CDB >
- Data Dictionary Views: DBA_xxx
- Data Dictionary Views: CDB_xxx
- Data Dictionary Views: Examples
- Data Dictionary Views: V$xxx Views
- EM Cloud Control:
- EM Cloud Control: Storage Example
- After CDB Creation: To do List
- Automatic Diagnostic Repository
- Automatic Diagnostic Repository: alert.log File
- Provisioning New Pluggable Databases
- Tools
- Method 1: Create New PDB from PDB$SEED
- Steps: With FILE_NAME_CONVERT
- Steps: Without FILE_NAME_CONVERT
- Method 1: Using SQL Developer
- Synchronization
- Method 2: Plug a Non-CDB into CDB
- Plug a Non-CDB into CDB Using DBMS_PDB
- Plug a Non-CDB into CDB Using Replication
- Method 3: Clone PDBs
- Clone PDBs: Using SQL Developer
- Method 4: Plug Unplugged PDB into CDB
- Method 4: Flow
- Unplugged PDB: Using SQL Developer
- Plug Unplugged PDB: Using SQL Developer
- Unplug and Plug PDB with Encrypted Data
- Plug Sample Schemas PDB: Using DBCA
- Dropping a PDB
- Migrating pre-12.1 or 12.1 non-CDB to CDB
- Course Structure
- Connection
- Connection with SQL*Developer
- Creating Services
- Switching Connection
- Starting Up a CDB Instance
- Mounting a CDB
- Opening a CDB
- Opening a PDB
- Closing a PDB
- Shutting Down a CDB Instance
- Database Event Triggers: Automatic PDB Opening
- Changing PDB Mode
- Changing PDB Mode: With SQL Developer
- Modifying a PDB Settings
- Instance Parameter Change Impact
- Instance Parameter Change Impact: Example
- Using ALTER SYSTEM Statement on PDB
- Course Structure
- Tablespaces in PDBs
- Creating Permanent Tablespaces in a CDB
- Assigning Default Tablespaces
- Creating Local Temporary Tablespaces
- Assigning Default Temporary Tablespaces
- Course Structure
- Users, Roles, and Privileges
- Local Users, Roles, and Privileges
- Creating a Local User
- Common Users
- Creating a Common User
- Common and Local Schemas
- Common and Local Privileges
- Granting Common and Local Privileges
- Granting and Revoking Privileges
- Creating Common and Local Roles
- Granting Common or Local Privileges / Roles to Roles
- Granting Common and Local Roles to Users
- Granting and Revoking Roles
- Creating Shared and Nonshared Objects
- Enabling Common Users to Access Data in Specific PDBs
- Finding Information About CONTAINER_DATA Attributes
- Creating Common and Local Profiles
- Assigning Common and Local Profiles to Users
- Assigning Profiles
- Restriction on Definer's Rights
- Course Structure
- New Syntax and Clauses in RMAN
- CDB Backup: Whole CDB Backup
- CDB Backup: User-Managed Hot CDB Backup
- CDB Backup: Partial CDB Backup
- PDB Backup: Whole PDB Backup
- PDB Backup: Partial PDB Backup
- Using RMAN Backup to Plug an Unplugged PDB
- Recovery
- Instance Failure
- NOARCHIVELOG Mode
- Media Failure: CDB or PDB Tempfile Recovery
- Media Failure: PDB Tempfile Recovery
- Media Failure: Control File Loss
- Media Failure: Redo Log File Loss
- Media Failure: root SYSTEM or UNDO datafile
- Media Failure: root SYSAUX Datafile
- Media Failure: PDB SYSTEM Datafile
- Media Failure: PDB Nonsystem Datafile
- Using Data Recovery Advisor
- Data Failures
- Data Recovery Advisor RMAN Command-Line Interface
- Media Failure: PITR
- Flashback CDB
- Duplicating Pluggable Databases
- Checking for Block Corruption
- Special Situations
- New Data Dictionary View and Column
- Course Structure
- Tuning a Multitenant Container Database
- Tuning Methodology
- General Tuning Session
- Sizing the CDB
- Testing the Estimates
- Allocating Resources in the CDB
- Initialization Parameters in a CDB
- Enterprise Manager Cloud Control 12c: Setting Initialization Parameters
- Tuning CDB Memory
- Enterprise Manager Cloud Control 12c: Memory Advisors
- Memory Advisors
- Limiting PGA Usage
- Tuning SQL
- AWR SQL Reports
- ADDM Tasks
- SQL Advisors
- SQL Tuning Advisor
- Resource Manager and Pluggable Databases
- Managing Resources Between PDBs
- CDB Resource Plan Basics: Share
- CDB Resource Plan Basics: Limits
- CDB Resource Plan: Full Example
- Creating a CDB Resource Plan
- Maintaining a CDB Resource Plan
- Creating CDB Resource Plan: SQL Example
- Viewing CDB Resource Plan Directives
- Enabling a CDB Resource Plan
- Managing Resources Within a PDB
- Managing PDB Resource Plans
- Putting It Together
- Considerations
- Consolidated Database Replay Use Cases
- Use Cases: Source Workloads
- The Big Picture
- Step 1
- Step 2
- Step 3
- Step 4
- Consolidated Replay Steps
- Course Structure
- Using Oracle Data Pump with PDBs
- Exporting from non-CDB and Importing into PDB
- Exporting and Importing Between PDBs
- Exporting from PDB and Importing into non-CDB
- Full Transportable Export/Import: Overview
- Full Transportable Export/Import: Usage
- Full Transportable Export/Import: Example
- Transporting a Database Over the Network: Example
- Using SQL*Loader with PDBs
- Auditing Actions in a CDB and PDBs
- Creating an Audit Policy at CDB/PDB Level
- Enabling / Disabling the Audit Policy
- Viewing the Audit Policy
- Viewing the Audit Records CDB_UNIFIED_AUDIT_TRAIL
- Dropping the Audit Policy
- Audit Cleanup
- Securing Data with Transparent Data Encryption
- The Keystore and Master Keys
- Creating the Keystore
- Opening the Keystore
- Setting Master Encryption Keys
- Unplug and Plug PDB with Encrypted Data
- Securing Data with Oracle Database Vault
- Using Xstreams with a CDB and PDB
- Creating a Standby of a CDB
- Scheduling Operations in a PDB
- Jobs Coordinator and Resources
- Mining Statements of a PDB Using LogMiner
- Database as a Service Architecture
- Database as a Service: Features and Tooling
- Software Editions: Included Database Options and Management Packs
- Accessing the Oracle Database Cloud Service Console
- Automated Database Provisioning
- Accessing Tools from the Service Console
- Managing the Compute Node Associated With a Database Deployment
- Managing Network Access to Database as a Service
- Enabling Access to a Compute Node Port
- Scaling a Database Deployment
- Patching Database as a Service
- Using the Oracle Database Cloud Service Console to Manage Patches
- Migrating from On-premises to Oracle Cloud Database
- Gather Information for Migration