how to write test cases for testing databases,especially
for testing and writing test cases for stored
procedures.any real time database testers.please answer me.
- 1 Answers
- 11883 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajendra
We can do database testing in three ways(appraoch)
1.From front end GUI
2.Purely on back end
3.Using both front end and back end
In the case of database testing frm front end,
It is very easy no need of SQL querying skills,
directly we will enter the data in to database and again
we will call them from front end.
Here the data which is entered into front end GUI should
store properly in the back.
if in the case there is no GUI for that software,no way we
have go for pure back end database testing.
To conduct database testing one must know SQL knowledge
to write query for data insertion,updation,deletion...like
DML,DDL,DCL commands , Stored procedures,views knowledge
to test databse.
Third one is more reliable hybrid and time taking process.
Writing of tescases varies depending on the approach of
database testing.
to write test cases on database input is
databse structure tables,
constraints,
relation betwee the tables we need.
ok friends byeeeee
rajendra
rajendra_penumalli@yahoo.com
hyderbad
+91-9885162742
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
Hello. I am not here to answer your question. I jus found a job as software QA engr. And i am totally new to software testing. So can someone pls help me in the following scenario? there is this registration screen, and it contain: One textbox called Nickname which only accept alphanumerical One textbox called Contact which only accept numerical, One textbox called Email which can be filled with alphanumerical and symbol and One button called Register now becos there is so many textboxes, where i can filled with alphabet, number, symbol, "just space", leading zeros, leading space. there will be lots of combination. can someone pls help.. i will be appreciated if u can post the test case of the scenario i mentioned. Lots of Thanks
what are the prerequisite conditins to test clientserver and web applications
which sanity testing is performed?
Explain about PET Model?
functional testing and usability testing test cases for transfer funds...
What is split testing?
what types of testing you performed in transfer funds module....
How to test the Online Games?? Suggest tricks. I have experience in server-client application testing.
Wat type of questions ll be asked in interview for an 1-2 yrs. experinced persond and i need some database concept question in testing.
how will you test transfer funds module...explain in detail
How could we start writing testcases without having the FRS,BRS Docs? My Project has some docs that are related to explain the operations which will be done in the application. It is deployed in UAT server and is a maintainance project. Tell me some technipues or best way to provide the quality to application?
hi this is satish can some one help me out by sending the maxium notes on client sesrver ,web server and company architechture project hirearchy and company hirearchy i will happy to recive the answers as early as possible
What is your daily process? I have 2+EXP IN MANUAL TESTING.PLEASE SUGGEST ME HOW i ANSWER
What is an mr?
What is test driver and test stub?
