Entries tagged as Database Testing
How to Test database in Manually? Explain with an example
Observing that opertaions, which are operated on front-end is effected on back-end or not. The approach is as follows : While adding a record thr’ front-end check back-end that addition of record is effected or not. So same for delete, update,…… Ex:Enter employee record in database thr’ front-end and check if the record is added Read More...
What is way of writing testcases for database testing?
An1: You have to do the following for writing the database testcases. 1. First of all you have to understand the functional requirement of the application throughly. 2. Then you have to find out the back end tables used, joined used between the tables, cursors used (if any), tiggers used(if any), stored procedures used (if Read More...
How to test data loading in Data base testing?
You have to do the following things while you are involving in Data Load testing. 1. You have know about source data (table(s), columns, datatypes and Contraints) 2. You have to know about Target data (table(s), columns, datatypes and Contraints) 3. You have to check the compatibility of Source and Target. 4. You have to Read More...
What SQL statements have you used in Database Testing?
The most important statement for database testing is the SELECT statement, which returns data rows from one or multiple tables that satisfies a given set of criteria. You may need to use other DML (Data Manipulation Language) statements like INSERT, UPDATE and DELTE to manage your test data. You may also need to use DDL Read More...