单选题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 Rea

题目
单选题
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)

相似考题

1.When your WebLogic Server solution needs to be scaled out with additional capacity and you  Don’t want to add additional hardware, which three techniques should you us?（）A、Assign more than one managed server to a physical hardware that allows better CPU  utilizationB、Assign more than one application to one managed server to better utilize threads within a single JVM processC、Assign the same application to more than one managed server to load balance requests  between serversD、Assign the same heap size to the managed server across the cluster for easier control of  memory footprint  E、Create a virtualized environment with hypervisor for an easier solution

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.SQL2提供事务的四种隔离级别，其中最高级别是（）A、SERIALIZABLEB、REPEATABLE READC、READ COMMITTEDD、READ UNCOMMITTED

4. You use Microsoft .NET Framework 4 to create a custom Windows Presentation Foundation (WPF) application. Your environment includes several WPF applications. The applications use the same logo and style configuration as part of a corporate standard. You need to ensure that the existing applications can be updated to use the same logo and style settings without recompiling. Which two actions should you perform?（）A、 Mark the resource as an embedded resource in each application. B、 Create a resource in an XAML file that contains the logo and style configurations.C、 Create a resource in a custom control that contains the logo and style configurations.D、 Add the resource as a ResourceDictionary in the MergedDictionaries collection of each application.E、 Use ResourceManager to read the content of the resource. Manually assign the style configurations included in the resource file to the appropriate control in each application.

更多“单选题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 Rea”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    You deploy more than one application to the same WebLogic container. The security is set on JavaEE level and all deployed JavaEE applications use the same security roles.    What is your recommendation for an architecture with those requirement?（）

    • A、Combine all applications into a single one.
    • B、Define global roles on the WebLogic Domain level.
    • C、Use Ms Active Directory to keep the roles there. 
    • D、Use Oracle Identity and Access Management solution to simplify the management.
    • E、Keep role mapping in the external WebLogic Role Mapped developed for that solution.

    正确答案:B

  • 第5题：

    You need to resolve the blocking issue that is affecting the performance of the CRM system. What should you do?（）

    • A、Replace the named query with an SQL view.
    • B、Set the transaction isolation level to serializable in the named query.
    • C、Set the source database to use snapshot isolation.
    • D、Set the transaction isolation level to repeatable read in the named query.

    正确答案:C

  • 第6题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（）  

    • A、You should configure the database for Read Committed Snapshot isolation. 
    • B、You should modify the stored procedure to use the Snapshot isolation level 
    • C、You should configure the database for Auto Update Statistics asynchronously 
    • D、You should modify the stored procedure to use the Repeatable Read isolation level

    正确答案:B

  • 第7题：

    多选题
    A common approach to solve application performance issues is to add more hardware. Which two  reasons describe why this alone does not always solve performance problems?（）
    A

    There may be a bottleneck in the application that additional hardware would not solve.

    B

    Adding more hardware is costly and time consuming.

    C

    Adding hardware at the application layer may place additional load on an already overloaded database, network appliance, or storage system.

    D

    Adding more hardware may introduce new configuration requirements that need to be tested.


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

  • 第8题：

    单选题
    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（）
    A

    You should configure the database for Read Committed Snapshot isolation. 

    B

    You should modify the stored procedure to use the Snapshot isolation level 

    C

    You should configure the database for Auto Update Statistics asynchronously 

    D

    You should modify the stored procedure to use the Repeatable Read isolation level


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

  • 第9题：

    多选题
    You create Microsoft Windows-based applications.  You create an application that requires users to be authenticated by a domain controller.  The application contains a series of processor intensive method calls that require different database connections. A bug is reported during testing.  The bug description states that the application hangs during one of the processor-intensive calls more than 50 percent of the times when the method is executed.  Your unit test for the same method was successful.You need to reproduce the bug.   Which two factors should you ascertain from the tester？（）
    A

    Security credentials of the logged on user

    B

    Code access security settings

    C

    Hardware settings

    D

    Network settings

    E

    Database settings


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

  • 第10题：

    单选题
    You deploy more than one application to the same WebLogic container. The security is set on JavaEE level and all deployed JavaEE applications use the same security roles.    What is your recommendation for an architecture with those requirement?（）
    A

    Combine all applications into a single one.

    B

    Define global roles on the WebLogic Domain level.

    C

    Use Ms Active Directory to keep the roles there. 

    D

    Use Oracle Identity and Access Management solution to simplify the management.

    E

    Keep role mapping in the external WebLogic Role Mapped developed for that solution.


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

  • 第11题：

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

  • 第12题：

    单选题
    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.


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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    A common approach to solve application performance issues is to add more hardware. Which two  reasons describe why this alone does not always solve performance problems?（）

    • A、There may be a bottleneck in the application that additional hardware would not solve.
    • B、Adding more hardware is costly and time consuming.
    • C、Adding hardware at the application layer may place additional load on an already overloaded database, network appliance, or storage system.
    • D、Adding more hardware may introduce new configuration requirements that need to be tested.

    正确答案:A,C

  • 第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题：

    You create Microsoft Windows-based applications.  You create an application that requires users to be authenticated by a domain controller.  The application contains a series of processor intensive method calls that require different database connections. A bug is reported during testing.  The bug description states that the application hangs during one of the processor-intensive calls more than 50 percent of the times when the method is executed.  Your unit test for the same method was successful.You need to reproduce the bug.   Which two factors should you ascertain from the tester？（）

    • A、 Security credentials of the logged on user
    • B、 Code access security settings
    • C、 Hardware settings
    • D、 Network settings
    • E、 Database settings

    正确答案:D,E

  • 第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题：

    单选题
    You need to resolve the blocking issue that is affecting the performance of the CRM system. What should you do?（）
    A

    Replace the named query with an SQL view.

    B

    Set the transaction isolation level to serializable in the named query.

    C

    Set the source database to use snapshot isolation.

    D

    Set the transaction isolation level to repeatable read in the named query.


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

  • 第21题：

    单选题
    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 size

    B

     N times the VMM minfree parameter

    C

     The same value as that of the VMM maxfree parameter

    D

     The same value as that of  the VMM maxrndwrt parameter


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

  • 第22题：

    多选题
    You use Microsoft .NET Framework 4 to create a custom Windows Presentation Foundation (WPF) application. Your environment includes several WPF applications. The applications use the same logo and style configuration as part of a corporate standard. You need to ensure that the existing applications can be updated to use the same logo and style settings without recompiling. Which two actions should you perform?（）
    A

     Mark the resource as an embedded resource in each application. 

    B

     Create a resource in an XAML file that contains the logo and style configurations.

    C

     Create a resource in a custom control that contains the logo and style configurations.

    D

     Add the resource as a ResourceDictionary in the MergedDictionaries collection of each application.

    E

     Use ResourceManager to read the content of the resource. Manually assign the style configurations included in the resource file to the appropriate control in each application.


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

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

相关内容