单选题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.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
Examine the following command used to perform incremental level 0 backup:RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE;To enable the block change tracking, after the incremental level 0 backup you issued the following command:SQL ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USINGFILE ‘/mydir/rman_change_track.f‘;To perform incremental level 1 cumulative backup, you issued the following command:RMAN BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which two statements are true in the above situation?（）A. The block change tracking data will be used only from the next incremental 0 backup.B. The incremental backup will use change tracking data for accomplishing the backup.C. The incremental backup will not use change tracking data for accomplishing the backup.D. The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.
Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?() A.ViewB.AliasC.TableD.Package
Which of the following is TRUE according to the text？( ) A.The principle of gene therapy is applicable to that of cloning B.The isolation of stem cells is too difficult to be feasible C.It is reasonable for all body instructions to be activated D.Cloned animals will eventually take control of the world
Which of the following is TRUE according to the text？( ) A.The principle of gene therapy is applicable to that of cloning. B.The isolation of stem cells is too difficult to be feasible. C.It is reasonable for all body instructions to be activated. D.Cloned animals will eventually take control of the world.
Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?（）A、The next value will be 0 and the sequence will never use the values 101 to 105.B、The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.C、Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.D、The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.
A site administrator is configuring Resource-level access control. Which of the following statements about Resource-level access control are true？ Resource-level access control policies：（）A、are optionalB、are used to protect data beansC、provide coarse-grained access controlD、never specify a relationship
Which of the following BIOS level settings allow an administrator to view warnings on possiblehardware level changes?（）A、Drive lockB、Intrusion detectionC、BIOS passwordD、Trusted platform module
Which of the following can transmit block level storage over Ethernet？（）A、SASB、iSCSIC、USBD、SATA
Which ONE of the following statements about Domino Enterprise server is true？（）A、Can host Active Server Pages Web sitesB、Can host PHP Web sitesC、Includes a DB2 serverD、Includes an integrated Web application server
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 the lowest cost DB2 product that can be legally installed on an AIX server?（）A、DB2 Express EditionB、DB2 Personal EditionC、DB2 Workgroup Server EditionD、DB2 Enterprise Server Edition
A site administrator is configuring Command-level access control. Which of the following statements about Command-level access control are true？ Command level access control policies： （）A、are mandatoryB、specify action group ExecuteCommandActionGroup for Controller commandsC、specify action group ViewCommandActionGroup for View commandsD、specify resource group ControllerCommandResourceGroup for Controller commandsE、specify resource group ViewCommandResourceGroup for View commands
Which of the following DB2 products are required on an iSeries or System i server to enable an application running on that server to retrieve data from a DB2 database on a Linux server?（）A、DB2 for i5/OSB、DB2 Runtime ClientC、DB2 Connect Enterprise EditionD、DB2 for i5/OS SQL Development Kit
A System p administrator has just installed a new technology level， but "oslevel -r" does not show the expected technology level. Which of the following commands would determine which filesets are downlevel（）A、lppchkB、instfixC、oslevelD、installp
Which of the following is the lowest cost DB2 product that can be legally installed on a Linux server that has 6 CPUs?（）A、DB2 Express EditionB、DB2 Personal EditionC、DB2 Workgroup Server EditionD、DB2 Enterprise Server Edition
Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?（）A、ViewB、AliasC、TableD、Package
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.
Which of the following describes the objects of a DB2 database and their relationships?（）A、InstanceB、Table spaceC、System catalogD、Schema repository
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.
单选题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 tools can make recommendations for indexes and/or MQTs to improve the performance of DB2 applications?（）ADesign AdvisorBVisual ExplainCPerformance AdvisorDConfiguration Assistant
单选题Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?（）AThe next value will be 0 and the sequence will never use the values 101 to 105.BThe next value will be 101 to ensure uniqueness between existing and newly generated sequence values.CPreviously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.DThe next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.
多选题A site administrator is configuring Resource-level access control. Which of the following statements about Resource-level access control are true？ Resource-level access control policies：（）Aare optionalBare used to protect data beansCprovide coarse-grained access controlDnever specify a relationship
单选题You enable block change tracking. You issue the following command： BACKUP INCREMENTAL LEVEL 0 DATABASE； The next day，you issue the following command： BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE； Which statement about the use of the change tracking file is true？（）A RMAN reads the block change tracking file only when it performs the incremental level 0 backup.B RMAN reads the block change tracking file when it performs both incremental backups.C RMAN reads the block change tracking file only when it performs the incremental level 1 backup.D RMAN does not read the block change tracking file when it performs either incremental backup.
单选题You are passing the Bayou Sara gage which reads 3.9 feet. Which of the following statements is TRUE?（）AThe river level is above the Low Water Reference PlaneBRed Store Landing Revetment is ahead on your starboard sideCThis gage reading is at a lower elevation than the same reading on the gage at Head of PassesDNone of the above