Question $23$

We are storing a table such as the following on a hard drive. Please fill in "row store" or "column store" in the blank.

$\backslash$table$[[$Student ID$,$Name,Age,GPA$],[1,$Tom,$19,3\mathrm{.}8],[2,$Katie,$19,2\mathrm{.}7],[3,$Aleem,$20,3\mathrm{.}3],[4,$Nejati,$18,3\mathrm{.}0],[5,$John,$21,4\mathrm{.}0]]$

For queries asking for the average age of the students, using results in faster query execution.

For queries asking for Tom's age, using results in faster query execution.

row store; column store

row store; row store

column store: column store

column store; row store