can we do database testing in manual testing? then how we
write the test case?
- 2 Answers
- 5926 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Yes of course,
Many beginner and intermediate database testing examples in any programming language suggest that it is perfectly easy to test your application's logic with simple tests. For database-centric applications this is far away from the reality. Start using Wordpress, TYPO3 or Symfony with Doctrine or Propel, for example, and you will easily experience considerable problems with PHPUnit: just because the database is so tightly coupled to these libraries.
You probably know this scenario from your daily work and projects, where you want to put your fresh or experienced PHPUnit skills to work and get stuck by one of the following problems:
The method you want to test executes a rather large JOIN operation and uses the data to calculate some important results.
Your business logic performs a mix of SELECT, INSERT, UPDATE and DELETE statements.
You need to setup test data in (possibly much) more than two tables to get reasonable initial data for the methods you want to test.
The DbUnit extension considerably simplifies the setup of a database for testing purposes and allows to verify the contents of a database after performing a series of operations.
Sample test case for database testing:
The test case for the above requirement is mentioned below:
Test_Case_Id:1
Test_Case_Name:Check the unique identity of Student.
Description:Test case to check the unique identity of Student.
Prerequisite:
1.Database should be present 2.Student records should be present in student table.
Input Data:1.Open your database(SQl,oracle or any which you are using)
2.Open its command prompt editor.
3.Select the proper database
4.Enter the query as:"Select * from Student_Details"
5.Run the query.
Expected Result: The all unique student records will be displayed.
Validation:Student is should be unique.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / manikandan ganesh
yes we can do database testing in manual testing..
| Is This Answer Correct ? | 2 Yes | 0 No |
What is interface testing
What is STLC?
What is the difference between Smoke Testing & Sanity Testing?
wht is test data,test condition
Description--->There are 5 modules in my application. On every module there is a date box. In 1st module, date box is used for 2 submenus. My Question is ---> Should I have to write test cases for date box for every modules & submenus?
Can any one tell me how will be the projects in realtime life?. I am much worried because this going to be my first job?
what should be tested when credit card is used as payment option in ecommerce project?can anyone tell me in detail what to test n how to test when credit card is involved in web application?
What are the important scenarios for testing emails? How do you test emails? Which tool is best for testing email?
what is the format of test case document? any one can send test case excel sheet format? my id :chinna.4494@yahoo.com
What do you gather as a part of requirement gathering (for a testing project)?
whta is compile module?
what is meant by system testing? what is functional testing? what is the difference between both of these testing? can anyone explain this in detail?
Automation Testing 
