ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Testing  >>  Manual Testing
 
 


 

 
 Automation Testing interview questions  Automation Testing Interview Questions
 Manual Testing interview questions  Manual Testing Interview Questions
 QA Concepts interview questions  QA Concepts Interview Questions
 Mobile Testing interview questions  Mobile Testing Interview Questions
 Test Cases interview questions  Test Cases Interview Questions
 Test Documents Reporting interview questions  Test Documents Reporting Interview Questions
 Testing AllOther interview questions  Testing AllOther Interview Questions
Question
How can you report the defect using excel sheet?
 Question Submitted By :: Rajendra R
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How can you report the defect using excel sheet?
Answer
# 1
To report the defect using excel sheet 

Mention    :    The Feture that been effected.

mention    :    Test Case ID  (Which fail you can even 
                mention any other which are dependency on  
                this bug)

Mention    :    Actual Behavior

Mention    :    Expected Behavior as mentioned in Test Case
                or EFS or EBS or SRS document with section

Mention    :    Your Test Setup used during Testing

Mention    :    Steps to Re-Produce the bug

Mention    :    Additional Info

Mention    :    Attach a Screen Shot if it is a GUI bug

Mention    :    Which other features it is blocking 
                because of this bug that you are unable to  
                execute the test cases.

Mention    :    How much time you took to execute that test 
                case or follow that specific test case 
                which leaded to bug.
 
Is This Answer Correct ?    0 Yes 1 No
Praveen
 
  Re: How can you report the defect using excel sheet?
Answer
# 2
Praveen you are forgetting three important fields Status, 
priority and severity of the defect.
 
Is This Answer Correct ?    0 Yes 0 No
Namrata
 
 
 
  Re: How can you report the defect using excel sheet?
Answer
# 3
We should draft the bug in such a way that by looking at 
those steps a developer should understand easily what is 
the bug exactly and where is it appeared.

And the steps to Reproduce should be in such a manner that 
when developer performs those steps then he should be able 
to reproduce it easily.

The steps should be:

1) Product
2) Module
3) Sub module
4) Version
5) OS
6) Browser
7) Platform
8) Severity
9) Priority
10)Assaigned to
11)Status
12)Summary
13) URL of the particular screen
14)Description
Under Description "Steps to Reproduce"
15)Error Noticed
16)Expected Result
17)Testers notes 
18)Assigned by

Along with this snap shots should be attached with better 
reference.

If we draft the bug in this way then the developers job 
will be easy.

this will improve productivity.

If any additions are there pls let me know.
 
Is This Answer Correct ?    0 Yes 1 No
Lakshmi Vardhani. B
 
  Re: How can you report the defect using excel sheet?
Answer
# 4
5.	Test Reporting: 
                                 During level ?1 & level ?2,
test execution, test engineers are reporting miss matches in
between test case expected values and build actual values as
defect report to development team.
	In this test reporting, development people are receiving
defect report from testing team in a standard format. This
format followed by every test engineer in test execution to
report defects.

IEEE-829 Defect Report Format:

1.	Defect ID: Unique no./name for future reference.

2.	Description: Summary about defect.

3.	Build Version: The version no. of current build, in this
build test engineers detected this defect.

4.	Feature: The name of module / function, in that area test
engineers found this defect.

5.	Test Case Name: The name of failed test case, in that
case execution test engineer found this defect.

6.	Status: New reporting first time, Re-open Re-reporting.

7.	Re-producible: Yes Defect appears every time in test
case execution, No Defect appears rarely in test case
execution.

8.	If Yes: Attach test procedure.

9.	If No: Attach snapshot and strong reasons.

10.	Severity: The seriousness of defect in terms of
functionality. 

                       High   Not able to continue testing
with out resolving this defect  (show stopper)

                  Medium  Able to continue remaining
testing, but mandatory resolve.

		        Low    Able to continue remaining testing and May
/ May not to          resolve.
11.	Priority: Importance of defect to resolve in terms of
customer (High, Medium, Low)

12.	Detected by: Name of test engineer.

13.	Assigned To: The name of responsible person at
development side to receive this defect report.

14.	Suggested Fix (Optional):  Reasons to accept and resolve
this defect.


Resolution Type:
			After receiving defect report from testing team, the
responsible development people are conducting review meeting
and sending resolution type to the responsible testing team.
			There are 12 types of resolutions, they are

1.	Enhancement: The reported defect is rejected, because
this defect related to future requirements of the customer.

2.	Duplicate: The reported defect is rejected, because this
defect raised due to limitations of hardware devices.

3.	Hardware Limitations: The reported defect is rejected,
because this defect raised due to limitations of hardware
devices.

4.	Software Limitations: The reported defect is rejected,
because this defect is raised due to limitations Software
Technologies (Ms-Access).

5.	Not Applicable: The reported defect is rejected because
these defects have improper meaning.

6.	Functions as Designed: The reported defect is rejected,
because the coding is correct w.r.p.t design documents.

7.	Need More Information: The reported defect is not
accepted / not rejected but the developers are requiring
more information about the defect to understand.

8.	Not Re-producible: The reported defect is not accepted &
not rejected, but the developers are requiring correct
procedure to reproduce that defect.

9.	No Plan To Fix It: The reported defect is not accepted &
not rejected, but the development people are requiring some
extra time.

10.	Open: The reported defect is accepted & the development
people are ready to resolve through changes in coding.

11.	Deferred: The reported defect is accepted, but postponed
to future release, due to low severity & low priority. 

12.	User Direction: The reported defect is accepted, but
developers are providing some valid information about that
defect to customer site people, through our application
build screens.
 
Is This Answer Correct ?    2 Yes 0 No
Nag
 
  Re: How can you report the defect using excel sheet?
Answer
# 5
Defect templates n excel sheet


defect id
defect description
defect procedure
test data
expected result
actual result
defect status
defect severity
defect priority
date and time of defect
defect by whom
whom to be refered


defect by whom
whom to be refered
 
Is This Answer Correct ?    2 Yes 0 No
Abu
 

 
 
 
Other Manual Testing Interview Questions
 
  Question Asked @ Answers
 
Hallow friends, plase tell me difference between retesting and regression testing?  5
What is the difference between bug,error,defect.  5
if u find a bug and reported to devoloper, but he is not agree with ur openion what u will do,how u convince to them SunGard5
How do we measure quality of testing? What are parameter of this? Samsung6
Can anybody find the bugs in this "allinterview.com" site???  7
who is releasing the project?PM/TL?  3
On what criteria we will write test cases?  4
What is a Test Bed?  4
If a bug has high severity then usually that is treated as high priority,then why do priority given by test engineers/project managers and severity given by testers? Ordain-Solutions2
What is RTM Sify4
How to derive test requirements from SRS? Covansys3
Give me examples for high priority and hign severity defects? AppLabs19
contents of test report CTS3
what is the use of a tester.Even admin or developer others can do testing What is the main advantage of atester. why do testing team need testers. HCL4
Can any one explain the difference between test scenario and test case.  3
what is the use of testing? is testing compulsary Satyam10
How can we explain about matrics..Every time iam getting this question..Have you involved in metrics??..Plz..plz Can any anybody give the sugessions..What is the best way to explain about metrics..give me your valuble answer..thanks in advance...  3
What is the difference between bug,defect, error, failulre, fault & mistake? Cognizent14
diff b/w waterfallmodel & v-model? Wipro3
what is testing policy and testing methodology? and what is the difference? MBT3
 
For more Manual Testing Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com