Multiple choice technology databases

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

  1. Full table scan

  2. Table access by ROWID

  3. Access via unique index

  4. Primary key access
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

ROWID is Oracle's physical row address. Access by ROWID is the fastest single-row retrieval method because it's a direct physical location lookup. Unique index requires index traversal first, full table scan reads all rows, and primary key access typically uses an index.

Keep practicing — related questions