What isolation level prevents dirty reads, nonrepeatable reads, and phantoms、

试卷相关题目

• 1If no isolation level is specified, what is the default isolation level used、

  A.Cursor Stability (CS)

  B.Repeatable Read (RR)

  C.Read Stability (RS) with Currently Committed semantics

  D.Cursor Stability (CS) with Currently Committed semantics

  开始考试点击查看答案
• 2Application APP_A is performing updates to table TAB1 using the read stability (RS) isolation level. Which isolation level will allow application APP_B to retrieve all rows from table TAB1 immediately, rather than have to wait until application APP_A has finished making updates、

  A.Read Stability (RS)

  B.Cursor Stability (CS)

  C.Repeatable Read (RR)

  D.Uncommitted Read (UR)

  开始考试点击查看答案
• 3What factor influences lock conversion/promotion、

  A.Lock size

  B.Number of locks

  C.Lock mode needed

  D.Available real storage

  开始考试点击查看答案
• 4The EXCLUSIVE MODE option of the LOCK TABLE statement is used to prevent which of thefollowing、

  A.Concurrent application processes from performing any operations on the table.

  B.Concurrent application processes from performing any read-only operations on the table.

  C.Concurrent applications processes that are running under the cursor stability (CS) isolation level from performing read-only operations on thetable.

  D.Concurrent applications processes that are running under the uncommitted read (UR) isolation level from performing read-only operations onthe tabl

  开始考试点击查看答案
• 5When is an INTENT EXCLUSIVE (IX) lock required、

  A.When a transaction intends to read or change data.

  B.When a transaction intends to change but not read data.

  C.When a transaction intends to read but not change data.

  D.When a transaction intends to change the system catalog.

  开始考试点击查看答案