How tables and columns can be validated in the database?
- Are the naming conventions of fields are as per requirement?
- Are the lengths and sizes of fields are matching the requirement?
- Create a test case that will check if there is any unmapped or unused table and column.
- Is the mapping of database fields is correct and compatible with the required mappings?
- Check if table designs are applied correctly and are scalable.
BY Best Interview Question ON 10 Jan 2022