?
Which statement issues a lock on tables?
Answer & Solution
Correct Answer:
Option
C
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
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
Join the Discussion
Login to post a comment or share your explanation.
Login