Module 13: Error-Handling

What is SQL error handling used for?

• To prevent all errors from occurring

• To hide errors from users

• To catch and manage errors that occur during query execution

• To automatically fix errors in the database

In a TRY...CATCH block, what is executed if an error occurs within the TRY block?

• The CATCH block

• The FINALLY block

• The RETRY block

• The ERROR block

What is the purpose of the @@ERROR system function in SQL?

• To retrieve the SQL version

• To fetch error messages from external sources

• To return the last error number

• To restart the current query

Which keyword is used to access information about an error in the CATCH block?

• ERROR_CODE()

• ERRNO()

• ERROR_NUMBER()

• ERRINFO()

Which SQL statement is used to raise a custom error?

• RAISE ERROR

• THROW

• RAISE

• SIGNAL