Workshop
The quiz and exercises are provided to help you solidify your understanding of the material covered today. Try to understand the quiz and exercise answers before continuing to tomorrow's lesson.
Quiz
| 1: | True or False: A table lock, when obtained by one client, prevents other clients from reading from or writing to a table. |
| A1: | True for a write lock. With a read lock, the statement is not true because it allows other threads to read from the table. |
| 2: | True or False: When preparing to run a query on several tables, any lock must be obtained on all those tables. |
| A2: | True. You must obtain suitable locks on all tables that will be used by your queries, until you unlock the tables. |
| 3: | True or False: With transaction-safe processing, you must issue ... |
Get Sams Teach Yourself MySQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
