What is the purpose of “degree-two consistency”? Select one: a. To avoid cascading aborts without necessarily ensuring serializability. b. To avoid serializable aborts without necessarily ensuring a cascade. c. To avoid aborting cascades without serializing ensurability. d. To abort cascading avoidances without ensuring serializability. e. To ensure cascading aborts without avoiding serializability

What does the term "degree 3 consistency" ensure in a transaction?Question 24Select one:A.Transaction T does not read dirty data from other transactions.B.Other transactions do not dirty any data read by T before T completes.C.Transaction T does not overwrite dirty data of other transactions.D.Transaction T does not commit any writes until it completes all its writes.E.All the choices apply

_____ is the consistency of a measurement whereas _____ is the degree to which a test accurately measures what it purports to measure.Multiple ChoiceIntepretation; replicationReliability; validityValidity; reliabilityReplication; interpretation

What type of consistency level prevents all three phenomena: dirty read, non-repeatable read, and phantom read?Question 5Select one:A.Read CommittedB.Repeatable ReadC.Read UncommittedD.SerializableE.Snapshot Isolation

ERIALIZABILITY IN DBMS Some non-serial schedules may lead to inconsistency of the database. Serializability is a concept that helps to identify which non-serial schedules are correct andwill maintain the consistency of the database

For the consistency property of database transactions, it requires that the state of a database is consistent before and after each transaction, but the intermediate states of a database during a transaction do not need to be consistent.