PrepAway - Latest Free Exam Questions & Answers

A single row SELECT statement is preferable to a cursor SELECT statement when only one row needs to be retriev

A single row SELECT statement is preferable to a cursor SELECT statement when only one row
needs to be retrieved because _______.

PrepAway - Latest Free Exam Questions & Answers

A.
there are fewer executor calls needed between the application and the executor

B.
the operation enables Sequential Block Buffering (SBB) so that unnecessary scanning and
transfer to buffers is avoided for the single row

C.
the cost of additional executor calls (for OPEN and CLOSE CURSOR) is spread out over
multiple fetches

D.
Sequential Block Buffering (SBB) allows efficient scanning and transfer to the buffer for
multiple-row access


Leave a Reply