Question list
List of questions
Related questions
Question 57 - DEA-C01 discussion
What are Invalid rules applicable when using stored procedure contains transaction?
A.
A transaction can be inside a stored procedure, or a stored procedure can be inside a transaction.
B.
You cannot start a transaction before calling the stored procedure, then complete the transaction inside the stored procedure.
C.
You cannot start a transaction inside the stored procedure, then complete the transac-tion after returning from the procedure.
D.
If a transaction is started inside a stored procedure and is still active when the stored procedure finishes, then an error occurs, and the transaction is rolled back.
E.
A transaction inside a stored procedure can include a call to another stored procedure that contains a transaction.
F.
All Rules are Applicable.
Previous
Next
Your answer:
0 comments
Sorted by
Leave a comment first
