Oracle Exadata Database Machine and Cloud Service 1Z0-338

Oracle Database Software

• Configure and administer a basic database using Oracle features and functions

• Tune the Oracle database for performance in common use case scenarios

Oracle Exadata Architecture

• Describe offloading processing

• Describe the architecture used by Oracle Exadata software

• Use Smart Flash Cache

• Enable Flash Cache Write Back

• Enable Advanced Compression and Hybrid Columnar Compression on Exadata tables

• Describe storage indexes

• Describe Oracle recommended configurations for High Availability configurations

• Enable parallelism for Data Warehouse workloads

• Describe database and Automatic Storage Management-Scoped Security Cconcepts

• Describe the Power Distribution Unit

• Describe memory capabilities of different models

• Describe the importance and use of In-Memory Fault Tolerance in the Exadata Database Machine

• Explain the differences between the types of storage servers available on the Exadata Database Machine

Administration and Configuration

• Compress data using Advanced Compression and Hybrid Columnar Compression

• Use network configuration options

• Create and configure Automatic Storage Management disk groups using Exadata

• Explain the impact of various diskgroup failure group choices

• Install software onto the Exadata Database Machine

• Describe various tasks that can be done with the Integrated Lights Out Management (ILOM) console

• Reconfigure a 1/8th rack into a 1/4 rack

• Describe network components in Exadata

• Create a database snapshot on Exadata for testing purposes

Backup and Recovery

• Create a backup plan for Exadata

• Implement recovery procedures on different failure scenarios

• Describe troubleshooting tasks for backup and recovery processes

• Describe how the Exadata Storage Servers are backed up internally

High Availability

• Describe Oracle’s recommended guidelines for high availability configurations on Exadata

• Identify failure scenarios and implement recovery procedures

• Install high availability software onto the Exadata Database Machine

Monitoring

• Install an Enterprise Manager Exadata Monitoring plug-in

• Set up an agent, plugin, and Exadata target for Enterprise Manager Cloud Control

• Monitor the storage cell using Cell Command Line Interface and Distributed Command Line Interface

• Describe the purpose and uses for Simple Network Management Protocol (SNMP), Intelligent Platform Management Interface (IPMI) and Integrated Lights Out Management for a DB machine

• Use osWatcher and iostat to monitor the Database Machine operating system

• Use exacli and dbcli to monitor storage cells

Software Maintenance

• Describe software components

• Locate patches for Exadata

• Apply Oracle recommendations to the patching process for Exadata

• Describe the Oracle Configuration Manager

• Explain how to perform planned maintenance of the Exadata machine

• Describe how to use the Oracle Exadata Deployment Assistant to create virtual machines on Exadata

Bulk Loading and Migration

• Use Database File System (DBFS) to perform bulk loading operations

• Use the ASM Cluster File System (ACFS) to perform bulk data loading operations

• Configure a Database for staging input data files

• Use external tables for data loads

• Describe migration strategies for Exadata

• Explain Oracle recommendations on how to choose a migration strategy

Resource Management

• Set up instance caging

• Manage I/O on Exadata

Support

• Set up an Automatic Service Request (ASR) on the Database Machine

• Explain the ASR configuration process

• Describe implementation requirements for Platinum Support

Exadata in the Cloud

• Describe the Oracle Exadata Cloud Service provisioning process

• Configure backup and recovery on the Exadata Cloud Service

• Administer the Oracle Database on the Exadata Cloud Service

• Administer the Oracle Database on the Exadata Cloud Machine

Rating Distribution

• 1 stars: 1 votes
• 2 stars: 1 votes
• 3 stars: 1 votes
• 4 stars: 2 votes
• 5 stars: 3 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!