May 20, 2008

Why we should use "Excel Sheet" for test case writing?

Hi all,

It will look silly but it's an issue to discuss. Why we should write test cases in excel sheet when we have the option of word document also.

I have some point to support excel sheet, like one is :-

It is in tabular form.

But we can insert table in word document also. In word document we can send multiple information in single document, then why different excel sheet for test case writing? why not in the same document?

One more can be, Excel sheet support formulas. But can't we insert them in word document? Make this discussion healthy and valuable, please write your comments on it.

May 14, 2008

Re: suman from hyderabad

On Tue, May 13, 2008 at 4:28 AM, Suman Kumar wrote:
Hi ? hru????
This is sumankumar from hyderabad working as test engineer for prithvi
information solutions from past 2years.............i have gone through
your blog and keeping very good information.........and requesting you
keep on updating with real time scenarios.........

i wanna talk to u.............can u send me u r contact number later i
can ask some more questions..............

Thanks suman.

Actually I have switch my job now, so now I have less time for blog posting, still I will try my best for doing post and I will keep replying questions asked by mail to me. Those questions will automatically get posted on blog also for help other readers.

May 9, 2008

Re: Test scenario for GMT

On Fri, May 9, 2008 at 2:34 PM, priyadarshini patil <> wrote:

This is priya, i want to know that how to write test case for GMT i.e if i m going to watch a video with all my buddies, wherever they r in india or abroad. I want that all we r going to watch video at same time then how to check that the time i have sent is right according to their standard i.e when i m watching here at 2pm then they will be watching at the time when i m watching.

Please reply

Hi priya,

Nice to see your mail. As per your scenario, I can confirm one thing, there will be user profile page in your application, which will store their locality with country name. And if I am not wrong it will changing user time into international standard time in back end. you need to test that thing, that logic should work fine. Send them international standard time to view video, and it should converted to according to their locality, when displayed to user. I hope you are getting my point. More I can tell when i know the application functionality.

May 8, 2008

How operating system affects tesing?

Operating system is the interaction between hardware and software, so definitely it affects software testing also. There are so many softwares which says that we are not compatible with earlier versions of windows, or we are compatible with windows but not linux/Unix platform.

Even the software designed for a particular operating system is also affected by working of that operating system. If operating system is not doing the resource allocation properly, definitely a memory eager application will acquire all of the available memory of teh system and so how our application can behave as expected?

There are lot of things to be discussed about this topic, but i will prefer to answer readers comment instead of posting theory here. so start commenting.

May 7, 2008

Active testing v/s passive testing

Active Testing:-

In active testing tester introduced the test data and analyzing the results. For example, we will fill the tank of a car with 1 liter petrol and see it's average.

Passive Testing:-

Passive testing is monitoring the results of a running system without introducing any special test data. For example, a engine is running and we are listening it's sound to note noise pollution by engine.

User acceptance testing

What happened to the application if development team as well as testing team is satisfied with the application, if they say that system is ready for use, will client should use it? or should think once again before using it?

The final stage of a new or changed system after system testing is user acceptance testing. If successful, it signals the approval to implement the system live. Cosmetic and other small changes may still be required as a result of the test, but the system is considered stable and processing data according to requirements.

User acceptance testing can be of two types:-

1) Alpha testing
2) Beta testing

Alpha testing is testing of the system internally by non-team members.
Beta testing is testing of the system by actual users in user environment.

May 6, 2008


Capability Maturity Model (CMM): A five level staged framework that describes the key elements of an effective software process. The Capability Maturity Model covers practices for planning, engineering and managing software development and maintenance.

Capability Maturity Model Integration (CMMI): A framework that describes the key elements of an effective product development and maintenance process. The Capability Maturity Model Integration covers practices for planning, engineering and managing product development and maintenance. CMMI is the designated successor of the CMM.

Blocked test case

We write test cases, but can we execute all test cases at one time?

Or can we execute test cases randomly?

Actually we need to execute test cases in series, because sometimes one test case depends on result of other test case.

A test case that cannot be executed because the preconditions for its execution are not fulfilled is called blocked test case.

Back-to-Back and End-to-End testing

Back-to-Back testing is, in which two or more variants of a component or system are executed with the same inputs, the outputs compared, and analyzed. Back-to-back testing involves cross-comparison of all responses obtained from functionally equivalent software components. Whenever a difference is observed it is investigated and, if necessary, a correction is applied.

End-to-End testing generally ensures that all aspects of the business are supported by the systems under test. This is confirmation testing of overall process is performing well.

May 5, 2008

Test Scenario v/s Test Suite

Test Scenario

Test Scenario is set of test cases that ensure that the business logics are tested. They may be single tests or a series of tests, each depends on the output of the previous one. One test scenario should satisfies atleast one or more business logic.

Test Suite

A test Suite is collection of test cases and/or test scenarios that are related with each other. A test suite is a composite test scenario.

Integration testing

Integration testing phase comes after unit testing. Sometimes there are very typical interview questions arises on integration testing. For example:-

Integration testing is testing of two or more units in integrated form. We have 2 approaches for integration testing, one in Top down and other is Bottom up. The top-down approach to integration testing requires the highest-level modules be test and integrated first. The bottom-up approach requires the lowest-level units be tested and integrated first. Read one more definition, system testing, testing that attempts to discover defects of the entire system( all integrated units as one system).Now the question is,

Q. We are doing integration testing, and when we will integrate the last unit, what type of testing it is? It is integration testing or System testing, and why?

I am not answering this question right now, First I want to know readers views, then I will answer the question, so starts commenting as your answer of this question, it's really a good question generally asked by interviewers.

May 3, 2008

Joining two tables in a single query

Two tables can be joined together in a query in four ways:

  • Inner Join: Returns only rows from both tables that satisfy the join condition.
  • Left Outer Join: Returns rows from both tables that satisfy the join condition, and the rest of rows from the first (left) table.
  • Right Outer Join: Returns rows from both tables that satisfy the join condition, and the rest of rows from the second (right) table.
  • Full Outer Join: Returns rows from both tables that satisfy the join condition, the rest of rows from both tables.
for example:-

users.UserId ,users.FirstName ,users.MiddleName ,users.LastName
FROM Users inner join Properties
on users.userid= Properties.userid

you can use outer join,
right outer join or full outer join in place of inner join. There is no term like left inner join or right inner join.

Severity and Priority based on technical and business point of view

Severity is how critical the defect is ? How much it is effecting the functionality?

Priority is how quickly we need to fix the bug? how soon the bug should get fixed?

Let me take some example:-

1) If company logo is not properly displayed on your website, It will have high priority to be fixed, whereas it's severity is low. (High priority, Low severity)
2) You are doing online shopping and filled payment info, but after submitting the form, you get message that your order has been canceled.(High priority, High severity)
3) There is a mistake in spelling, like "You have registered success." Instead of successfully, here success is written. (Low priority, Low severity)
4) If we have a typical scenario in which application get crashed, but that scenario exits rarely. (Low priority, High severity)

I hope readers can understand how technical and business views effect priority and severity. Still any question please comment.

Responsibilities of a tester

Actually tester responsibilities vary and depends on process followed in a company.

There may be a tester who is writing testcases only, or a tester who is executing testcases and logging the bug.

But in general, what can be a tester responsibilities is a good question. So, a tester can:-

1) Understand requirements and write test cases according to requirements.
2) Execute test cases.
3) Report bugs using bug tracking tool.
4) Retest the fixed bugs.
5) Do regression testing
6) Prepare test report

These are general responsibilities, a tester may needs to wear many hats, depending on company strength and culture.

May 2, 2008

Group functions in SQL, used for database testing

Group functions are functions applied to a group of rows. Group functions are:-

COUNT(*) - Returns the number of rows in the group.
MIN(exp) - Returns the minimum value of the expression evaluated on each row of the group.
MAX(exp) - Returns the maximum value of the expression evaluated on each row of the group.
AVG(exp) - Returns the average value of the expression evaluated on each row of the group


SELECT count(*)as Total,
min(userId)as minimum,
max(userId)as maximum,
avg(userid)as average
FROM users
will return this result as shown in image, result depends on table data. Non-group fields can not be mixed with group fields in the SELECT clause.

SELECT count(*)as Total,
min(userId)as minimum,
max(userId)as maximum,
avg(userid)as average,
userid FROM users

is an invalid query. Userid can not be used, because it is not under group fields.

Select statement with "order by" clause

SELECT UserId ,FirstName, LastName,PrimaryEmail,Password ,RegistrationDate
FROM [PropertywalaDb].[dbo].[Users]
where [FirstName] like 'brij%'
order by Password, userid

You can see in the image, the result of the above query. First query result is sorted according to 'Password" Field. Then the result set get after sorting is again sorted on the basis of "UserId". The blue highlighted resul is first result set, sorted by Password and UserId. See the image carefully.

Test environment and UAT environment

Test environment is a controlled testing environment. When application is under developing stage , it's tested under test environment which simulates the behavior of real user environment.

User acceptance test environment is user actual environment, In which application have to work.

For example:-

When a man goes to moon, he is trained like he is on moon, in controlled environment. Because of difference in gravitational force and other climate differences. It is test environment testing.

But when that person is actually on moon and doing all acts as per expectation than it is UAT environment testing.

Bug tracking system

I think before understanding bug tracking system, readers should know, what is bug tracking?

Bug life cycle is :- New -> Open -> Assigned -> Fixed -> Re-tested -> reopen/Closed.

In this process bug have different stages at different time. It may be open, under fixing, have fixed and now tester have to retest it, like this. And now who will responsible to track these bug states, definitely a tester. This is called bug tracking, having record of open and closed bugs.

Manually it's a cumbersome task to have this record, so we use some software applications like bugzilla, VSTS, or other available. These applications are named as bug tracking system.

Search Here...

Popular Posts

Quick Test Professional