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 81 discussion

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

Which two must be true for a Smart Scan to occur on a table?

  • A. Sessions querying the table must set cell_offload_processing = true.
  • B. It must be stored in an ASM diskgroup with a 4MByte AU size.
  • C. It must be heap organized.
  • D. It must be accessed using direct path reads.
  • E. The table must not be compressed.
Show Suggested Answer Hide Answer
Suggested Answer: AD 🗳️
by IsaacA5 at Feb. 1, 2024, 11:15 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
IsaacA5
1 year ago
Correct answers: AD For the Smart Scan to work, the SQL you run must have these requirements: • The segment you are querying must be stored in an Exadata Database Machine where the disk group with the cell.smart_scan_capable attribute is set to true. • A Full Table Scan or an Index Fast Full Scan operation must occur. • The segment must be big enough to fire a direct path read operation.
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