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
Latest Answer : In my experience , I have done the followign test activities as part of databaes application*Data Integrity: Whether relationship between tables (as defined while designing tables) are getting respected after different equievalence classes of data.*Data ...
Latest Answer : While testing the database manually, we used to follow two steps. 1) manually 2) by writing sql queries ...
Latest Answer : suresh:-Based on situation 1) before running the script, count how many record that has, after running script, count how many records it has based ...
Latest Answer : Hi Raghu,The answer you gave is very useful,. but can you be a bit more elaborative as of to what extent do we need to work with indexes, cursors and how to test a SP with some examples if possible!!Thanks Rajani ...
How do you test whether the database is updated as and when an information are added in the front end?Give me an example?
Latest Answer : Hi,You can test through manually through oracle or pl/sql by executing the queries and through automation by retrieveing the data and comparing with the input.Thanks,Praveen ...
Latest Answer : Show stopper means in application we are not able to go further to access it for eg. if the login screen does not allow the user to enter means, you cannot go further, so it stops the entire show. ...
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?
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?
How do you test Oracle database in LoadRunner please response with a real time work experience example