Question

Which function returns reference to hash of row values?

(a) fetchrow_array()

(b) fetchrow_arrayref()

(c) fetch()

(d) fetchrow_hashref()

I have been asked this question by my college professor while I was bunking the class.

My doubt is from Copying Databases to Another Server in section Database Maintenance, Backups and Replication of MySQL

Answer 1

Correct answer is (d) fetchrow_hashref()

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().