多选题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_doubl

题目
多选题
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特性()A 原子性(Atomicity)B 一致性(Consistency)C 隔离性(Isolation)D 持续性(Durability )

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.atomicity B.consistency C.isolation D.durability

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.completed B.incomplete C.aborted D.committed

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

参考答案和解析
正确答案： D,E
解析： 暂无解析
更多“多选题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_doubl”相关问题

  • 第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.application developer
    B.all users
    C.application program
    D.DBMS

    答案：C
    解析：

  • 第2题：

    事务的性质：（）（Atomicity）、（）（Consistency）、（）（Isolation）、（）（Durability）。


    正确答案:原子性；一致性；隔离性；持久性

  • 第3题：

    A HDD is almost full and constantly reads and writes data. Which of the following tools may repair files on the HDD?（）

    • A、MSCONFIG
    • B、EFS
    • C、CHKDSK
    • D、DEFRAG

    正确答案:C

  • 第4题：

    Sometimes performance is more important than availability （e.g.， in cases where the data can be easily re-created）. Which of the following is the appropriate disk configuration for an application that requires faster writes over availability？（）

    • A、RAID-1
    • B、RAID-5
    • C、RAID-0+1
    • D、RAID-0

    正确答案:D

  • 第5题：

    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

    正确答案:B,C,D

  • 第6题：

    You develop a Web application that writes data to a file on a server. You restrict access to the file to specific Windows users. The Web application runs as CONTOSO/ASPNET. You deny anonymous access to the application in IIS. You add the following XML segment in the Web.config file.You need to ensure that the application meets the following requirements:It must impersonate the user when it writes data to the file.It must run as CONTOSO/ASPNET when a user does not access the file. Which two actions should you perform? （）

    • A、Use the following XML segment in the Web.config file. <identity impersonate="false"/>
    • B、Use the following XML segment in the Web.config file. <identity impersonate="true"/>
    • C、Use the following code segment to access the file. Dim wp As WindowsPrincipal = _CType(HttpContext.Current.User, WindowsPrincipal) Dim wi As WindowsIdentity = WindowsIdentity.GetCurrent() Dim wic As WindowsImpersonationContext = wi.Impersonate()' Access the file herewic.Undo()
    • D、Use the following code segment to access the file. Dim wi As WindowsIdentity = WindowsIdentity.GetCurrent()Dim wic As WindowsImpersonationContext = _WindowsIdentity.Impersonate(wi.Token)' Access the file herewic.Undo()

    正确答案:A,C

  • 第7题：

    事务的特性有（）。

    • A、原子性（Atomicity）
    • B、一致性（Consistency）
    • C、隔离性（1solation）
    • D、可生存性（Survivability）
    • E、持续性（Durability）

    正确答案:A,B,C,E

  • 第8题：

    多选题
    You create a Microsoft ASP.NET Web application by using the Microsoft .NET Framework version 3.5.  You deploy the application on a Microsoft IIS 6.0 Web server. The server runs on a worker process isolation mode， and it hosts the .NET Framework version 1.1 Web applications. When you attempt to browse the application， the following error message is received：  "It is not possible to run different versions of ASP.NET in the same IIS process. Please use the IIS Administration Tool to reconfigure your server to run the application in a separate process."    You need to ensure that the following requirements are met： all the applications run on the server  all the applications remain in process isolation mode all the applications do not change their configuration.   Which two actions should you perform？（）
    A

    Create a new application pool and add the new application to the pool.

    B

    Configure the IIS 6.0 to run the WWW service in the IIS 5.0 isolation mode.

    C

    Configure the new application to use the .NET Framework version 2.0 in the IIS 6.0 Manager.

    D

    Set autoConfig=false on the <processModel> property in the machine.config file.

    E

    Disable the Recycle worker processes option in the Application Pool Properties dialog box.


    正确答案： B,E
    解析： 暂无解析

  • 第9题：

    多选题
    You are implementing an ASP.NET Web application. Users will authenticate to the application with an ID. The application will allow new users to register for an account. The application will generate an ID for the user based on the users full name. You need to implement this registration functionality. Which two actions should you perform？（）
    A

    Configure the SqlMembershipProvider in the web.config file.

    B

    Configure the SqlProfileProvider in the web.config file.

    C

    Create an ASP.NET page that contains a default CreateUserWizard control to create a new user account.

    D

    Create an ASP.NET page that contains a custom form that collects the user information and then uses the Membership.CreateUser method to create a new user account.


    正确答案： B,D
    解析： 暂无解析

  • 第10题：

    单选题
    Which background process reads the redo log buffer and writes it to a file？（）
    A

    ARCn

    B

    DBWn

    C

    CKPT

    D

    LGWR

    E

    PMON

    F

    SMON


    正确答案： F
    解析： 暂无解析

  • 第11题：

    多选题
    事务的特性有（）。
    A

    原子性（Atomicity）

    B

    一致性（Consistency）

    C

    隔离性（1solation）

    D

    可生存性（Survivability）

    E

    持续性（Durability）


    正确答案： C,A
    解析： 暂无解析

  • 第12题：

    多选题
    You develop a Web application that writes data to a file on a server. You restrict access to the file to specific Windows users. The Web application runs as CONTOSO/ASPNET. You deny anonymous access to the application in IIS. You add the following XML segment in the Web.config file.You need to ensure that the application meets the following requirements:It must impersonate the user when it writes data to the file.It must run as CONTOSO/ASPNET when a user does not access the file. Which two actions should you perform? （）
    A

    Use the following XML segment in the Web.config file. <identity impersonate=false/>

    B

    Use the following XML segment in the Web.config file. <identity impersonate=true/>

    C

    Use the following code segment to access the file. Dim wp As WindowsPrincipal = _CType(HttpContext.Current.User, WindowsPrincipal) Dim wi As WindowsIdentity = WindowsIdentity.GetCurrent() Dim wic As WindowsImpersonationContext = wi.Impersonate()' Access the file herewic.Undo()

    D

    Use the following code segment to access the file. Dim wi As WindowsIdentity = WindowsIdentity.GetCurrent()Dim wic As WindowsImpersonationContext = _WindowsIdentity.Impersonate(wi.Token)' Access the file herewic.Undo()


    正确答案： B,C
    解析： 暂无解析

  • 第13题：

    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
    解析：

  • 第14题：

    You develop a Web application that writes data to a file on a server. You restrict access to the file to specific Windows users. The Web application runs as CONTOSO/ASPNET. You deny anonymous access to the application in IIS. You add the following XML segment in the Web.config file. You need to ensure that the application meets the following requirements: 1. It must impersonate the user when it writes data to the file 2. It must run as CONTOSO/ASPNET when a user does not access the file. Which two actions should you perform?（）

    • A、Use the following XML segment in the Web.config file.<identity impersonate="false"/>
    • B、 Use the following XML segment in the Web.config file.  <identity impersonate="true"/>
    • C、Use the following code segment to access the file. WindowsPrincipal wp =(WindowsPrincipal)HttpContext,Current.User;WindowsIdentity wt = (WindowsIdentity)wp.Idetity;WindowsImpersonationContext wic = wi.Impersonate();// Access The file herewic.Undo();
    • D、Use the following code segment to access the file. WindowsIdentity wi = WindowsIdetity.GetCurrent();WindowsImpersonationContext wic = WindowsIdentity.Impersonate(wi.Token);// Access the file herewic.Undo();

    正确答案:A,C

  • 第15题：

    Sometimes performance is more important than availability （e.g.， in cases where the data can be easily re-created）.  Which of the following is the appropriate disk configuration for an application that requires faster writes over availability（）

    • A、RAID 1
    • B、RAID 6
    • C、RAID 0 + 1
    • D、RAID 0

    正确答案:D

  • 第16题：

    Which background process reads the redo log buffer and writes it to a file？（）

    • A、ARCn
    • B、DBWn
    • C、CKPT
    • D、LGWR
    • E、PMON
    • F、SMON

    正确答案:D

  • 第17题：

    You create a Microsoft ASP.NET Web application by using the Microsoft .NET Framework version 3.5.  You deploy the application on a Microsoft IIS 6.0 Web server. The server runs on a worker process isolation mode， and it hosts the .NET Framework version 1.1 Web applications. When you attempt to browse the application， the following error message is received：  "It is not possible to run different versions of ASP.NET in the same IIS process. Please use the IIS Administration Tool to reconfigure your server to run the application in a separate process."    You need to ensure that the following requirements are met： all the applications run on the server  all the applications remain in process isolation mode all the applications do not change their configuration.   Which two actions should you perform？（）

    • A、Create a new application pool and add the new application to the pool. 
    • B、Configure the IIS 6.0 to run the WWW service in the IIS 5.0 isolation mode. 
    • C、Configure the new application to use the .NET Framework version 2.0 in the IIS 6.0 Manager. 
    • D、Set autoConfig="false" on the <processModel> property in the machine.config file. 
    • E、Disable the Recycle worker processes option in the Application Pool Properties dialog box.

    正确答案:A,C

  • 第18题：

    You are implementing an ASP.NET Web application. Users will authenticate to the application with an ID. The application will allow new users to register for an account. The application will generate an ID for the user based on the users full name. You need to implement this registration functionality. Which two actions should you perform？（）

    • A、Configure the SqlMembershipProvider in the web.config file.
    • B、Configure the SqlProfileProvider in the web.config file.
    • C、Create an ASP.NET page that contains a default CreateUserWizard control to create a new user account.
    • D、Create an ASP.NET page that contains a custom form that collects the user information and then uses the Membership.CreateUser method to create a new user account.

    正确答案:A,D

  • 第19题：

    多选题
    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


    正确答案： D,A
    解析： 暂无解析

  • 第20题：

    多选题
    You create a Microsoft ASP.NET Web application by using the Microsoft .NET Framework version 3.5. You deploy the application on a Microsoft IIS 6.0 Web server. The server runs on a worker process isolation mode， and it hosts the .NET Framework version 1.1 Web applications.  | English | Chinese | Japan | Korean | - 108 - Test Information Co.， Ltd. All rights reserved. When you attempt to browse the application， the following error message is received：  "It is not possible to run different versions of ASP.NET in the same IIS process. Please use the IIS Administration Tool to reconfigure your server to run the application in a separate process." You need to ensure that the following requirements are met：  ¡；¤All the applications run on the server  ¡；¤All the applications remain in process isolation mode  ¡；¤All the applicatios do not change their configurations.  Which two actions should you perform？（）
    A

    Create a new application pool and add the new application to the pool.

    B

    Configure the IIS 6.0 to run the WWW service in the IIS 5.0 isolation mode.

    C

    Configure the new application to use the .NET Framework version 2.0 in the IIS 6.0 Manager.

    D

    Set autoConfig=false on the  property in the machine.config file.

    E

    Disable the Recycle worker processes option in the Application Pool Properties dialog box.


    正确答案： B,A
    解析： 暂无解析

  • 第21题：

    填空题
    事务的性质：（）（Atomicity）、（）（Consistency）、（）（Isolation）、（）（Durability）。

    正确答案： 原子性,一致性,隔离性,持久性
    解析： 暂无解析

  • 第22题：

    单选题
    Sometimes performance is more important than availability （e.g.， in cases where the data can be easily re-created）. Which of the following is the appropriate disk configuration for an application that requires faster writes over availability？（）
    A

    RAID-1

    B

    RAID-5

    C

    RAID-0+1

    D

    RAID-0


    正确答案： A
    解析： 暂无解析

  • 第23题：

    多选题
    You develop a Web application that writes data to a file on a server. You restrict access to the file to specific Windows users. The Web application runs as CONTOSO/ASPNET. You deny anonymous access to the application in IIS. You add the following XML segment in the Web.config file. You need to ensure that the application meets the following requirements: 1. It must impersonate the user when it writes data to the file 2. It must run as CONTOSO/ASPNET when a user does not access the file. Which two actions should you perform?（）
    A

    Use the following XML segment in the Web.config file.<identity impersonate=false/>

    B

    Use the following XML segment in the Web.config file.  <identity impersonate=true/>

    C

    Use the following code segment to access the file. WindowsPrincipal wp =(WindowsPrincipal)HttpContext,Current.User;WindowsIdentity wt = (WindowsIdentity)wp.Idetity;WindowsImpersonationContext wic = wi.Impersonate();// Access The file herewic.Undo();

    D

    Use the following code segment to access the file. WindowsIdentity wi = WindowsIdetity.GetCurrent();WindowsImpersonationContext wic = WindowsIdentity.Impersonate(wi.Token);// Access the file herewic.Undo();


    正确答案： B,D
    解析： 暂无解析

相关内容