User A issues the command:
LOCK TABLES pets READ;
Which command can User B execute against the pets table?
A.
UPDATE pets…
B.
SELECT….FROM pets
C.
INSERT INTO pets…
D.
ALTER TABLE pets…
Explanation:
User A issues the command:
LOCK TABLES pets READ;
Which command can User B execute against the pets table?
User A issues the command:
LOCK TABLES pets READ;
Which command can User B execute against the pets table?
A.
UPDATE pets…
B.
SELECT….FROM pets
C.
INSERT INTO pets…
D.
ALTER TABLE pets…
Explanation:
B
B
B obv. For completeness, here’s the relevant manual entry: https://dev.mysql.com/doc/refman/5.6/en/lock-tables.html