answersLogoWhite

0

In SQL data consistency is that whenever a transaction is performed, it sees a consistent database. During the transaction, if the database is not consistent, then there are two reasons for it, which are as follows:

1-database failure (software or hardware failure)

2-multiple accesses

data consistency makes sure data integrity and vice versa.

:)

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What is meant by data consistency in DBMS?

sdfsfas


Consistency constraints in dbms?

it describes the instance of one entity is associated with each instances of an entity depending upon the range of cardinality constraints are two types they are minimum cardinality maximum cardinality


What are highlights of DBMS?

NA_ what are highlights of advanced DBMS what are highlights of advanced DBMS what are highlights of advanced DBMS


Is java DBMS?

no, Java is not dbms.. Java is a programming language Dbms is database


Is SQL DBMS or RDBMS?

dbms


What is concurrent schedule in dbms?

A concurrent schedule in DBMS refers to multiple transactions running concurrently without interfering with each other. This allows for improved performance and efficiency in handling multiple operations simultaneously. However, it requires careful management to ensure data consistency and avoid conflicts such as race conditions.


What are three types of dbms?

Hierarchical DBMSNetwork DBMSRelational DBMS


What are rows in dbms?

In DBMS the data is stored in the form of table . Each row in DBMS is known as tuple.


What are the importance of dbms in industrial environment?

importance of DBMS


What is the purpose of dbms?

What is the purpose of dbms?DBMS is a software that organises the creation, storage and maintenance of Databases for end users.


How DBMS overcomeTFBS?

DBMS (Database Management Systems) typically overcome TFBS (Transaction Failure Before System) by using transaction management techniques such as ACID properties (Atomicity, Consistency, Isolation, Durability). These ensure that transactions are either fully completed or reverted to their original state in case of failure, maintaining data integrity. Additionally, DBMS often implement logging and recovery mechanisms to help recover the database state in case of unexpected failures.


When was Polyhedra DBMS created?

Polyhedra DBMS was created in 1993.