下列为防止幻读而设置的隔离级别,语句正确的是
A. SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
B. SET ISOLATION LEVEL READ UNCOMMITTED;
C. SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
D. SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
下列用于查看MySQL当前事务隔离级别的语句中,正确的是
A. SELECT @tx_isolation;
B. SELECT TRANSACTION LEVEL
C. SELECT @@tx_isolation;
D. SELECT @@transaction;
(多选)多线程并发访问数据库并同时开启事务的情况下,可能产生的问题包括
A. 脏读
B. 幻读
C. 重复读
D. 以上都不对
(多选)下列事务隔离级别中,能防止脏读发生的有
A. READ UNCOMMITTED
B. READ COMMITTED
C. REPEATABLE READ
D. SERIALIZABLE