Free Oracle 1Z0-070 Exam Actual Questions

The questions for 1Z0-070 were last updated On Nov 21, 2024

Question No. 1

Which three statements are true about Exadata storage server alerts in an X5 Database Machine?

Show Answer Hide Answer
Correct Answer: A, B, C

Question No. 2

Which components of an Exadata storage server image, if updated, may require that a patch also be applied to the database servers in an Exadata X6 Database Machine?

Show Answer Hide Answer
Correct Answer: D

Exadata patches are intended for and include fixes for both the storage servers and Compute servers, and optionally InfiniBand switches.

Patching order

You should patch the Exadata Database Machines in the following sequence

References:

https://www.toadworld.com/platforms/oracle/w/wiki/11640.oracle-exadata-patching


Question No. 3

Which two completely prevent a Smart Scan from occurring?

Show Answer Hide Answer
Correct Answer: B, E

B: Migrated Rows is a special case of chained rows. Migrated rows still affect performance, as they do in conventional storage situations, but with the additional overhead of reducing the beneficial effects of ''Smart Scan'' in addition to increasing the number of I/Os

E: Smart Scans - broadly speaking and ignoring edge cases - can only transport a maximum of 254 columns from a single (non-HCC) segment. Requesting more columns will simply disable Smart Scans for that segment.

An interesting limitation to Exadata Smart Scans - if more than 254 columns from a table (not HCC compressed, more on that in moment) need to be projected, Smart Scans for that particular segment will be disabled and Exadata will fall back to conventional I/O. This means that the number of columns in the projection clause can make a significant difference to performance, since only Smart Scans allow taking advantage of offloading and particularly avoiding I/O via Storage Indexes.


Question No. 4

Which two statements are true about the Integrated Lights Out Manager (ILOM) on an Exadata X5 or X6 Database Machine?

Show Answer Hide Answer
Correct Answer: C, E

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:

References:

https://docs.oracle.com/cd/E19860-01/E21452/E21452.pdf


Question No. 5

Which two options should be used to identify a damaged or failing flash card on an X6 Database Machine high-capacity storage server?

Show Answer Hide Answer
Correct Answer: A, D

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