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_doublewri

题目

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

相似考题

1.事务的ACID特性中的C的含义是（ ）。A)并发性(Concurrency)B)临近性(Contiguity)C)连续性(Continuity)D)一致性(Consistency)

2.事物的ACID特性中C的含义是（ ）。A．一致性（consistency）B．邻接性（continuity）C．连续性（continuity）D．并发性（consistency）

3.事务管理的特性叙述不正确的是 A.事务管理特性包括：（1）原子性、（2）一致性（Consistency）（3）隔离性（Isolation）、（4）持续性（永久性）（Durability） B.原子性（Atomicity）是指数据库的逻辑工作单位。 C.隔离性（Isolation）是指可以被其他事务干扰。 D.持续性（永久性）（Durability）是指一旦提交，改变就是永久性的

4.事务的ACID特性()A 原子性(Atomicity)B 一致性(Consistency)C 隔离性(Isolation)D 持续性(Durability )

参考答案和解析
参考答案：B, C, D
更多“Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a ”相关问题

  • 第1题：

    A transaction is an action,or a series of actions,carried out by a single user or（ ）,that accesses or changes the contents of the database.A transaction should possess the four basic or so-called ACID properties:Atomicity.The“all or nothing”property.A transaction is an（ ）unit that is either performed in its entirety or is not performed at all.Consistency.A transaction must transform the database from one consistent state to another consistent state.Isolation.Transactions execute independently of one another.In other words,the partial effects of（ ）transactions should not be visible to other transactions.Durability.The effects of a successfully completed（committed）transaction are permanently recorded in the database and must not be lost because of a subsequent failure.The four properties above,only（请作答此空）property is the responsibility of the concurrency control subsystem to ensure.It is the responsibility of both the（ ）and the application developers to ensure consistency.To guarantee the Atomicity and Durability properties after a failure,a log file is needed.

    A.atomicity
    B.consistency
    C.isolation
    D.durability

    答案：B
    解析：

  • 第2题：

    A transaction is an action,or a series of actions,carried out by a single user or（请作答此空）,that accesses or changes the contents of the database.A transaction should possess the four basic or so-called ACID properties:Atomicity.The“all or nothing”property.A transaction is an（ ）unit that is either performed in its entirety or is not performed at all.Consistency.A transaction must transform the database from one consistent state to another consistent state.Isolation.Transactions execute independently of one another.In other words,the partial effects of（ ）transactions should not be visible to other transactions.Durability.The effects of a successfully completed（committed）transaction are permanently recorded in the database and must not be lost because of a subsequent failure.The four properties above,only（ ）property is the responsibility of the concurrency control subsystem to ensure.It is the responsibility of both the（ ）and the application developers to ensure consistency.To guarantee the Atomicity and Durability properties after a failure,a log file is needed.

    A.application developer
    B.all users
    C.application program
    D.DBMS

    答案：C
    解析：

  • 第3题：

    A transaction is an action,or a series of actions,carried out by a single user or（ ）,that accesses or changes the contents of the database.A transaction should possess the four basic or so-called ACID properties:Atomicity.The“all or nothing”property.A transaction is an（ ）unit that is either performed in its entirety or is not performed at all.Consistency.A transaction must transform the database from one consistent state to another consistent state.Isolation.Transactions execute independently of one another.In other words,the partial effects of（ ）transactions should not be visible to other transactions.Durability.The effects of a successfully completed（committed）transaction are permanently recorded in the database and must not be lost because of a subsequent failure.The four properties above,only（ ）property is the responsibility of the concurrency control subsystem to ensure.It is the responsibility of both the（请作答此空）and the application developers to ensure consistency.To guarantee the Atomicity and Durability properties after a failure,a log file is needed.

    A.DBMS
    B.DBA
    C.end user
    D.DBS

    答案：A
    解析：

  • 第4题：

    A transaction is an action,or a series of actions,carried out by a single user or（ ）,that accesses or changes the contents of the database.A transaction should possess the four basic or so-called ACID properties:Atomicity.The“all or nothing”property.A transaction is an（ ）unit that is either performed in its entirety or is not performed at all.Consistency.A transaction must transform the database from one consistent state to another consistent state.Isolation.Transactions execute independently of one another.In other words,the partial effects of（请作答此空）transactions should not be visible to other transactions.Durability.The effects of a successfully completed（committed）transaction are permanently recorded in the database and must not be lost because of a subsequent failure.The four properties above,only（ ）property is the responsibility of the concurrency control subsystem to ensure.It is the responsibility of both the（ ）and the application developers to ensure consistency.To guarantee the Atomicity and Durability properties after a failure,a log file is needed.

    A.completed
    B.incomplete
    C.aborted
    D.committed

    答案：B
    解析：

  • 第5题：

    A transaction is an action,or a series of actions,carried out by a single user or（ ）,that accesses or changes the contents of the database.A transaction should possess the four basic or so-called ACID properties:Atomicity.The“all or nothing”property.A transaction is an（请作答此空）unit that is either performed in its entirety or is not performed at all.Consistency.A transaction must transform the database from one consistent state to another consistent state.Isolation.Transactions execute independently of one another.In other words,the partial effects of（ ）transactions should not be visible to other transactions.Durability.The effects of a successfully completed（committed）transaction are permanently recorded in the database and must not be lost because of a subsequent failure.The four properties above,only（ ）property is the responsibility of the concurrency control subsystem to ensure.It is the responsibility of both the（ ）and the application developers to ensure consistency.To guarantee the Atomicity and Durability properties after a failure,a log file is needed.

    A.Indivisible
    B.permanent
    C.infrequent
    D.infinite

    答案：A
    解析：

相关内容