Explain with an example how you can test the database manually?

1.	Explain with an example how you can test the database manually?
Answer» DATABASE testing can be done manually as well. This requires human effort in observing the behaviour of the application when subjected to different manual test cases drafted by the testers. This can also involve observation of the behaviour in FRONT-end applications when the backend database has changed. We can also manually check whether the record has been created, updated or deleted in the database tables post the execution of the queries. Consider an example of a database system that KEEPS track of student details. The operations RUN on the Student tables database can be validated manually by looking at the state of the RECORDS post query execution or can be validated in how the front end interface looks like.

Answer»

DATABASE testing can be done manually as well. This requires human effort in observing the behaviour of the application when subjected to different manual test cases drafted by the testers. This can also involve observation of the behaviour in FRONT-end applications when the backend database has changed. We can also manually check whether the record has been created, updated or deleted in the database tables post the execution of the queries.

Consider an example of a database system that KEEPS track of student details. The operations RUN on the Student tables database can be validated manually by looking at the state of the RECORDS post query execution or can be validated in how the front end interface looks like.

Discussion

No Comment Found

Related InterviewSolutions

What are the different SQL statements that can be used for database testing?
How will you know if a trigger is fired or not at the time of database testing?
How is stored procedure testing done?
How do you validate whether the database table has been updated after you enter data from the front-end application?
Explain with an example how you can test the database manually?
What do you understand by retesting and how is it different from data-driven testing?
What do you understand by validation of ACID properties in database testing?
What would be the SQL statements used for managing and manipulating the test tables?
What do you understand by Non-functional testing in terms of database testing?
What do you understand by Keys and indexes Testing?