Answer Posted / Mr Sumant Kumar
Data consistency refers to ensuring that all data in a database is accurate, reliable, and up-to-date. Some general rules for maintaining data consistency include:
1. Atomicity: Each transaction should be treated as an indivisible unit of work; it either completes entirely or does not complete at all.
2. Consistency: The database must be in a consistent state before and after each transaction, adhering to defined business rules.
3. Isolation: Concurrent transactions do not interfere with one another's execution, ensuring that the results of individual transactions are independent.
4. Durability: Once committed, a transaction should remain committed even in case of hardware failure or power loss.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to select all columns of all rows from a table in oracle?
What is oracle latest version?
How to write a left outer join with the where clause in oracle?
Design database draw er diagram for a certain scenario ?
How to use values from other tables in update statements using oracle?
How to put more than 1000 values into an oracle in clause?
How to start an oracle instance?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
