Are you preparing for Database Testing job interview and wondering what questions you might be asked? In this blog we have hand-picked the questions you are likely to be asked in Database Testing job interview and provided to-the-point answers to each one of them so as to help you prepare better for Database Testing job interviews.
Always keep in the mind that, only academic knowledge is not enough to crack an interview. Employers expects from the candidate to have practical knowledge and hands-on experience as well. This Database Testing Interview Questions designed by industry expert will help you to gain practical knowledge of Database.
Join QTP/UFT Online Training and start learning from industry experts.
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.
Answer: There are some basic check required during database testing. Some of most common are:
Answer: QTP supports two types of Object Repository files:
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.
Answer: The following are the ways to write the test cases for database testing:
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.
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.
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.
Answer: Join is used to display two or more than two table and the types of joins are:
Answer: The QTP Tool interface has certain key elements:
Answer: To measure the system response, load testing is done. If the load exceeds the users pattern it is known as stress testing. Examples of load testing are downloading the set of large files, executing multiple applications on a single computer, subjecting a server to large number of e-mails and allotting many tasks to a printer one after another.
Answer: 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.
Answer: The parameter feature can be utilized in Quick Test Pro for enhancing the test or component by using parameterization. A variable acts as a parameter which is assigned a value through an external source or generator. In different steps or check points, the values can be parameterized in test component. The action parameters values can also be parameterized. A data driven wizard could be used to parameterize the same value in several steps.
Answer: 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.
Answer: The following is the exact process:
Specify the appropriate condition
Answer: 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.
Answer: Test Fusion report displays different aspects of the test run, soon after the tester has run a test. A high-level results overview, and expandable Tree View of the test, test data used, the screen shots of the application for every step which highlights discrepancies if at all and each check point pass a failure’s deep explanation; are the aspects. The combination of Test Fusion reports and Quick Test Pro, the reports can be shared across an entire Quality Assurance and the development team.
Answer: 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.
Answer: The input parameters and output parameters must be known. EXEC statement can be used to run the procedure to examine the behavior of the database. The event due to which the trigger is fired should be called or performed to check the behavior of the tables.
Answer: By writing scripting procedure in VBScript, we can connect to database and can test the queries and database.
Answer: Quick Test Pro is a GUI based testing tool for automated functionality. It allows to automation of the user actions on a web based or client based and desktop software application. The functional regression test automation is used primarily by QTP. A scripting language is built atop of VBScript for specifying the test procedure and to manipulate the objects and controls of the application under a test.
QTP works together with Mercury Interactive WinRunner and HP Quality Center and also supports the Quality Assurance of an enterprise.
DCL stands for Data Control Language, it is used to control data.
The two types of DCL Commands are:
The tester needs to go through the requirement of the need of the stored procedure.
Checks whether the indexes, joins, deletions, update are correct in comparison with tables mentioned in stored procedure. Ensure that the stored procedure is following the standards.
Check the calling procedure name, calling parameters and expected responses for different sets of input parameters.
Run the procedure with database client programs like TOAD or MySQL or Query Analyzer etc.
Rerun the available procedures by sending different parameters, and check the results against expected values.
Concluding to the process, automate the tests with WinRunner.