Oracle Exadata X5 Administration 試験
Question No : 1
Which four are true about Exadata features?
CD: That data remains compressed not only on disk, but also remains compressed in the Exadata Smart Flash Cache, on Infiniband, in the database server buffer cache, as well as when doing back-ups or logshipping to Data Guard.
E (not B): Use the Write-Back Flash Cache feature to leverage the Exadata Flash hardware and make Exadata Database Machine a faster system for Oracle Database Deployments. Write-through cache mode is slower than write-back cache mode.
However, write-back cache mode has a risk of data loss if the Exadata Storage Server loses power or fails.
F: Storage indexes are not stored on disk; they are resident in the memory of the storage cell servers.
Question No : 2
You issued these commands to all Exadata Storage Servers in an X6 Exadata Database Machine using dcli:
alter iormplan objective = low_latency
alter iormplan active
There are no database or category plans defined.
You are encountering disk I/O performance problems at certain times, which vary by day and week.
DSS and Batch workloads perform well some of the time.
Further investigation shows that at times, the workloads are all OLTP I/Os, at other times all batch I/Os, and sometimes a bit of each.
You wish to have disk I/O managed so that performance will be optimized for all workloads.
Which statements would you issue to all Exadata Storage Servers to achieve this?
The supported IORM objectives are auto, low_latency, balanced, and high_throughput. The recommended objective option is auto which allows IORM to continuously monitor the workloads, and select the best mode based on the active workloads currently on the cells.
Question No : 3
You plan to migrate a database supporting both DSS and OLTP workloads to your new X5 Database machine.
The workloads contain many complex aggregating functions and expensive joins on large partitioned tables in the DSS workload and indexed access for OLTP workloads.
Which three benefits accrue as a result of this migration?
There are 6 different kinds of Table Data Compression methods:
Question No : 4
Your X6 Exadata Database Machine is running Oracle Database 12c, and has a large database with some very large tables supporting OLTP workloads.
High-volume insert applications and high-volume update workloads access the same tables.
You wish to compress these tables without causing unacceptable performance overheads to the OLTP workload.
Which three are true regarding this requirement?
A: Creating a Table with Advanced Row Compression
The following example enables advanced row compression on the table orders:
CREATE TABLE orders ... ROW STORE COMPRESS ADVANCED;
B: ARCHIVE LOW compression (Exadata only), recommended for Archival Data with Load Time as a critical factor
Question No : 5
You plan to migrate a database supporting an OLTP workload to your new X5 Database Machine.
The current database instance supports a large number of short duration sessions and a very high volume of short transactions.
Which three X5 Database Machine features can improve performance for this type of workload?
A: To further accelerate OLTP workloads, the Exadata Smart Flash Cache also implements a special algorithm to reduce the latency of log write I/Os called Exadata Smart Flash Logging.
C: Use the Write-Back Flash Cache feature to leverage the Exadata Flash hardware and make Exadata Database Machine a faster system for Oracle Database Deployments.
D: Exadata X5-2 introduces Extreme Flash Storage Servers. Each Extreme Flash storage server contains eight 1.6 TB state-of-the-art PCI Flash drives. PCI flash delivers ultra-high performance by placing flash memory directly on the high speed PCI bus rather than behind slow disk controllers and directors.
Question No : 6
Which three statements are true about Automatic Hard Disk Scrubbing and repair on high-capacity storage servers in an X5 Database Machine?
The default schedule of scrubbing is every two weeks.
Question No : 7
You have altered an index supporting a constraint to be invisible on a large data warehouse table in an X5 Database Machine.
Which two statements are true?
B: With making indexes invisible, we can easily check whether indexes are useful without having to drop (and in case recreate) them actually. While this may be of interest for “ordinary” Oracle Databases already, it is particular a useful feature for Exadata where we expect some conventional indexes to become obsolete after a migration.
C: DISABLE NOVALIDATE RELY means: "I don't want an index and constraint checking to slow down my batch data loading into datawarehouse, but the optimizer can RELY on my data loading routine and assume this constraint is enforced by other mechanism". This information can greatly help optimizer to use correct materialized view when rewriting queries. So if you don't use materialized views for query rewrite then you can put RELY for all your constraints (or NORELY for all your constraints) and forget about it.
Question No : 8
Use the RMAN CONVERT to change the database files to the little endian format on the source system.
Identify the required steps in the correct order.
Step 1: 1. Create a new 184.108.40.206 Exadata Cbased database.
Step 2: 2. Export the source system metadata using transportable Tablespace (TTS).
Step 3: 3. Transfer the files to the Database Machine and use the RMAN CONVERT command to change them to the little endian format.
Step 4: 4. Import the metadata into the target database.
This method is often chosen when migrating between platforms with different endian formats, or in cases where physical re-organization is not necessary.
The transportable tablespace method is generally mu
Question No : 9
Which three are true concerning Storage Indexes?
A: Each disk in the Exadata storage cell is divided into equal sized pieces called storage regions (default 1MB). There is an index entry for every storage regions (1MB of data stored on disk). Each entry contains the minimum and maximum value for columns seen in ‘where’ clause predicates. Information for up to 8 columns can be stored. The index is then used to eliminate disk IO by identifying which storage regions don’t match the ‘where’ clause of a query.
Question No : 10
Which three are sources for alerts from storage servers in an X5 Database Machine?
AB: The Management Server (MS) process receives the metrics data from CELLSRV, keeps a subset of metrics in memory, and writes to an internal disk-based repository hourly. In addition, the MS process can generate alerts for important storage cell hardware or software events.
Question No : 11
Which two statements are true about the Integrated Lights Out Manager (ILOM) on an Exadata x5 or x6 Database Machine?
C: ILOM supports the Intelligent Platform Management Interface (IPMI), which enables you to monitor and control your server platform, as well as to retrieve information about your server platform.
ILOM supports alerts in the form of IPMI Platform Event Trap (PET) alerts. Alerts provide advance warning of possible system failures.
E: Oracle ILOM supports the Simple Network Management Protocol (SNMP), which is used to exchange data about network activity.
SNMP functionality requires the following two components:
Question No : 12
You must apply patches and patch bundles in a rolling fashion, if possible, on the components of your Exadata X6 Database Machine.
You use RAC for your databases and also use Data Guard, having standby databases on another Database Machine.
You want to have scripts that contain the appropriate commands to patch your environment.
Your patch bundle is one the first database server and is located at/uo1/stage.
You have downloaded the oplan utility to the first database server and run:
$ORACLE_HOME/oplan/oplan generateApplySteps /u01/stage
Which two statements are true concerning the type of instructions oplan will generate?
Oplan generates instructions for all of the nodes in the cluster.
Question No : 13
You plan to consolidate your company’s INVENTORY and SALES databases onto your new Exadata X6 Database Machine.
You are considering consolidation of all schemas into one RAC database.
Which three factors would you need to consider before choosing this approach?
Question No : 14
You are evaluating the performance of a SQL statement that accesses a very large table.
You run this query:
Identify two reasons why the “physical read total bytes” statistic is greater than the “cell physical IO bytes eligible for predicate offload” statistic.
Question No : 15
Which two activities are supported on the storage servers in an Exadata X6 Database Machine?