1Z0-070 Online Practice Questions and Answers

Correct Answer: BD

Explanation:

Determine the Amount of Available Space

To increase the size of the disks in a disk group you must either have unallocated disk space available, or

you have to reallocate space currently used by a different disk group.

Example: View the space currently used by the disk groups.

SELECT name, total_mb, free_mb, total_mb - free_mb used_mb, round(100*free_mb/total_mb,2) pct_free

FROM v$asm_diskgroup

ORDER BY 1;

The example above shows that the DATAC1 disk group has only about 15% of free space available while the RECOC1 disk group has about 87% free disk space. The PCT_FREE displayed here is raw free space, not usable free space. Additional space is needed for rebalancing operations.

References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-administeringasm.htm#SAGUG20526

Correct Answer: DE

Explanation:

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

Correct Answer: AC

Explanation:

A: IPMI – short for Intelligent Platform Management Interface – is an interface standard that allows remote management of a server from another using standardized interface. The servers in the Exadata Database Machine follow that. It's not an Exadata command but rather a general Linux one. To power on a cell or database server, issue this from another server: # ipmitool -H prolcel01-ilom -U root chassis power on To stop a server, use the shutdown command. To stop immediately and keep it down, i.e. not reboot, execute:# shutdown -h -y now

C: Like the KCS interface, the SSIF Interface is only specified as a ‘Single Threaded Interface’ for standard IPMI commands. That is, the BMC implementation is not expected to process more than one IPMI request at a time. While an implementation is allowed to have a degree of ‘command queuing’, for standard IPMI messages the SSIF lacks a ‘Seq’ field that software can use to match up particular instances of requests with responses.

References: https://www.intel.com/content/dam/www/public/us/en/documents/specification-updates/ipmiintelligent-platform-mgt-interface-spec-2nd-gen-v2-0-spec-update.pdf

Correct Answer: CE

Explanation:

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.

Correct Answer: AD

Correct Answer: ADF

Explanation:

A: pt_param( ‘cell_offload_processing’ ’TRUE’) hint is used to enable the exadata smart scan feature in sql execution process.

D: Direct reads bypass the buffer cache and go directly into the process PGA. Cell offload operations occur for direct reads only.

F: The cell.smart_scan_capable attribute must be set to TRUE.

Incorrect Answers:

B, C: The query can run either serially or in parallel.

References: http://blog.tanelpoder.com/2013/05/29/forcing-smart-scans-on-exadata-is-_serial_direct_read-parameter-safe-to-use-in-production/

Correct Answer: AD

Explanation:

The CALIBRATE command runs raw performance tests on cell disks, enabling you to verify the disk

performance before the cell is put online. You must be logged on to the cell as the root user to run

CALIBRATE.

Oracle ILOM automatically detects system hardware faults and environmental conditions on the server. If a

problem occurs on the server, Oracle ILOM will automatically do the following:

Illuminate the Service Required status indicator (LED) on the server front and back panels.

Identify the faulted component in the Open Problems table.

Record system information about the faulted component or condition in the event log.

References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-cellcli.htm#SAGUG20617

Correct Answer: BD

Explanation:

Metrics are a series of measurements that are computed and retained in memory for an interval of time,

and stored on a disk for a more permanent history.

On the storage servers, the CELLSRV process provides the majority of Oracle Exadata storage services

and is the primary storage software component. One of its functions is to process, collect, and store

metrics. 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.

References: http://www.oracle.com/technetwork/articles/servers-storage-admin/monitor-exadata-em12-2291964.html

Correct Answer: BCE

Explanation:

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.htm

Correct Answer: BC

Reference:

https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-storage-server-software-introduction.html#GUID-3E48425A-AB8A-4E62-80C4-BACA65A1F8D3 https://docs.oracle.com/cd/E91266_01/EMXIG/GUID-FB58204F-2D97-41BC-9AA7-10BFF920B5B4.htm#EMXIG304