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

Access by ROWID is the fastest method because ROWID represents the direct physical address of a row in the database file. Once the ROWID is known, Oracle can go directly to that physical location without any index traversal, block searching, or table scanning.

Keep practicing — related questions