Which of the followins will be matched by the SQL wildcard expression "%a_t%" ?

Just "Bart". If the string had been "%a%t%" instead, then "Patrick" and "Catherine" also would have matched.