ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-070 All Questions

View all questions & answers for the 1z0-070 exam
Go to Exam

Exam 1z0-070 topic 1 question 17 discussion

Actual exam question from Oracle's 1z0-070
Question #: 17
Topic #: 1
[All 1z0-070 Questions]

You are evaluating the performance of a SQL statement that accesses a very large table.
You run this query:

Identify two reasons why the "cell physical IO interconnect bytes" statistic is greater than the "cell physical IO interconnect bytes returned by smart scan" statistic.

  • A. There is a transaction, which committed after the query began, that has modified some of the table blocks, causing some "cell single block physical reads" to be requested by the database instance, resulting in additional I/O.
  • B. There are chained rows in the table, causing some "single block physical reads" to be requested by the database instance, resulting in additional I/O.
  • C. The table is a hash clustered table, causing "cell multiblock physical reads" to be requested by the database instance, resulting in additional I/O.
  • D. The table is list partitioned, causing "cell list of blocks physical reads" to be requested by the database instance, resulting in additional I/O.
  • E. There is a local index on a list partitioned table on the column used in the WHERE clause, causing "cell list of blocks physical reads" to be requested by the
Show Suggested Answer Hide Answer
Suggested Answer: CD 🗳️
C: Scan on a clustered table can prevent a Smart Scan from occur.
D: Scan on an index-organized table can prevent a Smart Scan from occur.
Note: The Cell physical IO interconnect bytes returned by smart scan metric shows how many bytes of I/O were returned by a smart scan to the database server.
References:
https://uhesse.com/2011/01/19/exadata-part-i-smart-scan/
by mistyotux at May 11, 2020, 2:10 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
mistyotux
5 years ago
the answers are not necessarily right. The question misses Event Section which describes cell wait event, total waits and avg waits in order to come to conclusive answer.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago