Câu 20: SnowPro Advanced Data Engineer
A Data Engineer ran a stored procedure containing various transactions. During the execution, the session abruptly disconnected, preventing one transaction from committing or rolling back. The transaction was left in a detached state and created a lock on resources. What step must the Engineer take to immediately run…
Nội dung câu hỏi
A Data Engineer ran a stored procedure containing various transactions. During the execution, the session abruptly disconnected, preventing one transaction from committing or rolling back. The transaction was left in a detached state and created a lock on resources. What step must the Engineer take to immediately run a new transaction?
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. Call the system function SYSTEM$ABORT_TRANSACTION. — đáp án hiện tại
- B. Call the system function SYSTEM$CANCEL_TRANSACTION.
- C. Set the LOCK_TIMEOUT to FALSE in the stored procedure.
- D. Set the TRANSACTION_ABORT_ON_ERROR to TRUE in the stored procedure.
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.