Question

What is the variable that is a handle to a database object?

(a) $dbh

(b) $sth

(c) $fh

(d) $h

I got this question during an internship interview.

The query is from General Preventative Maintenance topic in section Database Maintenance, Backups and Replication of MySQL

Answer 1

The correct option is (a) $dbh

To explain: 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.