![QTP_DBTesting QTP_DBTesting](http://lh3.ggpht.com/-hLJFBm9iDY0/UOFpYdA8VmI/AAAAAAAAAI4/Hidk7nluJFU/QTP_DBTesting_thumb.png?imgmax=800)
www.OneTestingCenter.com
What is DB (database)
What is a Relational Database?A Relational Database is a structured collection of information that is related to a particular subject or purpose, such as inventory database, human resources database etc..
What is Database testing?
Database testing is the process of testing databases either independently or with integration of application
Database testing involves the following activities:
- Testing integration between database and app through form submissions / data flow checks and so on
- Testing of Data validity.
- Testing of Data Integrity.
- Performance testing related to the data base.
- Testing of Statements, Procedure, triggers and functions.
A Relational Database is a structured collection of information that is related to a particular subject or purpose, such as inventory database, human resources database etc..
Why do we use Databases?
We use databases to manage information of the application (front end) such as product name, cost, on-hand inventory etc..
What are Tables ?
Tables are the storage containers within a database where the data is organized. Tables are made up of number of rows and columns where columns represent individual fields and rows represent records of data in the tables. e.g., Employee Table
![clip_image002 clip_image002](http://lh5.ggpht.com/-UUTs6McUn2U/UOFpcbmurQI/AAAAAAAAAJc/6GrOMUg11lQ/clip_image002_thumb.png?imgmax=800)
QTP – DB ==> Few Important Points
![DB_FewPoints DB_FewPoints](http://lh5.ggpht.com/-uv9HV840voY/UOFpemC1QZI/AAAAAAAAAJo/1s6xoG9Jgew/DB_FewPoints_thumb.png?imgmax=800)
ActiveX Data Objects (ADO) is COM objects which can be used to gain access to a database through QTP. While using ADO you will need to understand three objects
Command– Command object is like a container for a command which you send to the database to do some actions. Mostly a sql statement is used as a command to the database.
Connection – Connection object is the link between QTP and the database. For any operation you will need to open the connection link initially and make sure you have closed the link once you are done. It requires a connection string to initialize the properties needed to connect to a db .
RecordSet – RecordSet object is the container for the command results. The container is called as the cursor. A cursor is like a temporary table in the memory which contains all the characteristics of a table like rows, columns, record pointers etc. This is the object on which plays significant role in your test.
0 comments:
Post a Comment