单选题Application A holds an Update lock on a single row and application B is trying to read that row. If both applications are using isolation level UR, which of the following will occur?（）A Application B will read the row.B Applications A and B will cause

题目
单选题
Application A holds an Update lock on a single row and application B is trying to read that row. If both applications are using isolation level UR, which of the following will occur?（）
A

Application B will read the row.

B

Applications A and B will cause a deadlock situation.

C

Application B will wait until application A releases the Update lock.

D

Application A will be terminated so that application B can read the row.

相似考题

1.If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?（）A、Rollback the transaction in both applications.B、Rollback the transaction in one of the two applications.C、Decrease the lock timeout value for both applications, thereby causing a lock timeout situation.D、Send a message to let the administrator know of the situation and decide which application or applications should be terminated.

2.In order to ensure best read performance， which of the following indicates how large an application’s read buffer size should be if the filesystem to be read is striped across N disks using LVM striping？（）A、 N times the stripe unit sizeB、 N times the VMM minfree parameterC、 The same value as that of the VMM maxfree parameterD、 The same value as that of  the VMM maxrndwrt parameter

3.Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the following will occur?（）A、Applications A and B will cause a deadlock situationB、Application B will read the previous version of the rowC、Application B will read the row and see uncommitted changes made by application AD、Application B will be placed in a lock-wait state until application A releases its lock

4.An administrator is in charge of a server that houses various applications. Which of the following BEST explains this server type？（）A、Dedicated Application ServerB、File ServerC、Shared Application ServerD、Peer-to-Peer Application Server

更多“单选题Application A holds an Update lock on a single row and application B is trying to read that row. If both applications are using isolation level UR, which of the following will occur?（）A Application B will read the row.B Applications A and B will cause ”相关问题

  • 第1题：

    Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?（）

    • A、An application process acquires at least a share lock on the current row of every cursor.
    • B、Any row that is read during a unit of work cannot be changed by other application processes until the unit of work is complete.
    • C、Any row changed by another application process can be read, even if the change has not been committed by that application process.
    • D、An application process that issues the same query more than once in a unit of work will not see additional rows caused by other application processes appending new information to the database.

    正确答案:A

  • 第2题：

    Which of the following functions is provided by the LPAR Validation Tool （LVT）？（）

    • A、LPAR creation
    • B、Proper card placement
    • C、Application compatibility assistance
    • D、Response time for applications

    正确答案:B

  • 第3题：

    If an application issues the same query more than once in the same Unit of Work, which isolation level will not permit this application to see additional rows inserted by other applications?（）

    • A、Read Stability (RS)
    • B、Repeatable Read (RR)
    • C、Uncommitted Read (UR)
    • D、Cursor Stability (CS)

    正确答案:B

  • 第4题：

    A batch application executes a large number of update statements. The service level agreement for the application states that the application must complete its work as quickly as possible to ensure that dependent workloads can start ontime. What is one way to help the application complete quickly?（）

    • A、Code the application to issue a LOCK TABLE statement.  
    • B、Code the application to issue a LOCK ROW statement.  
    • C、Decrease the number of I/O servers.  
    • D、Increase the locklist parameter. 

    正确答案:A

  • 第5题：

    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.

    正确答案:A,C

  • 第6题：

    单选题
    Your company has an Active Directory Domain Services (AD DS) domain. You virtualize applications by using Microsoft Application Virtualization (App-V). You are creating an application virtualization package. Which should you use?（）
    A

    Microsoft Application Virtualization Sequencer

    B

    Microsoft Application Virtualization Desktop Client

    C

    Microsoft System Center Application Virtualization Streaming Server

    D

    Microsoft System Center Application Virtualization Management Server


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

  • 第7题：

    多选题
    You are a systems administrator responsible for managing a Windows Server 2008 Web Server Currently，there are no Web sites configured on the server. You need to configure the server to host two Web applications： Engineering App and Sales App. Both Web applications must be accessible by using HTTPport 80 without the use of host headers. Also， you must protect against problems in one Web applicationaffecting the performance or reliability of the other Web application. Which two steps should you take tomeet these requirements？（）
    A

    Create a single Web site that contains both Web applications.

    B

    Create two Web sites， one for each Web application.

    C

    Assign both Web applications to the same application pool.

    D

    Assign each Web application to its own application pool.


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

  • 第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.  | 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
    解析： 暂无解析

  • 第9题：

    单选题
    If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?（）
    A

    Rollback the transaction in both applications.

    B

    Rollback the transaction in one of the two applications.

    C

    Decrease the lock timeout value for both applications, thereby causing a lock timeout situation.

    D

    Send a message to let the administrator know of the situation and decide which application or applications should be terminated.


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

  • 第10题：

    单选题
    A batch application executes a large number of update statements. The service level agreement for the application states that the application must complete its work as quickly as possible to ensure that dependent workloads can start ontime. What is one way to help the application complete quickly?（）
    A

    Code the application to issue a LOCK TABLE statement.  

    B

    Code the application to issue a LOCK ROW statement.  

    C

    Decrease the number of I/O servers.  

    D

    Increase the locklist parameter. 


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

  • 第11题：

    单选题
    If an application issues the same query more than once in the same Unit of Work, which isolation level will not permit this application to see additional rows inserted by other applications?（）
    A

    Read Stability (RS)

    B

    Repeatable Read (RR)

    C

    Uncommitted Read (UR)

    D

    Cursor Stability (CS)


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

  • 第12题：

    单选题
    Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?（）
    A

    The cursor is only protected from updates and deletes by concurrent applications.

    B

    The row is only protected from positioned updates and deletes that reference another cursor of the same application.

    C

    The cursor is protected from positioned updates and deletes that reference another cursor of a different application.

    D

    The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application.


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

  • 第13题：

    Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?（）

    • A、The cursor is only protected from updates and deletes by concurrent applications.
    • B、The row is only protected from positioned updates and deletes that reference another cursor of the same application.
    • C、The cursor is protected from positioned updates and deletes that reference another cursor of a different application.
    • D、The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application.

    正确答案:A

  • 第14题：

    Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?（）

    • A、The database manager will rollback the transaction in both applications.
    • B、The database manager will rollback the transaction in one of the two applications.
    • C、Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.
    • D、Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.

    正确答案:B

  • 第15题：

    Application A holds an Update lock on a single row and application B is trying to read that row. If both applications are using isolation level UR, which of the following will occur?（）

    • A、Application B will read the row.
    • B、Applications A and B will cause a deadlock situation.
    • C、Application B will wait until application A releases the Update lock.
    • D、Application A will be terminated so that application B can read the row.

    正确答案:A

  • 第16题：

    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

  • 第17题：

    Your company has an Active Directory Domain Services (AD DS) domain. You virtualize applications by using Microsoft Application Virtualization (App - V). You are creating an application virtualization package. Which sh ould you use?（）

    • A、Microsoft Application Virtualization Sequencer
    • B、Microsoft Application Virtualization Desktop Client
    • C、Microsoft System Center Application Virtualization Streaming Server
    • D、Microsoft System Center Application Virtualization Management Server

    正确答案:A

  • 第18题：

    单选题
    Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the following will occur?（）
    A

    Applications A and B will cause a deadlock situation

    B

    Application B will read the previous version of the row

    C

    Application B will read the row and see uncommitted changes made by application A

    D

    Application B will be placed in a lock-wait state until application A releases its lock


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

  • 第19题：

    多选题
    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
    解析： 暂无解析

  • 第20题：

    单选题
    An administrator is in charge of a server that houses various applications. Which of the following BEST explains this server type？（）
    A

    Dedicated Application Server

    B

    File Server

    C

    Shared Application Server

    D

    Peer-to-Peer Application Server


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

  • 第21题：

    单选题
    After right-clicking on an applications shortcut icon and selecting Properties， which of the following will identify the location of the application？（）
    A

    Start In

    B

    Location

    C

    Shortcut key

    D

    Run


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

  • 第22题：

    单选题
    Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?（）
    A

    The database manager will rollback the transaction in both applications.

    B

    The database manager will rollback the transaction in one of the two applications.

    C

    Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.

    D

    Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.


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

  • 第23题：

    单选题
    Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?（）
    A

    An application process acquires at least a share lock on the current row of every cursor.

    B

    Any row that is read during a unit of work cannot be changed by other application processes until the unit of work is complete.

    C

    Any row changed by another application process can be read, even if the change has not been committed by that application process.

    D

    An application process that issues the same query more than once in a unit of work will not see additional rows caused by other application processes appending new information to the database.


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

相关内容