|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 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 : We test Stored Procedure code is to call the procedure for the different combinations of input parameters so that it will behave as expected.The second is to use the command window as a client, and call the procedures from there. This re-routes the ... 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 ... 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 ... Read Answers (6) | Asked by : Bharti jaiswal 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 : suresh:- we can't say, insert , update, delete are sufficient. the db tester have good knoeledge on sql ... Read Answers (6) | 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 : in QTP we r writing queries for fetching the values.1.when u r using database checkpoint then u have to write the sql statement.2.when u r fetch the values from the database then also u have to write the sql statement. ... Read Answers (2) | Asked by : Shrinivas Prasad Latest Answer : can u explain u'r solution with example ... Read Answers (10) | Asked by : sriram Kammisetty Latest Answer : HiThanks for the above info...but no body has told the steps for testing stored procedures....I would appreciate a quick reply...Thnx ... Read Answers (4) | Asked by : anju
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
