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

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

相似考题

1.What is true regarding InnoDB locking?()A.InnoDB uses row and table-level locks, but row locks are not escalatesB.InnoDB locks only those rows that are updatedC.InnoDB only uses row locks, not page or table-level locksD.InnoDB row locks may be escalated to page or table-level locksE.InnoDB uses row-level or table-level locks depending on the number of rows affected

2.Which of the following is NOT what Hegel believed?A. The content and form of the work of art cannot be separated from each other. B. The content of the work of art is always the true object of aesthetic interest. C. The content presented without any individuality is not the content of the work of art. D. The content understood by means of a process of discursive thought is no more than a husk.

3.oracle数据库中下列哪个等待事件显示行级锁竞争？（）A、latch：shared poolB、cursor：pin S waiton XC、enq：TX-row lock contentionD、dbfile scattered read

4.oracle数据库中下列哪个等待事件显示行级锁竞争?()A.latch：shared poolB.cursor：pin S waiton XC.enq：TX-row lock contentionD.dbfile scattered read

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

  • 第1题：

    Which of the following is NOT a way in which Custom Controls can be used？（）

    • A、As reusable UI assets
    • B、As a way to share some layout
    • C、Shared through templates （NTF） just like any other design element
    • D、As the runtime for anXPage application

    正确答案:D

  • 第2题：

    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

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

    User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）

    • A、null lock on the row being updated
    • B、null lock on the table containing the row
    • C、ROW SHARE lock for the row being updated
    • D、ROW EXCLUSIVE lock for the row being updated
    • E、shared row-exclusive lock for the row being updated
    • F、a shareable table lock for the table containing the row
    • G、exclusive table-level lock for the table containing the row

    正确答案:D,F

  • 第6题：

    Which two statements are true regarding single row functions?（）

    • A、They accept only a single argument 
    • B、They can be nested only to two levels 
    • C、Arguments can only be column values or constants 
    • D、They always return a single result row for every row of a queried table 
    • E、They can return a data type value different from the one that is referenced

    正确答案:D,E

  • 第7题：

    单选题
    Which of the following is NOT true about the Hawthorne study?
    A

    It was the first documented evidence of the psychological effects on doing work.

    B

    The Hawthorne study continued for five years.

    C

    They found that the workers responded not to the level of lighting but to the fact that other work conditions were not favorable.

    D

    The study changed the focus from economics to a multifaceted approach.


    正确答案： B
    解析：
    本题是是非题。第二段第二句提到选项A的内容、第二段第三句提到选项B的内容、第三段最后一句提到选项D的内容，这三项都是涉及霍桑效应的内容，只有选项C在文中没有提及，因此答案为C。

  • 第8题：

    多选题
    User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）
    A

    null lock on the row being updated

    B

    null lock on the table containing the row

    C

    ROW SHARE lock for the row being updated

    D

    ROW EXCLUSIVE lock for the row being updated

    E

    shared row-exclusive lock for the row being updated

    F

    a shareable table lock for the table containing the row

    G

    exclusive table-level lock for the table containing the row


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

  • 第9题：

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

  • 第10题：

    单选题
    Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?（）
    A

    Define the column MAINID as NOT UPDATABLE

    B

    Define the column MAINID as a PRIMARY KEY

    C

    Define the column MAINID as a FOREIGN KEY

    D

    Define an UPDATE trigger on table TABLEX


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

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

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

    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

  • 第14题：

    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

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

    What is true regarding InnoDB locking?（）

    • A、InnoDB uses row and table-level locks, but row locks are not escalates
    • B、InnoDB locks only those rows that are updated
    • C、InnoDB only uses row locks, not page or table-level locks
    • D、InnoDB row locks may be escalated to page or table-level locks
    • E、InnoDB uses row-level or table-level locks depending on the number of rows affected

    正确答案:B

  • 第17题：

    Which statement is true regarding subqueries?（）

    • A、The LIKE operator cannot be used with single-row subqueries 
    • B、The NOT IN operator is equivalent to IS NULL with single-row subqueries 
    • C、=ANY and =ALL operators have the same functionality in multiple-row subqueries 
    • D、The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries 

    正确答案:D

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

    单选题
    What is true regarding InnoDB locking?（）
    A

    InnoDB uses row and table-level locks, but row locks are not escalates

    B

    InnoDB locks only those rows that are updated

    C

    InnoDB only uses row locks, not page or table-level locks

    D

    InnoDB row locks may be escalated to page or table-level locks

    E

    InnoDB uses row-level or table-level locks depending on the number of rows affected


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

  • 第20题：

    单选题
    Which statement is true regarding subqueries?（）
    A

    The LIKE operator cannot be used with single-row subqueries 

    B

    The NOT IN operator is equivalent to IS NULL with single-row subqueries 

    C

    =ANY and =ALL operators have the same functionality in multiple-row subqueries 

    D

    The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries 


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

  • 第21题：

    单选题
    Which of the following is NOT a way in which Custom Controls can be used？（）
    A

    As reusable UI assets

    B

    As a way to share some layout

    C

    Shared through templates （NTF） just like any other design element

    D

    As the runtime for anXPage application


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

  • 第22题：

    单选题
    Evaluate the following statement：   Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement？（）
    A

     They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.

    B

     They are evaluated by the first WHEN clause. If the condition is true， then the row would be evaluated by the subsequent WHEN clauses.

    C

     They are evaluated by the first WHEN clause. If the condition is false， then the row would be evaluated by the subsequent WHEN clauses.

    D

     The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.


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

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

  • 第24题：

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

相关内容