Which two statements are true about InnoDB auto－increment locking?() A.The auto-increment lock can be a table-level lockB.InnoDB never uses table-level locksC.Some settings for innodb_autoinc_lock_mode can help reduce lockingD.InnoDB always protects auto-increment updates with a table-level lock
Which two statements are true about InnoDB auto－increment locking?()
A.The auto-increment lock can be a table-level lock
B.InnoDB never uses table-level locks
C.Some settings for innodb_autoinc_lock_mode can help reduce locking
D.InnoDB always protects auto-increment updates with a table-level lock
相关考题：
下列CASE语句中执行结果不为空的是() A、SELECTCASEWHEN125THEN'true'ELSE'false'END;B、SELECTCASEBINARY'B'WHEN'a'THEN1WHEN'b'THEN2END;C、SELECTCASEWHEN-10THEN'true'END;D、SELECTCASE'one'WHEN1THEN'one'WHEN2THEN'two'END;
下列复选框构造方法，错误的是 ( )A．setLayout(new GridLayout(3，1))；B．add(new Checkbox("one"，null，true))；C．add(new Checkbox("two"))；D．add(new Checkbox("one"，true))；
下列复选框构造方法，错误的是()。A．setLayout(newGridLayout(3,1));B．add(newCheckbox("one",null,true));C．add(newCheckbox("tWO");D．add(newCheckbox("one",true);
About ________ of the workers in the factory were born in the ________.A.two-thirds, 1970 B.two-thirds, 1970s C.two-third,1970 D.two-third, 1970s
12． About_______ of the workers in the factory were born in the __________．A． two- thirds;1970B． two- thirds ; 1970sC． two-third ; 1970D． two-third ; 1970s
InnoDB 引擎与 MyISAM 引擎相比，有哪些优越之处？A．InnoDB支持事务B．InnoDB 可以支持外键C．InnoDB表不可能丢失数据D．InnoDB上的事务只可能锁住需要更新的行
【单选题】要修改数据表tb_student的存储引擎为InnoDB，可以使用下面的（）语句A．ALTER TABLE tb_student DEFAULT CHARSET=InnoDB;B．ALTER TABLE tb_student ENGINE=InnoDB;C．ALTER TABLE tb_student AUTO_INCREMENT=InnoDB;D．Alter TABLE tb_student ADD CONSTRAINT mrprimary PRIMARY KEY (id);
关于innoDB锁,下面描述正确的是A．InnoDB通过对索引项加锁实现行锁.B．InnoDB锁能够避免并发更新造成更新丢失.C．InnoDB中一个正在执行的事务中更新了多行记录,已经更新了的行上锁会自动释放.D．InnoDB中select for update操作和update操作所加的锁不同.
关于InnoDB存储引擎,下面说法正确的是:A．InnoDB存储引擎中的update操作,一定是先写事务日志,再修改数据内容.B．InnoDB存储引擎可以通过配置,牺牲持久化安全,提高性能.C．InnoDB存储引擎不会出现脏读.D．InnoDB存储引擎持久化的时候,每个commit必须将日志先刷到磁盘.