1Z0-882 · Question #60
In MYSQL 5.6 you have the table t1: CREATE TABLE t1 ( id int unsigned NOT NULL PRIMARY key) ENGINE = InnoDB; There are two connections to the server. They execute in this order: Connection 1> SET…
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #60. The question stem and answer options stay visible for context.
Question
In MYSQL 5.6 you have the table t1:
CREATE TABLE t1 ( id int unsigned NOT NULL PRIMARY key) ENGINE = InnoDB; There are two connections to the server. They execute in this order:
Connection 1> SET TRANSACTION ISOLATION LEVEL REPEATABLE READ; Connection 1> START TRANSACTION; Connection 1> SELECT * FROM t1 WHERE id =1; Connection 2> TRUNCATE TABLE t1; What happens to the TRUNCATE TABLE command in connection 2?
Options
- AIt immediately proceeds and causes an implicit commit of the transaction in connection1.
- BIt runs concurrently with the transaction in connection 1 as each connection has its own view of
- CIt blocks waiting for a metadata lock until the transaction in connection 1 ends.
- DIt blocks waiting for a table lock until the transaction in connection 1 ends.
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.