How data integrity can be tested in database testing?
- Check in the column of the database if there is any invalid data.
- Try to enter the wrong data into the table, and notice how the insertion behaves.
- Check if, in the reference tables, triggers are working fine.
- Check the actual result in the main table, when you insert the child record before inserting the parent record.
- What would happen if a user delete records derived from another table?
- Check if the data in two or more replicated servers are in sync.
BY Best Interview Question ON 10 Jan 2022