PyQdeck LogoPyQdeckSubjects
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

Similar questions

Database Management SystemWhat do you mean by concurrent execution and serializability in database system?20187mDATABASE MANAGEMENT SYSTEMShow that the two-phase locking protocol ensures conflict serializability and that transaction can be serialized according to their lock points.202114mDATABASE MANAGEMENT SYSTEMExplain two-phase locking protocol & conflict serializability. | Unit 3 – Transaction Management | Concurrency control.20247mDatabase 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 serial20252m
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