Question

Which function returns reference to array of row values?

(a) fetchrow_array()

(b) fetchrow_arrayref()

(c) fetch()

(d) fetchrow_hashref()

The question was posed to me in class test.

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

Answer 1

Right choice is (b) fetchrow_arrayref()

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