Just wanted to amend that, since you seem to be confused between the database handle functions and the statement handle functions, this would be the equivalent written using the sth functions:

$sth = $dbh->prepare($sql);
$sth->execute('TESTA1', 'TESTA2', 'TESTA3');
$aref = $sth->fetchall_arrayref({stuff => here});
[download]

(the database handle functions offer the do() and select*() shortcuts for doing similar things, although they are not as efficient in some cases)