Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a new application, which heavily reads and writes data. This requires the following config file options: Sync_binlog=1 Innodb_flush_log_at_trx_commit=1 Innodb_doublewrite=1 However, this configuration is expected to introduce disk I/O overhead. What three changes will reduce disk I/O overheads?()
第1题:
紧急后退三。
A.Full astern!
B.Double full astern!
C.Emergency full astern!
D.Emergency three astern!
第2题:
Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a new application, which heavily reads and writes data.This requires the following config file options: Sync_binlog=1 Innodb_flush_log_at_trx_commit=1 Innodb_doublewrite=1 However, this configuration is expected to introduce disk I/O overhead.What three changes will reduce disk I/O overheads?()
A.Use of soft links for database directories on the same physical disk
B.Use of delay_key_write=ON for batch index update
C.Allocation of RAM to the buffer pool such that more of the data can fit in RAM
D.Placement of InnoDB log files and datadir on separate physical disks
E.Use of separate directories on the same physical disk for log files and data files
第3题:
此题为判断题(对,错)。
第4题:
第5题:
事物的ACID特性中C的含义是( )。A.一致性(consistency)B.邻接性(continuity)C.连续性(continuity)D.并发性(consistency)
第6题:
事务的ACID特性()
A 原子性(Atomicity)
B 一致性(Consistency)
C 隔离性(Isolation)
D 持续性(Durability )
第7题:
A.CONNECT
B.IMP_FULL_DATABASE
C.FULL_EXPORT_PRIVS
D.RESOURCE
E.FULL_IMPORT_PRIVS
第8题:
A.full=0
B.full>1
C.full<1
D.full=1
答案:A
解析:生产者运行的同时,消费者也在运行,因为是full=0,导致消费者对full的p操作被阻塞,此时消费者的执行就被阻塞。
第9题:
在数据库加锁技术中,一个事务如果对某一数据项加了排它(exclusive)锁,它将保持此锁直到该事务结束。这是保证事务______特性。
A.原子性(atomicity)
B.一致性或可串行性(consistency or serializability)
C.永久性(durability)
D.隔离性(isolaty)
第10题: