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
- 6792 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
plz send the test scenarios and test cases for "user name should contain 4 to 8 chars and they should have only vowels"
Which model is following in your company for developing software?
What is a testbed in manual testing?
What is a test scenario?
can anyone tell me the questions that can be posed in an interview for a 5 year experienced person in manual testing
what are questions asked in TCS for database tester (sqlserver)?ay idea
Scenario A year ago we developed a standards compliant website for a client. Their site is very popular resulting in the client wanting to be able to track how it is being used by their users. The first part of this project is to create a Login function so that users can be identified on the website. The data supplied by users would have to be handled securely. You have been allocated this project to work on. You will be responsible for the task from start to finish and will be expected to give feedback to your manager. User expectations The client wants their users to be able to login using a page that fits in with the website design. Tom wants to access the website but doesn’t want his login information to be available to anyone else. Paul doesn’t want to login to the website because he’s not a frequent user. Task Please provide some feedback on how you would do the following:- Being the only Test Engineer on this task, what would your approach be for this requirement? Identify the key areas for testing this page. What tools if any, would you use to perform the testing, bearing in mind that the testing will be done without using an ‘automated test tool’. Provide a sample test case that could be used for testing this page, for example as a word or Excel document.
What is verification in software testing?
What are the different ways of doing black box testing?
Explain the strategy for testing a Java application?
Explain the advantages of automation over manual testing?
What is an exit criteria?
Explain Single View Testing ?
Why documentation testing is important?
What kind of input do we need from the end user to begin proper testing?
