Correct Answers to Objective Type Questions on Database Testing are at the end of this page:
Review your Skills on Database Testing-Through Descriptive Questions
Q.1: How can we unit test our databases?
We can test stored procedures by executing SQL statements one at a time against known results. Then the results can be validated with expected results. This is similar to unit testing.
<<<<<< =================== >>>>>>
Q.2: What are certain points that are to be kept in mind during database testing?
Following four important points need to be kept in mind.
(1) I/O validations and error handling must be done outside of the stored procedures.(2) Do thorough analysis to design black-box test cases that produce problematic inputs that would break the constraints.
(3) Testing the interaction between SQL and other components like scripts.
(4) Understanding how to use database tools to execute SQL statements can improve our ability to analyze web-based errors like it helps us to determine whether an error is in the stored procedure code, the data itself or in the components outside the database.
<<<<<< =================== >>>>>>
Q.3: What sort of tests may be carried out during database testing?
(1) SQL databases may not be able to accept special characters (like $, @, &) as valid inputs.
(2) Data sent to the database server may be corrupted due to packet losses caused by slow connections.
(3) Proper implementation of database rollback logic. Otherwise, it causes data corruption. Design your test cases to exercise those critical areas.
(4) Check for complete loading of tables in the database.
(5) Check for proper error handling.
(6) Check that your server does not run out of disk space.
<<<<<< =================== >>>>>>
Q.4: What are milestone tests?
Milestone tests are performed prior to each development milestone. They are scheduled according to the milestone plan.
<<<<<< =================== >>>>>>
Q.5: What sort of errors are handled at the client side and at the server side?
Simple errors such as invalid inputs should be handled at the client side. Handling error conditions can be done at the server side.
Many More Articles & Tutorials on Databse Testing
Correct Answers to Objective Type Questions on Database Testing are as under:
| Question No. | Correct Answer |
| Q. 1 | B |
| Q. 2 | C |
| Q. 3 | A |
| Q. 4 | C |
| Q. 5 | A |
| Q. 6 | C |
| Q. 7 | B |
An expert on R&D, Online Training and Publishing. He is M.Tech. (Honours) and is a part of the STG team since inception.