What is Database testing?
Answer: Database testing involves testing the behavior of the database when the application is being tested. This may involve testing to see if values are being inserted properly, flags are changing appropriately, validity of data, to ensure if data integrity is maintained. It may also account for performance related to the database. SQL queries can be fired in the database to check if the expected results are achieved.
What are the normal check required during database testing?
Answer: There are some basic check required during database testing. Some of most common are
Explain the types of Object Repositories in QTP.
Answer: QTP supports two types of Object Repository files:
What RDBMS stands for and what are the important RDMBS that SQL use?
Answer: RDBMS stands for Relational Database Management Systems that use SQL, and the important RDBMS that SQL uses are Sybase, Oracle, Access ,Ingres, Microsoft SQL server etc.
What are ways of writing test cases for database testing?
Answer: The following are the ways to write the test cases for database testing:
Understand the functional requirement of the application
Find out the tables used, joins used between tables, cursors used, triggers used, stored procedures used, input parameters used and output parameters used.
Explain what is data driven test?
Answer: In a data-table, to test the multi numbers of data, data-driven test is used. By using this it can easily replace the parameters at the same time from different locations.
Explain how QTP recognizes Objects in AUT.
Answer: The objects are recognized through object repository. Object repository file persists the quick test definitions for various applications. While recording the script or test, an entry will be added by quick test at every time interaction. Each object of repository will be identified by a logical name.
How to test database manually?
Answer: Testing the database manually involves checking the data at the back end and to see whether the addition of data in front end is affecting the back end or not, and same for delete, update, insert etc.
What are the different stages involved in Database Testing?
Answer:
The stages of database testing are:
Verifying the data in the database
Verifying the constraints (primary and foreign keys)
Verifying the performance of the procedure
Verifying the transactions (begin, commit, rollback)
Verifying the triggers by executing them
What are joins and mention different types of joins?
Answer: Join is used to display two or more than two table and the types of joins are:
Natural Join
Inner Join
Outer Join
Cross Join