Your Interview Questions

Recent Articles

• What steps does a tester take in testing Stored Procedures?

  First the tester should to go through the requirement, as to why the particular stored procedure is written for. Then check whether all the required indexes, joins, updates, deletions are correct comparing with the tables mentions in the Stored Procedure. And also he has to ensure whether the Stored Procedure follows the standard format like comments, Read More...

• How do you test whether the database is updated as and when an information are added in the front end?Give me an example?

  It depends on what level of testing you are doing.When you want to save something from front end obviously, it has to store somewhere in the database You will need to find out the relevant tables involved in saving the records. Data Mapping from front end to the tables.Then enter the data from front end and save. Go Read More...

• How do you test whether a database in updated when information is entered in the front end?

  It depend on your application interface.. 1. If your application provides view functionality for the entered data, then you can verify that from front end only. Most of the time Black box test engineers verify the functionality in this way. 2. If your application has only data entry from front end and there is no view from Read More...

• How to test a SQL Query in Winrunner? without using DataBase CheckPoints?

  By writing scripting procedure in the TCL we can connect to the database and we can test data base and queries. The exact proccess should be: 1)connect to the database db_connect(“query1″,DRIVER={drivername};SERVER=server_name; UID=uidname;PWD=password;DBQ=database_name “); 2)Execute the query db_excecute_query(“query1″,”write query u want to execute”); -Condition to be mentioned- 3)disconnect the connection db_disconnect(“query”); Read More...

• How to test a DTS package created for data insert update and delete? What should be considered in the above case while testing it?What conditions are to be checked if the data is inserted, updated or deleted using a text files?

  Data Integrity checks should be performed. IF the database schema is 3rd normal form, then that should be maintained. Check to see if any of the constraints have thrown an error. The most important command will have to be the DELETE command. That is where things can go really wrong. Most of all, maintain a backup Read More...