1Z0-873 · Question #8
Which of the following best describes the scope of explicitly and implicitly set locks?
The correct answer is A. Explicitly set locks may span several commands. 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. For example, the server acquires a read lock when the client issues a SELECT statement and a write lock when the client…
Question
Which of the following best describes the scope of explicitly and implicitly set locks?
Options
- AExplicitly set locks may span several commands.
- BImplicitly set locks may span several commands.
- CImplicitly set locks will span only one statement or transaction.
- DExplicitly set locks will span only one statement or transaction.
How the community answered
(47 responses)- A79% (37)
- B6% (3)
- C13% (6)
- D2% (1)
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. For example, the server acquires a read lock when the client issues a SELECT statement and a write lock when the client issues an INSERT statement. Implicit locks are acquired only for the duration of a single statement. 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 clients.
Topics
Community Discussion
No community discussion yet for this question.