Examveda

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

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous