Multiple choice technology programming languages

In Inner and outter join

  1. Buffers are always used

  2. Choice of buffer can be made to use

  3. Buffers are always bypassed

  4. None of above

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In inner and outer joins, buffers are always bypassed because the database must access the actual table data to perform the join operation correctly across tables. Using buffered data could produce inconsistent results since buffers only contain individual table data.