PyQdeck LogoPyQdeckSubjectsSyllabusBlog
Back to the 2023 paper

Unit 3: Storage and Transaction Processing

20232m

Serializability of concurrent transaction is ensured by

  • (i) locking
  • (ii) time stamping
  • (iii) both (a) and (b)
  • (iv) none of these
Search GoogleAsk AI
Worked SolutionAI Assisted

Answer: (iii) both (a) and (b)

Explanation: Serializability (conflict or view) can be ensured by both locking protocols (2PL, strict 2PL) and timestamp ordering protocols. Locking prevents conflicting operations via locks; timestamping orders transactions by timestamps. Either mechanism or hybrid can guarantee serializability. Option checks "both locking and time stamping" as valid concurrency control methods.

Similar questions

Database Management SystemUnder strict two-phase locking: (i) Exclusive locks are held until commit/abort (ii) Deadlocks are impossible (iii) Locks can be released anytime (iv) Transactions become serial20252mDatabase Management SystemIn ACID properties, which component ensures that once a transaction is committed, it remains so? (i) Atomicity (ii) Durability (iii) Isolation (iv) Consistency20242mDatabase Management SystemWhich of the following is a concurrency control protocol. (i) Strict 2-phase locking protocol (ii) Timestamp based protocol (iii) Graph based protocol (iv) All of the above20222mDATABASE MANAGEMENT SYSTEMShow that the two-phase locking protocol ensures conflict serializability and that transaction can be serialized according to their lock points.202114m
PreviousA normal form in which every non-prime attribute is fully dependent on prime attribute is - (i) 1 NF - (ii) 2 NF - (iii) 3 NF - (iv) BCNFNextWhich key cannot be null - (i) Unique key - (ii) Primary key - (iii) Super key - (iv) Foreign key
Free AppAndroid App

Coursify Android App

Generate AI courses, take quick quizzes between classes, and master complex engineering concepts on the go.

Install Coursify