DB2-UDB-V7-1-Family-Fundamentals-(000-512).pdf - IBM 000-512 DB2 UDB V7.1 Family Fundamentals http\/killexams.com\/exam-detail\/000-512 Answer E QUESTION

DB2-UDB-V7-1-Family-Fundamentals-(000-512).pdf - IBM...

This preview shows page 1 - 4 out of 7 pages.

000-512 IBM DB2 UDB V7.1 Family Fundamentals
Image of page 1
Answer: E QUESTION:98 Given the following: A table containing a list of all seats on an airplane. A seat consists of a seat number and whether or not it is assigned. An airline agent lists all the unassigned seats on the plane. When the agent refreshes the list from the table, it should only change if another agent unassigns a currently assigned seat. Which of the following isolation levels should be used for this application? A. Read stability B. Repeatable read C. Cursor stability D. Uncommitted read Answer:A QUESTION:99 Which of the following isolation levels will lock only the rows returned in the result set? QUESTION:100 Given the following table with a primary key on empid: Give the following statement in an embedded SQL program bound with Repeatable Read: Select * from Emp where empid < 55 40
Image of page 2
Image of page 3
Image of page 4

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture