The return type is a scalar. It is either true or false (undef) depending on whether or not the execute succeeded. If the execute failed then you can get more details from $sth->err or $sth->errstr.

"The first rule of Perl club is you do not talk about Perl club."
-- Chip Salzenberg