Which two are true about Smart Scan?
Correct Answer:DE
D: With Exadata storage, database operations are handled much more efficiently. Queries that perform table scans can be processed within Exadata storage with only the required subset of data returned to the database server. Row filtering, column filtering and some join processing (among other functions) are performed within the Exadata storage cells. When this takes place only the relevant and required data is returned to the database server.
E: With Smart Scan processing, row filtering, column filtering, some join processing, and other functions are performed in the Exadata cells.
References:
http://www.centroid.com/blog/exadata-smart-scan-processing
A heap-organized table in one of your database schemas contains only date, char, varchar2, and number data type columns.
Which three operations can be offloaded to Exadata Storage Servers when performing a Smart Scan on this table?
Correct Answer:ACF
Which three statements are true concerning InfiniBand port and subnet monitoring on an X5 Database Machine?
Correct Answer:BCE
B: From any InfiniBand switch in the network (leaf switch or spine switch), log in as root and run the getmaster command to obtain the location of the master SM as follows:
# getmaster
This command displays the host name or IP address and the IP address of the switch where the master SM is running.
C: CellCLI> list ibport - Will display InfiniBand configuration details
E: The DBMCLI utility is the command-line administration tool for configuring database servers, and managing objects in the server environment.
The LIST IBPORT command displays attributes for InfiniBand ports determined by the specified attributes and filters.
References:
http://docs.oracle.com/cd/E80920_01/DBMMN/exadata-dbmcli.htm
https://docs.oracle.com/cd/E18476_01/doc.220/e18478/GUID-9FF8B5B0-3481-4B73-89D3-108CBD7EB989.h
You must replace the battery on the disk controller in three Exadata storage servers and must power off the affected storage servers.
Which two commands must you execute to safely power off the storage servers in an X5 Database Machine?
Correct Answer:CE
C: Step 1:
Run the following command to check if there are other offline disks
CellCLI> LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes'
If any grid disks are returned, then it is not safe to take the storage server offline because proper Oracle ASM disk group redundancy will not be intact.
E: Step 2:
Inactivate all the grid disks when Oracle Exadata Storage Server is safe to take offline using the following command:
CellCLI> ALTER GRIDDISK ALL INACTIVE
Taking the storage server offline when one or more grid disks are in this state will cause Oracle ASM to dismount the affected disk group, causing the databases to shut down abruptly.
You wish to determine if the I/O resource management plan that you created has helped improve the performance of OLTP category I/Os on your X6 Exadata Database Machine.
You decide to examine the relevant metrics on all the cells, to see whether the I/O rate has improved for this category compared to last week, and whether waits and wait time have been reduced.
You issue this command on the first cell:
You examine the output from the first cell which contains:
Which two sets of metrics would you use to determine whether the I/O performance has improved for the OLTP category for the duration of the one-hour measurement period?
Correct Answer:D