Scenario: A banking system stores customer information and transaction records. How would you ensure data integrity in such a system?
- Allowing NULL values in critical fields
- Encrypting the data during transmission
- Implementing referential integrity constraints
- Regular database backups
Ensuring data integrity in a banking system involves implementing referential integrity constraints. This ensures that relationships between tables are maintained, preventing orphaned records and inconsistencies. Regular backups, while important, focus more on data recovery than on preventing integrity issues.
Loading...
Related Quiz
- Which technique is commonly used for clustering data in a database?
- _______ allows users to work on different versions of the data model simultaneously.
- _______ is a storage optimization strategy that involves storing frequently accessed data in memory for faster access.
- A financial institution is required to store transaction logs for regulatory compliance purposes. However, they have limited storage capacity. How can compression techniques help them manage their storage effectively while ensuring data integrity?
- An _______ relationship allows a single entity to inherit properties from multiple superclasses.