can we do database testing in manual testing? then how we
write the test case?
- 2 Answers
- 5924 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 |
how to write a test case for check box like in gmail or yahoo
Do you face any showstoppers issue in your current project? Explain
What is the difference between Product tester and Software Tester?Is there any difference?
pls explain company testing process in detail (if anybody working as a test engeneer)
who preapares use case document? who preapares use functional point document? who preapares use test sceanario document?
Describe any bug you remember. Plz Give some real examples
What is the difference b/w SYSTEM REQUIREMENT SPECIFICATIONS and FUNCTIONAL REQUIREMENT SPECIFICATIONS ?
what is system testing .what are the system test cases .and what are the testing done in system testing
What is Deffered? explain it who allocate it?
can anybody tell what is the extention for java and dotnet application(means exe file extention).its urgent
what documents are used to write testcase for integration testing and system testing?
What is Environment Requirement?
Automation Testing 
