Question 2 0.5 pts A/An stores a value that can change as a procedure executes.

Question

Question 2 0.5 pts A/An stores a value that can change as a procedure executes. Question 3 0.5 pts If you want to allow MySQL to attempt to execute statements in a block of code even after it DQuestion 4 0.5 pts To create a procedure, you use the CREATE PROCEDURE statement, but to execute a procedure you use the Question 5 0.5 pts Code a SQL statement that declares a variable named message_var with a VARCHAR data type that can store a maximum of 140 characters. Then, code a second statement that assigns the value "Test" to that variable. D Question 6 0.5 pts If you declare multiple condition handlers when coding a stored program, you should code the Specific error handler last.

Explanation / Answer

Q2)A/An-------- stores a value that can change as a procedure executes.
ans)
varible. variable named data object to stores the value. that can be changed in procedure execution

Q3)if you want to allow MySQl to attempt to execute statements in a block of code even after encountered an error. you should use a/an-------------------handler.
ans)
CONTINUE handler.
they are two kinds of handler as to stop if error occer or else continue with taking necesarry action. to do have two handlers has CONTINUE and EXIT

Q4)to create a procedure, you use the CREATE PROCEDURE statement, but to execute the procedure you use the ---------------statement?
ans)
EXEC statement.
they are two ways to execute the stored program. one was with application or user. and second one Transact-SQL EXECUTE or EXEC keyword.

Q5) code a SQL statement that declares a variable named message_var with a VARCHAR data type that can store the maximum of 140 characters. then code a second statement that assigns the value "test" to that variable?
ans)
DECLARE message_var VARCHAR(140) DEFAULT NULL;
SET message_var="test";

Q6)if you declare multiple condition handlers when coding a stored program. you should code the ----specific error handler last.
ans)
SQLEXCEPTION handler,
why because based on the handler precedence rule first precedence is MySQL error handler then second precedence is SQLSTATE and third one was the SQLEXCEPTION handler.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.