Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials 試験
Question No : 1
Which statement is true about Exadata Storage Servers?
Question No : 2
Which two statements are true about migrating your database to Exadata?
Question No : 3
How would you execute CellCLI commands and scripts?
The storage cells in Exadata Database Machine are managed via two tools called CellCLI and DCLI.
Question No : 4
Which two statements describe correct network configuration for Exadata Database Machine?
Question No : 5
When would be the best time to run an Exadata health check (exachk)?
#1: Check for updates frequently.
#2: Execute before & after system changes.
#3: Make part of regular planned maintenance
Question No : 6
What are two choices that a customer must make that impact diskgroup creation?
Once you identify candidate grid disks, use the CREATE DISKGROUP command to create your ASM disk groups.
Here are some of the more important considerations to think about when creating ASM disk groups on Exadata:
* (A) When capacity planning, take your redundancy specification into consideration. Normal
redundancy will have the effect of reducing your usable storage to half the raw capacity, and
high redundancy will shrink it to a third of your raw disk capacity.
* Simplicity is best on Exadata. Using wild-carded CREATE DISKGROUP syntax not only offers the most terse command syntax, but also ensures your ASM disk groups are spread evenly across your Exadata Storage Server disks.
* Take the time to plan grid disk prefix names and overall grid disk configuration in the context
of your desired ASM disk group design.
* Make sure to set the appropriate compatible.asm and compatible.rdbms attributes when
creating ASM disk groups.
* Whenever possible, use a 4 MB extent size when creating disk groups on ASM storage.
Question No : 7
Your customer wants to increase the size of the DATA diskgroup on the Exadata systems. The customer is currently using 600 GB disks. Which two are the best options that you would recommend?
Question No : 8
Which two DML operations will add rows compressed by Hybrid Columnar Compression (HCC) to a table that is created to use HCC?
To maximize storage savings with Hybrid Columnar Compression, data must be loaded using data warehouse bulk loading techniques. Examples of bulk load operations commonly used in data warehouse environments are:
* Insert statements with the APPEND hint
* Parallel DML
* Direct Path SQL*LDR
* Create Table as Select (CTAS)
Not A, Not C: DML operations (INSERT/UPDATE) against a Hybrid Columnar Compressed table/partition can reduce the overall compression savings over time since data INSERTED/UPDATED via DML operations will not be compressed to the same ratio as data that is bulk loaded.
Question No : 9
Which two statements are true about troubleshooting failed patching activities?
Question No : 10
Identify three Exadata Storage Server software processes and their purpose?
Explanation:http://www.oracle.com/technetwork/database/exadata/exadata-technical-whitepaper-134575.pdf (page 22)
Question No : 11
Which two attributes describe key benefits of the InfiniBand network?
C: Oracle Exadata is architected to scale-out to any level of performance. To achieve higher performance and greater storage capacity, additional database servers and Exadata cells are added to the configuration C e.g., Half Rack to Full Rack upgrade. As more Exadata cells are added to the configuration, storage capacity and I/O performance increases near linearly.
E: Oracle's interconnect protocol uses direct data placement (DMA C direct memory access) to ensure very low CPU overhead by directly moving data from the wire to database buffers with no extra data copies being made. The InfiniBand network has the flexibility of a LAN network, with the efficiency of a SAN.
Not A: The architecture of the Exadata solution includes components on the database server and in the Exadata cell. The software architecture for a Quarter Rack configuration is shown below.
Not B: No cell-to-cell communication is ever done or required in an Exadata configuration.
Not D: Each InfiniBand link provides 40 Gigabits of bandwidth C
Question No : 12
The mpstat output from OS Watcher shows a database node as being 90% idle on an average. What would you do to get a full picture of CPU utilization on the entire Exadata RAC cluster?
Question No : 13
Identify three best practices for applying asmdeactivationoutcome es on Exadata Database Servers and Exadata Storage Servers?
Question No : 14
You get a Host Unreachable error when you attempt to connect to a server through a network terminal command line. What are two other ways in which you can connect?
In addition to gaining shell access via SSH to manage your Exadata servers, you can also access them from the Integrated Lights Out Management (ILOM) console or KVM console.
and should typically not require modifications unless you have changed network information inside your database
Note: A KVM switch (with KVM being an abbreviation for "keyboard, video and mouse") is a hardware device that allows a user to control multiple computers from one or more keyboard, video monitor and mouse. Although multiple computers are connected to the KVM, typically a smaller number of computers can be controlled at any given time
Question No : 15
Consider this CellCLI command:
CellCLI> CREATE GRIDDISK ALL HARDDISK PREFIX=data, size=423G;
Which two statements describe what happens when you execute this command?
CellCLI> create griddisk all harddisk prefix=temp_dg, size=570G
This command will create 12 Griddisks, each of 570G in size from the outer (fastest) sectors of the underlying Harddisks. It fills up the first 2 Celldisks entirely, because they have just 570G space free C the rest is already consumed by the OS partition.