Application A is running under the Repeatable Read isolation level and holds an

Application a is running under the repeatable read

This preview shows page 15 - 18 out of 19 pages.

83. Application A is running under the Repeatable Read isolation level and holds an Update lock on tableTAB1. Application B wants to query table TAB1 and cannot wait for Application A to release its lock.Which isolation level should Application B run under to achieve this objective? A. Uncommitted ReadB. Cursor StabilityC. Read StabilityD. Repeatable Read 84. Which of the following is an example of an entity in an Entity-Relationship Diagram? 85. Which of the following statements is syntactically incorrect? 86. Which of the following is true about the administration notification log? 87. If table TAB1 is created using the following statement:CREATE TABLE tab1 (col1 INTEGER NOT NULL,col2 CHAR(5),CONSTRAINT cst1 CHECK (col1 in (1, 2, 3)))Which of the following statements will successfully insert a record into table TAB1? A. INSERT INTO tab1 VALUES (0, 'abc')B. INSERT INTO tab1 VALUES (NULL, 'abc')C. INSERT INTO tab1 VALUES (ABS(2), 'abc')D. INSERT INTO tab1 VALUES (DEFAULT, 'abc') 88. Which of the following is true about DB2 load utility?
Background image
89. Assuming that the PORDER column contains the following XML data:<PurchaseOrder><item><partid>100-100-01</partid><name>Sled, Metal</name><quantity>1</quantity></item><item><partid>100-201-01</partid><name>Heater, Large</name><quantity>2</quantity></item><PurchaseOrder>What will be the new value of the PORDER column after executing the following statement?UPDATE purchaseorder SET porder =xmlquery('transformcopy $po := $ordermodify do insertdocument { <item><partid>100-103-01</partid><name>Snow Shovel, Super Deluxe 26 inch</name><quantity>4</quantity></item>}into $po/PurchaseOrderreturn $po'passing PURCHASEORDER.PORDER as "order")WHERE poid=5012;
Background image
Background image
Image of page 18

You've reached the end of your free preview.

Want to read all 19 pages?

  • Summer '19
  • d., Relational model

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture