• About
    1. Asked: November 2, 2021In:

      Which three of the following are implicit cursor attributes?

      Professor
      Professor

      %Found %NOT FOUND %ROW COUNT %ISOPEN THESE ALL ARE IMPLICIT CURSOR

      %Found

      %NOT FOUND

      %ROW COUNT

      %ISOPEN

      THESE ALL ARE IMPLICIT CURSOR

      See less
    2. Asked: November 2, 2021In:

      Check whether the given schedules are conflict serializable or not S1 : R2(B)W2(A)R1(A)R3(A)W1(B)W2(B)W3(B) S2:R3(Y)W3(Z)R1(X)W1(X)W3(Y)W3(Z)R2(Z)R1(Y)W1(Y)R2(Y)W2(Y)

      Professor
      Professor

      CREATE AN ACCOUNT TO GET NOTIFICATIONS ABOUT NEW QUESTIONS AND ANSWERS.     DOWNLOAD ATTACHMENT FOR ANSWER:

      CREATE AN ACCOUNT TO GET NOTIFICATIONS ABOUT

      NEW QUESTIONS AND ANSWERS.

       

       

      DOWNLOAD ATTACHMENT FOR ANSWER:

      See less
      Attachment

    3. Asked: November 2, 2021In:

      Write a program to handle an exception using try, catch and throw.

      Professor
      Professor

      CREATE AN ACCOUNT TO GET NOTIFICATIONS ABOUT NEW QUESTIONS AND ANSWERS.     DOWNLOAD ATTACHMENT FOR ANSWER:

      CREATE AN ACCOUNT TO GET NOTIFICATIONS ABOUT

      NEW QUESTIONS AND ANSWERS.

       

       

      DOWNLOAD ATTACHMENT FOR ANSWER:

      See less
      Attachment

    4. Asked: November 2, 2021In:

      Consider the following two transactions: T31: Read(A) Read (B) if A=0 then B=B+1 Write (B) T32: Read(B) Read (A) if B=0 then A=A+1 Write (A) Add lock and unlock instructions to transactions T31 and T32 so that they observe the two phase protocol. Can the execution of these transaction results in a deadlock.

      Professor
      Professor

      CREATE AN ACCOUNT TO GET NOTIFICATIONS ABOUT NEW QUESTIONS AND ANSWERS.     DOWNLOAD ATTACHMENT FOR ANSWER:

      CREATE AN ACCOUNT TO GET NOTIFICATIONS ABOUT

      NEW QUESTIONS AND ANSWERS.

       

       

      DOWNLOAD ATTACHMENT FOR ANSWER:

      See less
      Attachment

    5. Asked: November 2, 2021In:

      Show that two-phase locking protocol ensures conflict serializability and that transactions can be serialized according to their lock points with suitable examples.

      Professor
      Professor

      CREATE AN ACCOUNT TO GET NOTIFICATIONS ABOUT NEW QUESTIONS AND ANSWERS.     DOWNLOAD ATTACHMENT FOR ANSWER:

      CREATE AN ACCOUNT TO GET NOTIFICATIONS ABOUT

      NEW QUESTIONS AND ANSWERS.

       

       

      DOWNLOAD ATTACHMENT FOR ANSWER:

      See less
      Attachment

    6. Asked: November 2, 2021In:

      Check whether Schedule is serial, serializable, Conflict serializable S:R2(Z),R2(Y),W2(Y),R3(Y),R3(Z),R1(X),W1(X),W3(Y)W3(Z)R2(X)R1(Y)W1(Y)

      Professor
      Professor

      CREATE AN ACCOUNT TO GET NOTIFICATIONS ABOUT NEW QUESTIONS AND ANSWERS.     DOWNLOAD ATTACHMENT FOR ANSWER:

      CREATE AN ACCOUNT TO GET NOTIFICATIONS ABOUT

      NEW QUESTIONS AND ANSWERS.

       

       

      DOWNLOAD ATTACHMENT FOR ANSWER:

      See less
      Attachment