Question

Which function returns a reference to hash of row values?

(a) fetchrow_array()

(b) fetchrow_arrayref()

(c) fetch()

(d) fetchrow_hashref()

I had been asked this question in final exam.

Question is taken from Operators topic in section Data Type Reference, Operators and Functions of MySQL

Answer 1

The correct answer is (d) fetchrow_hashref()

Easiest explanation: The function ‘fetchrow_hashref()’ returns reference to hash of row values. ‘fetchrow_arrayref()’ returns a reference to an array of row values. ‘fetch()’ is the same as fetchrow_arrayref().