Question

Which variable is a handle to a database object?

(a) $dbh

(b) $sth

(c) $fh

(d) $h

I have been asked this question during an interview for a job.

My question is based upon Date and Time Data Types topic in portion Data Type Reference, Operators and Functions of MySQL

Answer 1

The correct choice is (a) $dbh

For explanation I would say: The variable named ‘$dbh’ is a handle to an open file. ‘$h’ is a generic handle and the meaning depends on context. ‘$dbh’ is a handle to a database object. ‘$sth’ is a handle to a query object.