What are the general rules on data consistency?
- 1 Answers
- 1092 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
what is the dual table in oracle?
What are a query and state the different types of queries and their uses?
what is trigger?
what is the difference between no rows returned and null returned?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Can you drop an index associated with a unique or primary key constraint?
how to retrieve data from different tables ,place this data in different excel worksheets.
How to get execution statistics reports on query statements?
find out the second highest salary?
55 Answers Cognizant, Nucsoft, Oracle, TCS, Wondersoft,
What are the different editions of oracle?
What happens if recursive calls get out of control?
Oracle General 
