What is true regarding InnoDB locking?() A.InnoDB uses row and table-level locks, but row locks are not escalatesB.InnoDB locks only those rows that are updatedC.InnoDB only uses row locks, not page or table-level locksD.InnoDB row locks may be escalated to page or table-level locksE.InnoDB uses row-level or table-level locks depending on the number of rows affected

What is true regarding InnoDB locking?()

A.InnoDB uses row and table-level locks, but row locks are not escalates

B.InnoDB locks only those rows that are updated

C.InnoDB only uses row locks, not page or table-level locks

D.InnoDB row locks may be escalated to page or table-level locks

E.InnoDB uses row-level or table-level locks depending on the number of rows affected


相关考题:

A spokesman said: ―We have no comment _______ the publication of these photographs.‖ (A) regarded(B) regard(C) regarding(D) to regard

[A] Like[B] Except[C] Regarding[D] With

Have you remembered _______the windows? It’s going to rain. A.lockedB.to lockC.locking

在Mysql数据库下,以下哪个选项最好地描述了InnoDB表为什么需要主键并且主键应当尽量短?() A.因为InnoDB在一个日志中保存到所有主键的指针,短的主键使日志小B.因为InnoDB使用主键定位二级索引,短的主键使查询快C.因为InnoDB使用主键定位表记录,短的主键使查询快D.因为InnoDB使用主键定位表,短的主键使查询快

Import for the first three months this year is larger than that for the__________period last year.A.relatingB.concerningC.correspondingD.regarding

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表为索引组织表,数据是以主键排序的,如果表中没有主键,那么表是堆表B.InnoDB表数据页默认大小和Oracle默认大小一样,都是8KC.InnoDB数据修改前一定会写事务日志,事务提交时会将数据以及日志刷到磁盘D.InnoDB锁包含记录锁以及间隙锁,间隙锁是指锁住索引区间,避免插入

关于InnoDB存储引擎,下面说法正确的是:A.InnoDB存储引擎中的update操作,一定是先写事务日志,再修改数据内容.B.InnoDB存储引擎可以通过配置,牺牲持久化安全,提高性能.C.InnoDB存储引擎不会出现脏读.D.InnoDB存储引擎持久化的时候,每个commit必须将日志先刷到磁盘.