Multiple choice technology databases

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

  1. Primary key access

  2. Full table scan

  3. Access via unique index

  4. Table access by ROWID
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

ROWID is Oracle's internal physical address for each row. Access by ROWID is the fastest method because it's a direct physical lookup, avoiding index traversal or full scans. Primary key and unique index access are fast but require index navigation.

Keep practicing — related questions