You need to manage an exception in a SQLScript. Which SQLScript features can you use? There are 2 correct answers to this question.
Correct Answer: B,C
To manage an exception in a SQLScript, you can use the SIGNAL and RESIGNAL features, which are SQLScript statements that allow you to raise and handle errors or warnings in your code. The SIGNAL statement allows you to raise a user-defined exception with a specified message and SQLSTATE value. The RESIGNAL statement allows you to propagate an existing exception to the calling procedure or function, or to modify the message or SQLSTATE value of the exception. You can use the SIGNAL and RESIGNAL statements in combination with the BEGIN and END blocks, and the DECLARE and EXIT HANDLER clauses, to define the scope and the action of the exception handling12.
The other options are not correct because they are not SQLScript features that can be used to manage an exception. The DECLARE EXIT HANDLER clause is a SQL feature that allows you to declare a handler for a specific condition or a generic SQLWARNING, SQLEXCEPTION, or NOT FOUND condition. The CREATE EXIT HANDLER statement is not a valid SQL or SQLScript statement at all. References:
* SAP HANA Platform, SAP HANA SQL and System Views Reference, SQL Reference Manual, SQL Statements, SIGNAL
* SAP HANA Platform, SAP HANA SQL and System Views Reference, SQL Reference Manual, SQL Statements, RESIGNAL