Fundamental Rights |  UNESCO Intengible Cultural Heritage From India |  Corruption |  Insectivorous Plants |  Causes of Revolt of 1857 in Points |  Ordinance Making Power of President and Governors |  Mangroves Cover in India |  Coral Reefs in India |  Seasons and Climate in India |  Constitutional and Statutory Bodies in India |  Rock Edicts of Ashoka |  Types of Motions in Parliamentary Procedure |  Types of Majorities in Parliament |  Pressure Groups in World and India |  Order of Precedence |  Types of Rocks |  Treaties in Indian History |  Types of Rocks |  Features of Indian Economy |  Geographical Indications |  Ancient History Terminology and Meanings |  Schedules of the Constitution |  Nuclear Power Plants in India List  |  Types of Clouds for SSC CGL | Nuclear Power Plants in India ListTypes of Ocean CurrentsStructure: Layers of EarthAPPSC Group 1 Answer KeySSC JE 2017 QUESTION PAPEROne Word Substitution for SSC and Bank ExamsMPSC Answer Key 2017 2017Layers of AtmosphereMPSC Answer Key 2017 2017BPSC Solved Question Paper 2017MPPSC Solved Question Paper 2017GST Bill IndiaDelhi SultanateLaw Commission of IndiaOscar Awards Winner 2017 ListDiseases in CropsCommon Drugs and UsesDifferent Types of Deserts in WorldUPSC Civil Services Exam-2016 Answer KeyUPSC CAPF Exam-2016 Answer Key | UPPSC UPPER Subordinate Exam-2016 Answer Key | Regulatory BodiesNational Parks in India | International Airports in India  | United Nation International Years National Highways | National Birds of Countries | 
Types of Speciation |  Unisexual and Bisexual Flowers |  DISANET |  National Child Labour Project Scheme |  Tropical Deciduous Forest |  Hoolock Gibbon: National Parks |  Sectors of Indian Economy |  How Legislative Council is Formed |  Insectivorous Plants |  Causes of Revolt of 1857 in Points |  Ordinance Making Power of President and Governors |  Mangroves Cover in India |  Coral Reefs in India |  Seasons and Climate in India |  Constitutional and Statutory Bodies in India |  Rock Edicts of Ashoka |  Types of Motions in Parliamentary Procedure |  Types of Majorities in Parliament |  Pressure Groups in World and India |  Order of Precedence |  Types of Rocks |  Treaties in Indian History |  Types of Rocks |  Features of Indian Economy |  Geographical Indications |  Ancient History Terminology and Meanings |  Schedules of the Constitution |  Nuclear Power Plants in India List  |  Types of Clouds for SSC CGL | Nuclear Power Plants in India ListTypes of Ocean CurrentsStructure: Layers of EarthAPPSC Group 1 Answer KeySSC JE 2017 QUESTION PAPEROne Word Substitution for SSC and Bank ExamsMPSC Answer Key 2017 2017Layers of AtmosphereMPSC Answer Key 2017 2017BPSC Solved Question Paper 2017MPPSC Solved Question Paper 2017GST Bill IndiaDelhi SultanateLaw Commission of IndiaOscar Awards Winner 2017 ListDiseases in CropsCommon Drugs and UsesDifferent Types of Deserts in WorldUPSC Civil Services Exam-2016 Answer KeyUPSC CAPF Exam-2016 Answer Key | UPPSC UPPER Subordinate Exam-2016 Answer Key | Regulatory BodiesNational Parks in India |
Animals and their Baby Names |  Veto Power of President & Types of Veto |  Ordinance Making Power of President and Governors |  Mangroves Cover in India |  Coral Reefs in India |  Seasons and Climate in India |  Constitutional and Statutory Bodies in India |  Rock Edicts of Ashoka |  Types of Motions in Parliamentary Procedure |  Types of Majorities in Parliament |  Pressure Groups in World and India |  Order of Precedence |  Types of Rocks |  Treaties in Indian History |  Types of Rocks |  Features of Indian Economy |  Geographical Indications |  Ancient History Terminology and Meanings |  Schedules of the Constitution |  Nuclear Power Plants in India List  |  Types of Clouds for SSC CGL | Nuclear Power Plants in India ListTypes of Ocean CurrentsStructure: Layers of EarthAPPSC Group 1 Answer KeySSC JE 2017 QUESTION PAPEROne Word Substitution for SSC and Bank ExamsMPSC Answer Key 2017 2017Layers of AtmosphereMPSC Answer Key 2017 2017BPSC Solved Question Paper 2017MPPSC Solved Question Paper 2017GST Bill IndiaDelhi SultanateLaw Commission of IndiaOscar Awards Winner 2017 ListDiseases in CropsCommon Drugs and UsesDifferent Types of Deserts in World

Tuesday, 12 December 2017

Which of the following is not a proper state of transaction?

  By GK Planet Team       Tuesday, 12 December 2017

Which of the following is not a proper state of a transaction?

A. Partially Aborted
B. Partially Committed
C. Aborted
D. Committed
Answer: A. Partially Aborted

A transaction is a collection of instructions (or operations) that perform a single logical function.
  1. A transaction is a very small unit of a program and it may contain several low-level tasks.
  2. A transaction in a database system must maintain Atomicity, Consistency, Isolation, and Durability − commonly known as ACID properties − in order to ensure accuracy, completeness, and data integrity.
Commit/Abort
  • A commit is a final step in the successful completion of a previously started database change as part of handling a transaction in a computing system.
  • Until commit, all the individual operations that make up the transaction are pending
  • At any point, before the transaction is committed, it might also be aborted
  • If a transaction is aborted, the system will undo or rollback the effects of any individual operations which have completed.
  • If an transaction is performed in a database and committed, the changes cannot take to the previous state of transaction.
The transaction states are abort, active, committed, partially committed, Failed.
Partially Committed
  • When a transaction executes its final operation, it is said to be in a partially committed state.

Failed
  • A transaction is said to be in a failed state if any of the checks made by the database recovery system fails.
logoblog

Thanks for reading Which of the following is not a proper state of transaction?

←Previous
« Prev Post
Next→
Next Post »

No comments:

Post a Comment

What you have to say about this?

Recent Posts ⌚

Google+ Followers

Video Lectures