Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Explain the ACID properties of a transaction
Ans: ACID properties are a significant concept for databases. The ACID stands for Atomicity, Consistency, Isolation, and Durability.
Atomicity: Atomicity means either all operations of transaction are reflected properly in the database or none are.
Consistency: Consistency means execution of a transaction in isolation (that is with no other transaction executing concurrently) preserves the consistency of the database
Isolation: Although multiple transactions may execute concurrently the system assures that for each pair of transaction Ti and Tj, it appears to Ti that either Tj that either Tj finished execution previous to Ti started or Tj started execution after Ti finished. So each transaction is unaware of other transactions executing simultaneously in the system.
Durability: later than a transaction completes successfully, the changes it has made to the database persist, even if there are system failures.
difference between internal schema and external schema in DBMS
Which is a legal expression in SQL? SELECT NAME FROM EMPLOYEE is a legal expression in SQL.
Explain the terms primary key, candidate key, alternate key and secondary key. In the given table identify every key? STUDENT(SID,Regno, Name, City) Primary Key: The prim
The traffic data mgmt. systems infrastructure plan describes the software, hardware, data network, and other elements that will support the TDMS. The infrastructure plan is based o
Question 1 Discuss about second normal form and third normal form Question 2 Write short note on 1) Data Manipulation Language 2) Data Definition La
Explain weak and strong entity type ? Weak and Strong entity type: An entity set which does not have a primary key is referred to as a weak entity set. The existence of a wea
wh
What type of view of total database content? Data base content Conceptual view of total database contain.
Describe the difference between a one-to-many and a many-to-many relationship. Which logical data structures comprise one-to-many and which comprise many-to-many relationship?
The Transactions- A transaction is definite as the unit of work in a database system. Database systems that deal with a huge number of transactions are also termed as transaction p
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd