The locking statements LOCK TABLES and UNLOCK TABLES are not permitted in stored routines.
A. True
B. False
Answer: Option A
Solution(By Examveda Team)
In MySQL, locking statements such asLOCK 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.The correct answer is Option A: True.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion