1) What is data-base testing?
Ans : Data base testing is segmented into four different categories.
Ans : Normally, the things that we check in database testing are:
Ans : 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.
4) What are joins and mention different types of joins?
Join is used to display two or more than two table and the types of joins are:
The outer join is divided again in two:
5) What are indexes and mention different types of indexes?
Ans : Indexes are database objects and they are created on columns. To fetch data quickly they are frequently accessed. Different types of indexes are:
Ans : The tester will check the standard format of the stored procedures and also it checks the fields are correct like updates, joins, indexes, deletions as mentioned in the stored procedure.
7) How would you know for database testing, whether trigger is fired or not?
Ans : On querying the common audit log you would know, whether, a trigger is fired or not. It is in audit log where you can see the triggers fired.
8) In data base testing, what are the steps to test data loading?
Ans : Following steps need to follow to test data loading
Ans : By writing scripting procedure in VBScript, we can connect to database and can test the queries and database.
10) Explain how to use SQL queries in QTP ?
Ans : In QTP using output database check point and database check, you have to select the SQL manual queries option. After selecting the manual queries option, enter the “select” queries to fetch the data in the database and then compare the expected and actual.
11) What is the way of writing testcases for database testing?
Ans : Writing a testcases is like functional testing. First you have to know the functional requirement of the application. Then you have to decide the parameters for writing testcases like
Ans : The statements like SELECT, INSERT, UPDATE, DELETE are used to manipulate the table, while ALTER TABLE, CREATE TABLE and DELETE TABLE are used to manage table.
13) How to test database procedures and triggers?
Ans : To test database procedures and triggers, input and output parameters must be known. EXEC statement can be used to run the procedure and examine the behaviour of the tables.
Ans : To write a testcases from requirements, you need to analyse the requirements thoroughly in terms of functionality. Thereafter you think about the appropriate testcases design techniques like Equivalence partitioning, Black box design, Cause effect graphing etc. for writing the testcases.
Yes, the requirements represent exact functionality of AUT.
15) What is DBMS?
Ans : DBMS stand for Database management system, there are different types of DBMS
Ans : DML stands for Data Manipulation Language, It is used to manage data with schema objects. It is a subset of SQL.
17) What are DCL commands? What are the two types of commands used by DCL?
Ans : DCL stands for Data Control Language, it is used to control data.The two types of DCL Commands are:
Ans : Black box testing means testing the software for the outputs on giving particular inputs. This testing is usually performed to see if the software meets the user’s requirements. There is no specific functional output expected for running this test.
The white box testing is done to check the accuracy of code and logic of the program. This testing is done by the programmer who knows the logical flow of the system.
19) How does QTP evaluate test results?
Ans : Once the testing is done, QTP will generate a report. This report will show the checkpoints, system message and error that were detected while testing. The test results window will show any mismatches encountered at the checkpoints.
20) Explain the QTP testing process?
Database Testing Interview Questions & material
|Selection||File type icon||File name||Description||Size||Revision||Time||User|