FAQS

[cena]

1.How to extract data from different datasource
2.What are the steps that must be included in testing guideline document for database testing?
3.In Database testing What will you keep in consideration and Why. Explain.
Correctness of Data:
1.Check whether default values are set for the necessary fields
2.Check whether for the integrity constraints
3.Check whether the values found in the table corresponds to the values in Master table
Performance:
1.During heavy transactions
2.When scheduled tasks run at the back end
4.This is regarding security of a Database ...How can i test the security of a DB written using Stored Procedures.... 1.Can I do SQl Injection attacks..If not what else are the methods
The security test conducts in following areas:
1) Whether user comes from proper Login Page
2) Applying SQL injection and session hijacking
3) Whether Customer order file are unrestrictive
4) Email confirmation should be available
5.what is datadriven test?
Ans. Re-execution of our test with different input values is called Re-testing. In validate our Project calculations, test engineer follows retesting manner through automation tool.Re-teting is also called DataDriven Test.There are 4 types of datadriven tests.

1) Dynamic Input submissiion ( key driven test) : Sometines a test engineer conducts retesting with different input values to validate the calculation through dynamic submission.For this input submission, test engineer use this function in TSL scriipt-- create_input_dialog ("label");

2) Data Driven Files Through FLAT FILES ( .txt,.doc) : Sometimes testengineer conducts re-testing depends on flat file contents. He collect these files from Old Version databases or from customer side.

3)Data Driven Tests From FRONTEND GREAVES : Some times a test engineer create automation scripts depends on frontend objects values such as (a) list (b) menu (c) table (d) data window (5) ocx etc.,

4)Data Driven Tests From EXCEL SHEET : sometimes a testengineer follows this type of data driven test to execute their script for multiple inputs. These multiple inputs consists in excel sheet columns. We have to collect this testdata from backend tables .

Once u have successfully debugged and run your tests,u may want to see how the same test performs with multiple tests of data which is nothing but datadriven testing.To do this you convert your test to datatdriven test and create a corresponding data table with the sets of data you want to test.

Converting your test to a data-driven test involves the following steps:

• Adding statements to your script that open and close the data table.

• Adding statements and functions to your test so that it will read from the data

table and run in a loop while it applies each set of data.

• Replacing fixed values in recorded statements and checkpoint statements with

parameters, known as parameterizing the test.

You can convert your test to a data-driven test using the DataDriver Wizard or

you can modify your script manually.
6.How to verify build instructions. Mention steps.
Hi, Nice question But i think it depends on the projects to projects.Best is if it has some somke test cases that will work out There may be many builds in one day, so some time u may not even have time to execute all the test cases so at that time by just on ur experience pick the important things like EAI is up or down, is it picking all the information from DataBase, all the links are working fine or not.
7.How to mount the Database?
Depend on what kind of database, see your database product installation manual for your hardware and software platform.

When you open the database it opens as
no-mount
mount
then we start the database as start database
then you can say close database
it will take you to the mount stage
8.How to check a trigger is fired or not,while doing Database testing?
can you be a little elaborate on that.
If possible using a query while explaining would be useful.


I am using SQL SERVER. In SQL SERVER, there is a tool SQL Profiler. Using SQL Profiler you wll check a trigger is fired or not. You will also check if trigger is fired then whats the output of fired trigger.
9.How to check for correct stored procedures and how to check if the triggers are fired or not in Db testing?
To check the correctness of SP you should have a good knowledge to understand SP(Stored Procedure). You have to understand what are the steps and what about the expected result to execute the SP. Like there is an SP, which helps to insert a row which has two columns in a table then you will execute that SP only and you know the expected result just write one query and check those expected values into the database.
Same procedure you will apply to triggers too. You know at what condition the trigger is fired.

Or if you are using SQL Server database then its very easy to do. Using SQL PROFILER you can check the correctness of SP and trigger too.
10.How to Test Database Procedures and Triggers?
Before testing Data Base Procedures and Triggers, Tester should know that what is the Input and out put of the procedures/Triggers, Then execute Procedures and Triggers, if u get answer that Test Case will be pass other wise fail.
These requirements should get from DEVELOPER

The concept is simple.Let us take the example of a trigger, say, an update trigger for the employee table.Now, the logic here is, let's say when a row is modified(for eg, Emp name is being changed), that information needs to be emailed to a person.We can use triggers to do this. By setting a trigger on an action, we indirectly ensure that, whenever that action takes place, the corresponding trigger will fire and the commands in the trigger will get executed.
11.Is a "A fast database retrieval rate" a testable requirement?
Yes. since i know that we may not calculate the apt micro sec and all but still if the quality of s/w is justified bad because of the slow processing of the data, then it is. Normally we dont find this kind untill we are dealing with very high volumes of data. For small databases it is not at all a constraint. even in some cases if the client asks you about this then you need to keep the check points to check that it is doing the retreival with in no time.

No. I do not think so. Since the requirement seems to be ambiguous. The SRS should clearly mention the performance or transaction requirements i.e. It should say like 'A DB retrival rate of 5 micro sec'.
12.How do you test Oracle database in LoadRunner please response with a real time work experience example
Always Database is the back end and application will be the front end so u have to login to Oracle Database then measure the total no. of records related to that application flow.

If it is web application select Vuser Generator and select reoording option prototype as Web(HTTP/HTML)

After recording the actions we have to run the script

By using the Controller v can monitor the System responce / partucular applicaiton, by analysing the results.

It totally depends on the configuration like RAM, number of users loged at a time, CPU utilization etc and based on the database also we to measure the performance.

total no of records in the database
13.What is join and explain about types of joins?
we can join two tables by primary and forienkeys of both tables in sql statements, you can also specify the field to be displayed in ur join from two tables,

suppose we have two tables

emp, dept

emp: emp-no, emp- name, emp- sal,dept-no

dept: dept-no, dept-loc,dept-strength

no we can join these tables by using sql statement

select emp-no, emp-name,emp-sal, dept-no,dept loc,dept- strength from emp, dept where emp.dept-no == dept.dept-no

The SQL JOIN statement is used to combine the data contained in two relational database tables based upon a common attribute.

Basically there are two types of Joins

1. Inner Join

An inner join is a join that selects only those records from both database tables that have matching values. Records with values in the joined field that do not appear in both of the database tables will be excluded from the query. One or more fields can serve as the join fields.

2. Outer Join

Outer Join has 2 types furthure.

2a. Right Outer Join : 2b. Left Outer Join

An outer join selects all of the records from one database table and only those records in the second table that have matching values in the joined field. In a left outer join, the selected records will include all of the records in the first database table. In a right outer join, the selected records will include all records of the second database table. One or more fields can serve as the join fields.
14.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 of the previous database.
15.Write a query to find the second largest value in a given column of a table
For any question of this type,.. just follow the simple methodology called TOP N ANALYSIS.
For the 3rd highest salary employee,
Select emp_name , rownum
From (select emp_name from emp Order by sal DESC)
where rownum=3.
For further clarification, just test the similar type of queries with this methodology.
16.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 front end, then you have to go to Database and run relevent SQL query.
Let me know if you have any other questions..
17.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 to database, fire queries to get the same date from the back end.

1.When an Information is added to the Front end.
Use Insert querry to add data to the Table.
write : commit;
Now you check the inserted data is there or not.
18.What steps does a tester take in testing Stored Procedures?
In my view, the tester has to go through the requirement, as to why the particular stored procedure is written for? and 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, updated by, etc.

It is necessary to impliment error handling mechanism in stored procedures, where in every system thrown error messages will be taken care off. Its testers job to check for error handling mechanism.Say for example: a variable is declared with varchar 30 and user tried to assign a value which is 40 size.....system will throw the error saying buffer too small or 'something like that.In the above case we should not leave SP or application using the SP in an unknown situation.
19.how can we write testcases from Requirements..? Do the Requirements represent exact Functionality of AUT
Yes, Requirements should represent exact functionality of AUT.

First of all you have to analyse the requirement very throughly in terms of functionality. Then you have to think about suitable testcase design techniques (Black Box design techniques like Equivalance Partitioning, Boundry Value Analysis, Error Guessing and Cause Effect Graphing) for writing the testcase.

By these concepts you should write a testcase which should have the capability of finding the absence of defects.

Test case preparation will be made by using Test scenarios.

Test scenarios are prepared by using Test plan ( H L D, L L D).

The hierarchy will follow like this

Test Plan

Test Scenarios

Test Cases ( Positive Case, Neagative case)

20.What are the different stages involved in Database Testing
verify the data in the database w.r.t frontend transactions

verify the constraint (primary key,forien key ....)

verify the performance of the procedures

verify the triggrs (execution of triggers)

verify the transactions (begin,commit,rollback)

Verify wheather the fornt end values are correctly storing in the back end databse by writing the sql queries.

Verify the Constraints (Primary key,foreign key, Composite key)

check the performance of the Stored Procedurs

check for the execution of the Triggers
21.How to use sql queries in WinRunner/QTP
in QTP
using output databse check point and database check point ,
select sQL manual queries option
and enter the "select" queris to retrive data in the database and compare
the expected and actual


in QTP we r writing queries for fetching the values.

1.when u r using database checkpoint then u have to write the sql statement.

2.when u r fetch the values from the database then also u have to write the sql statement.

22.what is database testing and what we test in database testing
Database testing is all about testing joins, views, inports and exports , testing the procedures, checking locks, indexing etc. Its not about testing the data in the database.

Database testing involves some in depth knowledge of the given application and requires more defined plan of approach to test the data. Key issues include:

1) Data Integrity

2) Data Validity

3) Data Manipulation and updates

Tester must be aware of the database design concepts and implementation rules.
23.what SQL statements have you used in Database Testing?
I used select statements most of the times. So, the interviewer took it granted that I am unaware of insert, update and delete statements. Hence it is better to read out whole of the SQL as an answer to this question.

database testing is nothing but backend testing.

if we want to check all your datatable details means we have to good knowedge about all ddl comments

the ddl cover coment.

select ,delet,insert,update and all type of joins
24.How to test data loading in Data base testing
You have to do the following things while you are involving in Data Load testing.
1. You have know about source data (table(s), columns, datatypes and Contraints)
2. You have to know about Target data (table(s), columns, datatypes and Contraints)
3. You have to check the compatibility of Source and Target.
4. You have to Open corresponding DTS package in SQL Enterprise Manager and run the DTS package (If you are using SQL Server).
5. Then you should compare the column's data of Source and Target.
6. You have to check the number to rows of Source and Target.
7. Then you have to update the data in Source and see the change is reflecting in Target or not.
8. You have to check about junk character and NULLs.
25.What is way of writing testcases for database testing?
For writing test cases in Database first one should define the project name, then module,Bug number,objective,steps/action undertaken,expected result,actual result, then status, priority and severity.


You have to do the following for writing the database testcases.

1. First of all you have to understand the functional requirement of the application throughly.

2. Then you have to find out the back end tables used, joined used between the tables, cursors used (if any), tiggers used(if any), stored procedures used (if any), input parmeter used and output parameters used for developing that requirement.

3. After knowing all these things you have to write the testcase with different input values for checking all the paths of SP.

One thing writing testcases for backend testing not like functinal testing. You have to use white box testing techniques.
26.How to Test database in Manually? Explain with an example
Observing that opertaions, which are operated on front-end is effected on back-end or not.
The approach is as follows :
While adding a record thr' front-end check back-end that addition of record is effected or not.
So same for delete, update,......

Ex:Enter employee record in database thr' front-end and check if the record is added or not to the back-end(manually).

No, I don't agree with this Explanation.

To check the data in the database in simply functional testing which is usually done through interface.

Database testing is actually testing the procedures for locks, Imports and Exports, testing DB server which is usually done by a DBA.
27.