Menu
support@nursinghomework.org
+1 714-215-3097

(Solved) : True False User Interaction Usually Avoided Database Transaction User May Take Unpredictab Q35569327

  1. True or False: User interaction is usually avoided during adatabase transaction because the user may take an unpredictablylong time to complete their actions.
  2. Which term(s) below describe this schedule and its dependencygraph:

QJKRXyiUyhjkdYHkhWTQRVgNBu3qEtvlOICr7Gpq

  1. Serializable
  2. Non-serializable
  3. Acyclic
  4. Both a. and c.
  1. Which statement below accurately describes this schedule:

T1

T2

T3

T4

Read(A)

Read(B)

Write(A)

Read(A)

Write(A)

Read(A)

Read(B)

Read(B)

Abort

  1. All transactions in the schedule will need to be rolledback
  2. Transactions T1, T2 and T3 will need to be rolled back but T4will not need to be rolled back
  3. Transactions T1 and T2 will need to be rolled back but T3 andT4 will not need to be rolled back
  4. The schedule is noncascading (only the aborted T1 transactionneeds to be rolled back)

  1. Match the following terms with their best description:

Term

Matching Description

Descriptions

Read Committed

  1. Transactions are guaranteed to be serializable
  2. Only committed records to be read, repeated reads of samerecord must return same value.
  3. Only committed records can be read, but successive reads ofrecord may return different values
  4. Uncommitted records may be read

Read Uncommitted

Repeatable Read

Serializable

Leave a Reply

Your email address will not be published. Required fields are marked *