Question

The variable that is a handle to a database object is ______________

(a) $dbh

(b) $sth

(c) $fh

(d) $h

This question was posed to me in an online interview.

This interesting question is from Perl DBI Overview topic in division MySQL Programs Using Perl DBI and PHP of MySQL

Answer 1

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.