How is data integrity maintained in a relational database?
- By allowing NULL values in critical columns.
- By implementing foreign key constraints to enforce relationships between tables.
- By using triggers for automatic data validation.
- Through regular backups and restores.
Data integrity in a relational database is maintained by implementing foreign key constraints. These constraints ensure that relationships between tables are enforced, preventing orphaned or inconsistent data. Understanding and properly defining these relationships is fundamental to database design.
Loading...
Related Quiz
- Which phase in the Test Execution Lifecycle involves the actual execution of test cases?
- For a high-volume data ETL process, what best practices should be considered to enhance performance and scalability?
- How does data profiling in ETL testing help in risk management?
- What is the typical sequence of operations in an ETL process?
- A business requires real-time analytics from its ETL process. What transformation logic should be implemented to minimize latency?