What occurs if a procedure or function terminates with failure without being handled?
Submitted by: Administrator1. Any DML statements issued by the construct are still pending and can be committed or rolled back.
2. Any DML statements issued by the construct are committed
3. Unless a GOTO statement is used to continue processing within the BEGIN section, the construct terminates.
4. The construct rolls back any DML statements issued and returns the unhandled exception to the calling environment.
Submitted by: Administrator
2. Any DML statements issued by the construct are committed
3. Unless a GOTO statement is used to continue processing within the BEGIN section, the construct terminates.
4. The construct rolls back any DML statements issued and returns the unhandled exception to the calling environment.
Submitted by: Administrator
Read Online SQL Job Interview Questions And Answers
Top SQL Questions
☺ | Under which circumstance must you recompile the package body after recompiling the package specification? |
☺ | What is sql Posting? |
☺ | For which trigger timing can you reference the NEW and OLD qualifiers? |
☺ | The command used to open a CURSOR FOR loop is? |
☺ | What occurs if a procedure or function terminates with failure without being handled? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |