GET 70% Discount on All Products Coupon code: "Board70"
Examine these statements which execute successfully:
The statements executed without exception. Which two are true?
No transaction commits.
One row is inserted into band.
Two transactions commit.
No row is inserted into band.
The transaction is rolled back to the savepoint.
You must reclaim memory used by a prepared statement named prep. Which two achieve this?
SET @a = ''; EXECUTE prep USING @a;
DEALLOCATE PREPARE prep?
DROP PROCEDURE prep;
SET @prep = NULL;
DROP PREPARE prep;
PREPARE prep FROM '';
TESTED 23 Nov 2024
