• RSS
  • Facebook
  • Twitter

One Center for all the Testing Need. OneTestingCenter is for all, for all QA, for all Automation. Automation is easy, fun and enriching experience. Happy Learning and Happy Testing!

  • Access to All QA

    At OneTestingCenter, you find lots of books,articles,blogs and detailed guides. Everyone has access to QA. Happy Learning, Happy Testing.

  • Global Trainings

    All the QA/Auotmation trainings are available at OneTestingCenter. QA, Automation, QTP/UFT, Selenium, LoadRunner, QC/ALM, Appium...

  • Automation Learning Fun

    Technology is always evolving. Automation is always challenging. To be frank, Automation is fun, enthusiastic and enrching experience.



    One Testing Center


    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:
    v  Testing integration between database and app through form submissions / data flow checks and so on
    v  Testing of Data validity.
    v  Testing of Data Integrity.
    v  Performance testing related to the data base.
    v  Testing of Statements, Procedure, triggers and functions.

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

              GAReddy @ OneTestingCenter    www.OneTestingCenter.com  

    QTP – DB è IMPORtant Points

    }  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.

    Reactions:

    QTP–DB Testing ( QTP–Database Testing) - Video



    One Testing Center


    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:
    v  Testing integration between database and app through form submissions / data flow checks and so on
    v  Testing of Data validity.
    v  Testing of Data Integrity.
    v  Performance testing related to the data base.
    v  Testing of Statements, Procedure, triggers and functions.

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

              GAReddy @ OneTestingCenter    www.OneTestingCenter.com  

    QTP – DB è IMPORtant Points

    }  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.