 Related Questions 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 : database testing means we can integrate data,retrive data,inserting data,delete data in according with the custometer requirement(business logic). ... Latest Answer : While testing the database manually, we used to follow two steps. 1) manually 2) by writing sql queries ... Latest Answer : I would say first learn the database, epecially the relationship among the table.Try to understand the business ruleTry to understand the dataStart feeding data through the user interfaceOpen database verify movement of datakeep record of your action ... I said I used select statements most of the times. So, the interviewer took it granted that I am unaware of insert, update and delete statements. Hence it is better to read out whole of the SQL as an answer Latest Answer : The following are the most widely used Sql statments in database testing:1. Use Database2. Select3. Insert4. Update5. Delete6. Drop7. Alter8. Modify Structure9. Join(Inner and outer)10. Views ... Read Answers (7) | Asked by : Bindu Puvvala 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 ... Latest Answer : can u explain u'r solution with example ... Read Answers (10) | Asked by : sriram Kammisetty How do you test whether the database is updated as and when an information are added in the front end?Give me an example? Read Answers (6) | Asked by : kokila 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 ... Read Answers (9) | Asked by : kokila 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. ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
