Which statement issues a lock on tables?
A. ISSUE LOCK
B. LOCK ISSUE
C. LOCK TABLES
D. ISSUE LOCKS
Answer: Option C
Solution (By Examveda Team)
This question is about how you control access to data in a MySQL database. Think of it like a library - you need to check out a book before you can read it. In MySQL, you need to "lock" a table before you can make changes to it.Here's the breakdown: * Option A: ISSUE LOCK - This isn't a valid command in MySQL. * Option B: LOCK ISSUE - Again, not a valid command in MySQL. * Option C: LOCK TABLES - This is the correct answer! It's the command used to explicitly lock tables, preventing others from modifying them while you're working. * Option D: ISSUE LOCKS - This isn't a valid command in MySQL.
So, the answer is Option C: LOCK TABLES
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