Which Oracle access method is the fastest way for Oracle to retrieve a single row?A. Primary key access.B. Access via unique indexC. Table access by ROWIDD. Full table scan

  • Interview Candidate
  • 15
  • 13971

Showing Answers 1 - 15 of 15 Answers

mahesh

  • Dec 31st, 2005
 

Access via unique index is the right answer.

brinda

  • Apr 3rd, 2006
 

C. Table access by ROWID

  Was this answer useful?  Yes

saqib

  • Apr 3rd, 2006
 

Hi,

The answer for it is by specifying its row- id.

This is what i found about it.

13.5.2 Rowid Scans

The rowid of a row specifies the datafile and data block containing the row and the location of the row in that block. Locating a row by specifying its rowid is the fastest way to retrieve a single row, because the exact location of the row in the database is specified.

srichaitanya

  • Jan 6th, 2012
 

A. Primary key access

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions