Multiple choice technology databases

Which Oracle access method is the fastest way for Oracle to retrieve a single row?

  1. Primary key access

  2. Access via unique index

  3. Table access by ROWID

  4. Full table scan
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In Oracle database, accessing a table directly using a physical ROWID is the fastest possible access method because it points directly to the exact file, block, and slot of the row without needing index lookups.

Keep practicing — related questions