Answer / 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.

Answer / manikandan ganesh

yes we can do database testing in manual testing..

For each bug I have to take a screen shot or For those only which are difficult to explained?

4 Answers  

---

what responsility of the network administrator?

1 Answers   Religare,

---

what is the difference between metrics and matrixes .. if possible please give some examples..

1 Answers  

---

What is meant by back-end testing?

3 Answers   Accenture,

---

When do you go for integration testing?

6 Answers  

---

What's Web-Enabled Application Measurement Tests

1 Answers   Crea,

---

What is the difference between code walkthrough and code review? What is the difference between walkthrough and inspection?

0 Answers   HCL,

---

what are test cases for edit,add,delete,save,preview and main buttons and test scenarios

2 Answers   L&T, Wipro,

---

what is the need of black box testing after completing white box tesing?

2 Answers   Cognizant,

---

What should I do if the name of the field is change in new version?How should I maintain it in Test Case Document? Eg: 1)On Login Window:if Login button changed to Ok button 2)the Name of the Login Window get changed 3)Suppose New button adds to Login Window 4)Suppose For Login button there is Alt+L is used in new version Please tell me as early as possible Thanks in advance!!!

1 Answers  

---

What is software development Life Cycle (SDLC)? where exactly the Testing activity begin in SDLC?

12 Answers   Systematix, TCS,

---

i have doubt suppose iam purly working in manual, when i will work on sql and performence testing? pls any one clarify doubt?

1 Answers  

---