Multiple choice technology databases

SQL has facility for programmed handling of errors that arise during the manipulation of data.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The statement claims SQL has NO error handling facility, which is False. SQL DOES have programmed error handling: PL/SQL uses EXCEPTION blocks, T-SQL uses TRY/CATCH, MySQL uses DECLARE handlers. Modern SQL implementations support robust error handling mechanisms for data manipulation errors.

AI explanation

To answer this question, you need to understand the concept of error handling in SQL.

Option A) True - This option is incorrect. SQL does have error handling mechanisms in place to handle errors that occur during data manipulation.

Option B) False - This option is correct. SQL does not have a built-in facility for programmed handling of errors that arise during the manipulation of data. However, SQL does provide some error handling features such as TRY-CATCH blocks in certain implementations like Microsoft SQL Server.

The correct answer is B) False. This option is correct because SQL does not have a facility for programmed handling of errors that arise during the manipulation of data.

Keep practicing — related questions