| |
151. How To Test A DTS Package Created For Data Insert Update And Delete? What Should Be Considered In The Above Case While Testing It? What Conditions Are To Be Checked If The Data Is Inserted, Updated Or Deleted Using A Text Files?
Date Posted: 07/02/2012
Ans: Data Integrity checks should be performed. IF the database schema is 3rd normal form, then that should be maintained. Check to see if any of the constraints have thrown an error. The most important command will have to be the DELETE command. That is where things can go really wrong.
Most of all, maintain a backup of the previous database.
|
| |
| |
152. Is An "A Fast Database Retrieval Rate" A Testable Requirement?
Date Posted: 07/02/2012
Ans: No. I do not think so. Since the requirement seems to be ambiguous. The SRS should clearly mention the performance or transaction requirements i.e. It should say like 'A DB retrieval rate of 5 micro sec'.
|
| |
| |
153. How To Test Database Procedures And Triggers?
Date Posted: 07/02/2012
Ans: Before testing Data Base Procedures and Triggers, Tester should know that what is the Input and output of the procedures/Triggers, Then execute Procedures and Triggers, if you get answer that Test Case will be a pass otherwise fail.
These requirements should get from DEVELOPER
|
| |
| |
154. How To Check A Trigger Is Fired Or Not, While Doing Database Testing?
Date Posted: 07/02/2012
Ans: It can be verified by querying the common audit log where we can able to see the triggers fired.
|
| |
| |
155. What Is Data Driven Test?
Date Posted: 07/02/2012
Ans: Data driven test is used to test the multimember’s of data in a data-table, using this we can easy to replace the parameters in the same time from deferent locations.
e.g.: using .xls sheets.
|
| |
| |
156. How To Test Database In Manually? Explain With An Example
Date Posted: 07/02/2012
Ans: Observing that operations, which are operated on front-end is effected on back-end or not.
The approach is as follows:
While adding a record there front-end check back-end that addition of record is effected or not. So same for delete update, Ex: Enter employee record in database front-end and check if the record is added or not to the back-end (manually).
|
| |
| |
157. What We Normally Check For In The Database Testing?
Date Posted: 07/02/2012
Ans: In DB testing we need to check for,
1. The field size validation
2. Check constraints.
3. Indexes are done or not (for performance related issues)
4. Stored procedures
5. The field size defined in the application is matching with that in the db.
|
| |
| |
158. What Is Database Testing
Date Posted: 07/02/2012
Ans: Data base testing basically include the following.
1) Data validity testing.
2) Data Integrity testing
3) Performance related to data base.
4) Testing of Procedure, triggers and functions.
For doing data validity testing you should be good in SQL queries
For data integrity testing you should know about referential integrity and different constraint.
For performance related things you should have idea about the table structure and design.
For testing Procedure triggers and functions you should be able to understand the same.
|
| |
