1Z0-873 · Question #47
Which of the following correctly describes the differences between explicitly and implicitly set locks?
The correct answer is A. Implicitly set locks are locks set and released on behalf of the client, by the server. D. Explicitly set locks are locks acquired and released by the client. For a client that does nothing special to acquire locks, the MySQL server implicitly acquires locks as necessary to process the client's statements safely. If implicit locking is insufficient for a client's purposes, it can manage locks explicitly byacquiring them with LOCK…
Question
Which of the following correctly describes the differences between explicitly and implicitly set locks?
Options
- AImplicitly set locks are locks set and released on behalf of the client, by the server.
- BExplicitly set locks are locks set and released on behalf of the client, by the server.
- CImplicitly set locks are locks acquired and released by the client.
- DExplicitly set locks are locks acquired and released by the client.
How the community answered
(40 responses)- A75% (30)
- B8% (3)
- C18% (7)
Explanation
For a client that does nothing special to acquire locks, the MySQL server implicitly acquires locks as necessary to process the client's statements safely. If implicit locking is insufficient for a client's purposes, it can manage locks explicitly byacquiring them with LOCK TABLES and releasing them with UNLOCK TABLES. Explicit locking may be necessary when a client needs to perform an operation that spans multiple statements and that must not be interrupted by other
Topics
Community Discussion
No community discussion yet for this question.