Hi,
I am new to testing.where we will use SQL in manual testing.
To what extent i need to learn SQl.there are diff types of SQL
like TSql,Mysql etc.i little bit confused,help me.
Thank you .

Answer Posted / amol

Sometimes results of some user actions can not be verified
on UI, we can use SQL to check this.
E.g. Consider a user delete schenario. On UI someone can
select a user to delete and on UI it can be verified if the
same user is not displayed on UI anymore.
But if there is some business logic NOT to delete the user
completly from system, but just mark it as unactive so that
it is not displayed in UI. This logic can not be verified in
UI. For such schenarios we can do a SELECT quesry on
database and check if the user is there with some flag like
deleted=true or active=false.

Is This Answer Correct ?    5 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the challenges you faced in your project (Testing) and in your company?

2599


What is a test server?

727


What are the benefits of creating multiple actions within any virtual user script?

1718


IN SQL SERVER 2005, With out using Query, hw can u break down USER NAME & PASSWORD to enter the software.

1728


How do you perform configuration management with typical revision control systems?

1646






What is Bomb Testing?

1766


what is entry and exit criteria and explain it?

1028


6 what do you like least about testing?

1769


What is a test log?

644


Explain the sub-genres of performance testing?

696


If asked to create a Configuration Design Pattern, where would you start?

1276


ANY ONE HAS ATTENDED THE INTERVIEW FOR WIT INNOVATION P LTD? THEN KINDLY LET ME KNOW ABOUT THE INTERVIEW PROCESS AND QUESTIONS ASKED.

1740


Hi, Anybody knows about Hexaware company..

1678


i heard that mainframe testing is diff from other environments & has lot of keyboard input????pl clarify my doubt & let me know in what way its diff??

1629


How could you present test strategy for the product testing?

650