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

Retrieving a single row by its physical address (ROWID) is the fastest possible access path in Oracle, as it bypasses index lookups and directly targets the block containing the row.

Keep practicing — related questions