Database Testing

What is Database scrutiny?
Data bas testing basically include the following
1)Data validness testing
2)Data Integritity testing
3)Performance related to data base
4)Testing of subroutine, triggers and functions.
Ffor doing data validity testing you should be good in SQL queries. For data integrity testing you should retire about referintial integrity and different constraint. For performance related things you should take on idea about the table structure and design. For testing Procedure triggers and functions you should be able to understand the same.

In DB testing we need to check for.
1. The surface area size validation
2. Check constraints
3. Indexes are done or non (for performance related issues)
4. Stored procedures
5. The field size defined in the drill is matching with that in the db
-------------------------------------------------

Write a query to dress the second largest treasure in a given column of a table
To find the second largest salary amount from employee table
select max(salary) from employees
where pin < (select max(salary) from employees)

acquire Max(sal) from Emp where Sal < (select Max(sal) from Emp)
-------------------------------------------------
SELECT * FROM EMP X WHERE 2=(SELECT COUNT(DISTINCT(SAL)) FROM EMP Y WHERE X.SAL<=Y.



SAL)
What is way of opus testcases for database testing?
You have to do the following for writing the database testcases.

1. scratch of all you have to understand the functional requirement of the application throughly.

2. Then you have to find out the back depot tables used, joined used between the tables, cursors used (if any), tiggers used(if any), stored procedures used (if any), foreplay parmeter used and output parameters used for developing that requirement.

3. After knowing all these things you have to write the testcase with different input set for checking all the paths of SP.

One thing writing testcases for backend testing not like functinal testing. You have to use...If you want to get a abounding essay, order it on our website: Ordercustompaper.com



If you want to get a full essay, wisit our page: write my paper