1.

How can you validate the tables and columns in the database?

Answer»

We can test the tables and COLUMNS in the databases by applying the following test cases:

  • Are the database fields mapped correctly and is compatible with the REQUIRED mappings in the front-end or BACKEND requirements?
  • Are the fields following proper naming conventions and have LENGTHS and sizes as per the requirements?
  • Check if there are any unused or unmapped tables and columns.
  • Check if the table design and the referential integrities and constraints on the columns are applied effectively and are scalable to different requirements.


Discussion

No Comment Found

Related InterviewSolutions