nerdexam
Oracle

1Z0-536 · Question #23

The Oracle Exadata Database Machine retrieves data from disks in response to a SQL statement in the same way as a standard database server.

The correct answer is B. False. The Exadata Database Machine technology can retrieve the data in a more efficient way compared to a standard database server. When using Exadata, much SQL processing is offloaded from the database server to the Exadata cells. Exadata enables function shipping from the database…

Smart Scan Technology

Question

The Oracle Exadata Database Machine retrieves data from disks in response to a SQL statement in the same way as a standard database server.

Options

  • ATrue
  • BFalse

How the community answered

(58 responses)
  • A
    19% (11)
  • B
    81% (47)

Explanation

The Exadata Database Machine technology can retrieve the data in a more efficient way compared to a standard database server. When using Exadata, much SQL processing is offloaded from the database server to the Exadata cells. Exadata enables function shipping from the database instance to the underlying storage in addition to providing traditional block serving services to the database. One of the unique things the Exadata storage does compared to traditional storage is return only the rows and columns that satisfy the database query rather than the entire table being queried.

Topics

#Smart Scan#storage offloading#data retrieval model#offload processing

Community Discussion

No community discussion yet for this question.

Full 1Z0-536 Practice