Interested to Buy Any Domain ? << Click Here >> for more details...
can we do database testing in manual testing? then how we
write the test case?
- 2 Answers
- 6899 Views
- I also Faced
- E-Mail Answers
Answer Posted / lakshmanaraj bg
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 |
Post New Answer View All Answers
Can you explian $ pillar of Agile
write the test senario on opening door in the flow diagram format
what is dib format?
Iam new to testing field and i put lot of experiences so i want to get prepared for the interview in all the ways both in manual and Automation can any one help me how to answer there questions in real time. also can anyone send the top questions and answers to me plz its urget u can mail me at vaisu72@yahoo.com
what is the main field of bugzilla which we fill to report bug to any developers???give some brief description??
what are the functional test cases for enter user name,enter pass word,click on ok(only functional test cases)
Can list out some disadvantages of manual testing?
How does compatibility testing differ while testing in Internet explorer and testing in Firefox?
what is mean by impact analysis ,how we used to select regression TC using this?
What is bug priority?
how can u prepare the test plan?
Name three reasons why the tester may choose to record in Context Sensitive mode.
What r all the security problems u r facing & the measures taken to solve.
What does 100% statement coverage mean?
Why Equivalence Partitioning is called equivalence or what is the significance of equivalence term in ECP?
