ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

How many of the following can be used in stored functions?
PREPARE, EXECUTE, DEALLOCATE PREPARE

Answer & Solution
Correct Answer: Option A
This question asks about what commands are allowed inside stored functions in MySQL. Stored functions are like reusable code blocks you can call from your SQL queries.
Let's break down the commands:
* PREPARE: This command prepares a SQL statement for later execution.
* EXECUTE: This command actually runs a prepared SQL statement.
* DEALLOCATE PREPARE: This command cleans up a prepared statement, freeing up resources.
Stored functions have limitations. They can't directly work with prepared statements (PREPARE, EXECUTE, DEALLOCATE PREPARE).
The correct answer: Option A: 0
None of these commands can be used inside stored functions.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.