Q. The locking statements LOCK TABLES and UNLOCK TABLES are not permitted in stored routines.

  • (A) True
  • (B) concrete
  • (C) ---
  • (D) ---
💬 Discuss
✅ Correct Answer: (A) True
Explanation: In MySQL, locking statements such as LOCK TABLES and UNLOCK TABLES are used to control access to tables, preventing other sessions from modifying them while the lock is held. We need to determine whether these locking statements are permitted in stored routines.

Published by Ritu Singhal ⭐ 4.43K Points at 22-Mar-2025 12:41 pm in MySQL

Explanation by: Ritu Singhal
In MySQL, locking statements such as LOCK TABLES and UNLOCK TABLES are used to control access to tables, preventing other sessions from modifying them while the lock is held. We need to determine whether these locking statements are permitted in stored routines.

💬 Discussion

📊 Question Analytics

👁️
163
Total Visits
📽️
1 y ago
Published
🎖️
Ritu Singhal
Publisher
📈
94%
Success Rate