Quarter Rack of X2-2
Half Rack of X2-2
Full Rack of X2-2
Full Rack of X2-8
Results of random reads.
Results of table scans.
Write to a mirror
All data is cached In the Flash Cache
Load compressed files with Direct Path loading.
Sort incoming data on a column with a low cardinality.
Use DBFS and external flies to load the data.
Use Data Pump to load data.
You can manage workloads within a database with Database Resource Manager.
You can manage workloads across multiple databases with Database Resource Manager
You can manage workloads within a database with I/O Resource Manager
You cannot manage workloads across multiple databases
You use RMAN.
You back up the software files using an operating system method
You do a complete copy of their system storage area.
You do not need to backup this software, as there is an automated recovery mechanism built into each cell.
A grid disk must use all of a cell disk.
A grid disk can only use portions of a cell disk across all cells.
A grid disk can use portions of a cell disk on a subset of cells.
A grid disk can span multiple Exadata Storage Server cells.
The role specified for the category
The role specified for the user
The role specified In a Data Guard environment
The role specified for the application
The cell must be rebooted.
You must alter ASM to alert IT
You must recreate any grid disks that use the drive
Exadata Smart Flash Cache expands the allocation to hold the objects
Not all objects will be stored in Exadata Smart Flash Cache
Overall performance is increased as more objects fit into Exadata Smart Flash Cache
CELL_FLASH_CACHE attribute on the data object
CACHE hint In the SQL statement
Data from a table scan
Small data less than 128 KBs
Control file I/Os
Create a grid disk for every table space
Create two grid disks, one for data and one for recovery
Create two grid disks, one for tables and one for Indexes
Create a grid disk for each table
Based on the priority of the user
Based on the resource group of the user
Based on the intradatabase resource plan
Offload processing allows PL/SQL functions to be executed on the Exadata Storage Server
Offload processing aggregates SQL processing into higher level functions, which are shipped to the Exadata Storage Server
Offload processing moves some processing closer to the stored data, which allows the Exadata Storage Server to return only the rows and columns requested
Offload processing is just marketing - it provides no real advantage
Through flash cache.
Through the Infiniband switch
Through onboard memory
There is never any cell-to-cell communication in an Exadata Storage Server
A Quarter Rack, with 20 TB storage
A Half Rack, with 50 TB raw storage
A Full Rack, with 100 TB of raw storage
You should try to talk your customer into using High Capacity disk
The Exadata Storage Server can select rows based on column values listed in a SQL predicate
Storage indexes are built on columns for use in filtering
Only necessary columns are returned to the database server
Column filtering is a marketing term, not a real benefit
Hardware in the database servers
Software in the database servers
Software in the Exadata Storage Server
Hardware in the Exadata Storage Server
Stores minimum and maximum values for a 1 MB region
Can be used to eliminate cells from queries
Is a standard database index
Persists through a cell reboot
Production over Test and OLTP over maintenance
OLTP over maintenance and control-file I/Os over database writes
Apply operations over read-only queries on standby databases and control-file I/Os over database writes
Apply operations over read-only queries on standby databases and OLTP over maintenance