Question

The function that returns a reference to an array of row values is ______________

(a) fetchrow_array()

(b) fetchrow_arrayref()

(c) fetch()

(d) fetchrow_hashref()

I got this question during an interview for a job.

The question is from Secure Connections topic in portion Nulls and Conditions and Miscellaneous of MySQL

Answer 1

Right option is (b) fetchrow_arrayref()

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