Q. Which privilege must be given to the database to create a stored function or procedure?

  • (A) CREATE ROUTINE
  • (B) CREATE METHOD
  • (C) CREATE FUNCTION
  • (D) CREATE PROCEDURE
💬 Discuss
✅ Correct Answer: (A) CREATE ROUTINE
Explanation: This question asks about the specific privilege required to create stored functions and procedures in MySQL. Stored functions and procedures are like reusable blocks of code that you can call to perform specific tasks within your database.

Published by Ram Avtar Sharma ⭐ 4.50K Points at 22-Mar-2025 12:41 pm in MySQL

Explanation by: Ram Avtar Sharma
This question asks about the specific privilege required to create stored functions and procedures in MySQL. Stored functions and procedures are like reusable blocks of code that you can call to perform specific tasks within your database.

💬 Discussion

📊 Question Analytics

👁️
83
Total Visits
📽️
1 y ago
Published
🎖️
Ram Avtar Sharma
Publisher
📈
82%
Success Rate