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.
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.
相关考题：
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
oracle数据库中下列哪个等待事件显示行级锁竞争?() A.latch：shared poolB.cursor：pin S waiton XC.enq：TX-row lock contentionD.dbfile scattered read
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.
oracle数据库中下列哪个等待事件显示行级锁竞争？（）A、latch：shared poolB、cursor：pin S waiton XC、enq：TX-row lock contentionD、dbfile scattered read
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.
Which of the following is NOT a way in which Custom Controls can be used？（）A、As reusable UI assetsB、As a way to share some layoutC、Shared through templates （NTF） just like any other design elementD、As the runtime for anXPage application
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
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.
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)
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 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.
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 UPDATABLEB、Define the column MAINID as a PRIMARY KEYC、Define the column MAINID as a FOREIGN KEYD、Define an UPDATE trigger on table TABLEX
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
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 updatedB、null lock on the table containing the rowC、ROW SHARE lock for the row being updatedD、ROW EXCLUSIVE lock for the row being updatedE、shared row-exclusive lock for the row being updatedF、a shareable table lock for the table containing the rowG、exclusive table-level lock for the table containing the row
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
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
单选题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?（）AApplications A and B will cause a deadlock situationBApplication B will read the previous version of the rowCApplication B will read the row and see uncommitted changes made by application ADApplication B will be placed in a lock-wait state until application A releases its lock
单选题Which of the following is NOT true about the Hawthorne study?AIt was the first documented evidence of the psychological effects on doing work.BThe Hawthorne study continued for five years.CThey found that the workers responded not to the level of lighting but to the fact that other work conditions were not favorable.DThe study changed the focus from economics to a multifaceted approach.
单选题What is true regarding InnoDB locking?（）AInnoDB uses row and table-level locks, but row locks are not escalatesBInnoDB locks only those rows that are updatedCInnoDB only uses row locks, not page or table-level locksDInnoDB row locks may be escalated to page or table-level locksEInnoDB uses row-level or table-level locks depending on the number of rows affected
多选题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？（）Anull lock on the row being updatedBnull lock on the table containing the rowCROW SHARE lock for the row being updatedDROW EXCLUSIVE lock for the row being updatedEshared row-exclusive lock for the row being updatedFa shareable table lock for the table containing the rowGexclusive table-level lock for the table containing the row
单选题Which statement is true regarding subqueries?（）AThe LIKE operator cannot be used with single-row subqueries BThe 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 DThe NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries
单选题Which of the following is NOT a way in which Custom Controls can be used？（）AAs reusable UI assetsBAs a way to share some layoutCShared through templates （NTF） just like any other design elementDAs the runtime for anXPage application
单选题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.
单选题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?（）ARead Stability (RS)BRepeatable Read (RR)CUncommitted Read (UR)DCursor Stability (CS)
单选题Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?（）AAn application process acquires at least a share lock on the current row of every cursor.BAny row that is read during a unit of work cannot be changed by other application processes until the unit of work is complete.CAny row changed by another application process can be read, even if the change has not been committed by that application process.DAn 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.
单选题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?（）AApplication B will read the row.BApplications A and B will cause a deadlock situation.CApplication B will wait until application A releases the Update lock.DApplication A will be terminated so that application B can read the row.
单选题Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?（）AThe cursor is only protected from updates and deletes by concurrent applications.BThe row is only protected from positioned updates and deletes that reference another cursor of the same application.CThe cursor is protected from positioned updates and deletes that reference another cursor of a different application.DThe 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.