+91 90691 39140 | +1 253 214 3115 | info@hub4tech.com | hub4tech

Top 25 Most Asked Database Testing Interview Questions and Answers

Sat, 2017-07-15 16:41
Database Testing Interview Questions

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.

Database Testing Interview Questions and Answers

  1. What is Database testing?
  2. 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.

  1. What are the normal check required during database testing?
  2. Answer: There are some basic check required during database testing. Some of most common are:

    • Checking for the Constraint
    • Checking for the Field size
    • Checking for the various Validation applied to any fields
    • Checking for the Stored procedure if any used
  1. Explain the types of Object Repositories in QTP.
  2. Answer: QTP supports two types of Object Repository files:

    • Shared Repository: The complete application utilizes one Object Repository, which is similar to Global GUI Map file in WinRunner.
    • Action Repository: One Object Repository is created for each action, which is similar to GUI map file per test in WinRunner.
  1. What RDBMS stands for and what are the important RDMBS that SQL use?
  2. 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.

  1. What are ways of writing test cases for database testing?
  2. 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.
    • Write the test case with multiple input values for checking all paths.
    • Writing test cases for back end testing, one should use white box testing as opposed to functional testing.
  1. Explain what is data driven test?
  2. 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.

  1. Explain how QTP recognizes Objects in AUT.
  2. 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.

  1. How to test database manually?
  2. 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.

  1. What are the different stages involved in Database Testing?
  2. 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
  1. What are joins and mention different types of joins?
  2. 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
  1. Explain the QTP Tool interface.
  2. Answer: The QTP Tool interface has certain key elements:

    • Title bar – displays the name of the open test
    • Menu bar – displays menus of Quick Test Pro commands
    • File tool bar – has buttons for assisting in managing tests
    • Test tool bar – has buttons used while creating and maintaining tests
    • Debut tool bar – has buttons used during debugging tests – it can be viewed by clicking View->Toolbars->Debug.
    • Action Toolbar – has buttons and several actions which enables the tester to view the individual action details or even the entire flow of the test. It can be displayed by clicking View->Toolbars->Action.
    • Test pane – has 2 tabs for viewing the test; Tree view and Expert View
    • Test details pane – has the Active Screen
    • Data table – has Global and Action tabs for assisting in parameterizing the test.
    • Debug Viewer pane – has three tabs for assisting in debugging the tests
    • Status bar – displays the status of the test.
  1. What is load testing and give some examples of it?
  2. 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.

  1. Explain how to test data loading in database testing.
  2. Answer:

    • Perform the following while involving in data load testing:
    • Know about the data tables, columns and associated constraints, data types
    • Know the target data tables, columns, data types, constraints
    • Check the source and target compatibility
    • Open the corresponding DTS package by using SQL Enterprise manager and execute the DTS package, in case your database server is SQL Server
    • Compare the source data columns and target data columns
    • Cross check the number of rows in both source and target
    • Update the source data and observe the change in reflecting in target or not
    • Check the junk characters and NULLs in the columns of tables.
  1. While testing stored procedures what are the steps does a tester takes?
  2. 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.

  1. How does Run time data (Parameterization) is handled in QTP?
  2. 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.

  1. How does QTP evaluate test results?
  2. 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.

  1. Explain how to test a SQL Query in Winrunner
  2. Answer: The following is the exact process:

    • Connect to the database by using – db_connect( query1 DRIVER {drivername};SERVER server_name;UID uidname;PWD password;DBQ database_name );
    • Execute the query of the database by using - db_excecute_query( write the required query that is to execute);

    Specify the appropriate condition

    • Disconnect the database connection by using - db_disconnect( query );
  1. How would you know for database testing, whether trigger is fired or not?
  2. 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.

  1. Explain the concepts of Test Fusion Report of QTP.
  2. 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.

  1. What is white box testing and black box testing?
  2. 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.

  1. Explain how to test database Procedures and Triggers.
  2. 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.

  1. Without using Database Checkpoints, how you test a SQL Query in QTP?
  2. Answer: By writing scripting procedure in VBScript, we can connect to database and can test the queries and database.

  1. What is QTP?
  2. 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.

  1. What are DCL commands? What are the two types of commands used by DCL?
  2. Answer:
    DCL stands for Data Control Language, it is used to control data.
    The two types of DCL Commands are:

    • Grant: By using this command user can access privilege to database
    • Revoke: By using this command user cannot access the database
  1. What steps does a tester take in testing Stored Procedures?
  2. Answer:
    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.

Use Full Link for Training and Certification

Hitesh Patel
Copyright ©2015 Hub4Tech.com, All Rights Reserved. Hub4Tech™ is registered trademark of Hub4tech Portal Services Pvt. Ltd.
All trademarks and logos appearing on this website are the property of their respective owners.