Consistency error-database errors, Database Management System

Consistency error: These errors happen due to the inconsistent state of database caused may be due to wrong implementation of commands or in case of a transaction abort.  To overcome these errors the database system should contain routines that check for the consistency of data entered in the database.

 

Posted Date: 3/12/2013 3:40:48 AM | Location : United States







Related Discussions:- Consistency error-database errors, Assignment Help, Ask Question on Consistency error-database errors, Get Answer, Expert's Help, Consistency error-database errors Discussions

Write discussion on Consistency error-database errors
Your posts are moderated
Related Questions
What is deadlock? Neither of the transaction can ever proceed with its normal implementation. This situation is known as deadlock.

What is an index? An index is a structure that helps to place desired records of a relation quickly, without probing all records.

Explain entity integrity and referential integrity rules within relational model. Show how these are realized in SQL? Entity Integrity Rule - No primary key value could be nu

NEED ER DIAGRAM WITH MINIMUM ENTITY AND RELATIONSHIP of Hospital Management System

How to Insert data in your table from another table? insert into e.g, To insert tuples from employee into N_emp created above, use following statement Insert into N_emp

It defines that no primary key value can be null. This is as the primary key is used to recognize individual tuple in the relation. So we will not be able to recognize the records

Define the concept of aggregation.  Give two examples where this concept is useful. Ans: Aggregation transforms a relationship among the objects into a higher-level object. A

Define and differentiate between ordered indexing and hashing. Ans: Ordered indexing: To gain fast random access to records in a file, we can make of an index structure. Every

Which is a valid SQL type? A valid SQL Should be in CHARACTER it is should be NUMERIC and FLOAT.

Designing the fields in the data base The following are the considerations one has to remain in mind while designing the fields in the data base. Coding, compression, en