Manual Testing Interview Questions 2

Manual Testing interview questions continued from the 

Application developed should fit user’s business process. The components of fit are
a. Data
b. People
c. Structure
d. All of the above

Which is not the responsibility of customer/ user of the software
a. Plan how and by whom each acceptance activity will be performed
b. Prepare the acceptance plan
c. Prepare resource plan
d. Plan resources for providing information on which to base acceptance decisions

In preparation for developing the acceptance criteria, the user should
a. Know the defects in the application
b. Acquire the basic knowledge of the application for which the system is intended
c. Understand the risks and benefits of the development methodology that is to be used in correcting the software system
d. Know new enhancement and basic understanding of how the application is implemented in users organization

QC is
a)      Phase building activity                                   
b)      Intermediate activity
c)      End of Phase activity
d)     Design activity

The ______________ is an application of process management and quality improvement concepts to software development and maintenance.
a.       Malcolm Baldridge
b.      ISO 9000
c.       SEI/CMM
d.      QS14000

Which is a true prevention mechanism
  1. verifying that the executable contains a defect
  2. detecting that the executable contains a defect
  3. Validating that the specified requirements are right, complete, achievable, reasonable, testable
  4. Verifying that the specified requirements are right, complete, achievable, reasonable, testable
Objective of review meeting is
  1. to identify problems with design
  2. to solve the problems with design
  3. both a and b
  4. none of the above.

What are the Performance Testing Concepts ?

Load Testing Tools
  1. reduces the time spent by the testers
  2. reduces the resources spent (hardware)
  3. mostly used in web testing
  4. all  of the above
Identify which one is a load condition
  1. Lost messages
  2. Task starts before its prerequisites are met.
  3. Lost or out of sync messages
  4. Early end of string
State which of the one is false
a.    In performance  testing, usage of tool is a must
b.    In database testing, database knowledge is a must.
c.    In Functional Testing, knowledge of business logic is a must
d.    none of the above.

Load testing emphasizes on performance under load while stress testing emphasizes on
a.      Breaking load
b.      Performance under stress
c.       Performance under load
d.      There is no such difference, both are same

Which of the following is not a form of performance testing?
a.       Spike testing
b.      Volume testing
c.       Transaction testing
d.      Endurance testing

Which of the following is not a client side statistics in load testing
a.       Hits per second
b.      Throughput
c.       Cache hit ratio
d.      Transaction per second

Feasibility study is more important before load testing
a.      Web Applications
b.      Client-server applications
c.       Mainframe applications
d.   Citrix applications

Basic Automation Concept :

Tools usage
  1. very helpful in regression testing
  2. saves time
  3. helpful in simulating Users
  4. all of the above.
The following five tasks are needed to develop, use and maintain Test scripts.
1)      Unit scripting
2)      Pseudoconcurrency scripting
3)      Integration scripting
4)      Regression Scripting
5)      Stress/Performance Scripting.

What is the scenario in which automation testing can be done:  
1)      Application is stable
2)      Usability testing is to be done
3)      The project is short term
4)      Long term project having numerous releases

What is the common limitation of automated testing?  
    1. They are not useful for performance testing
    2. They cannot be used for requirement validation
    3. It is very difficult for automated scripts to verify a wide range of application responses.
    4. They are not useful when requirements are changing frequently
The extent of automation for a given project is generally guided by  
    1. Scope for automation
    2. Tool support
    3. Business Functionality
    4. Vendor’s skills
What are the main attributes of test automation  
1. Time saving
2. Correctness
3. Less Manpower
4. More reliable

Some of the common problems of test automation are  
    1. Changing requirements
    2. Lack of time
    3. Both a and b
    4. None of the above

Manual Testing Interview Questions 1

Manual Testing interview questions continued from the 

What is the need for test planning
            a. to utilize a balance of testing techniques
            b. to understand testing process
            c. to collect metrics
            d. to perform ad hoc testing.

Which of the following is NOT a part of Test plan document?
            a. assumptions
            b. communication approach
            c. risk analysis
            d. status report

Which part of Test plan will define “what will and will not be covered in the test”?
            a. test scope
            b. test objective
            c. both a & b
            d. none of the above

Test objective is simply a testing
            a. direction
            b. vision
            c. mission
            d. goal

Which out of the below is NOT a concern for testers to complete a test plan ?
            a. not enough training
            b. lack of test tools
            c. enough time for testing
            d. rapid change

The effort taken to create a test plan should be
            a. half of the total test effort
            b. one-third of the total test efforts
            c. two times of the total test effort
            d. one-fifth of the total test effort

What do you mean by “Having to say NO”
            a. No, the problem is not with testers
            b. No, the software is not ready for production
            c. Both a & b
            d. none of the above

Tools like change Man, Clear case are used as
            a. functional automation tools
            b. performance testing tools
            c. configuration management tools
            d. none of the above.

Which is not the Phase of SDLC?
a.       Initiation Phase
b.      Definition Phase
c.       Planning Phase
d.      Programming and Training Phase

Comparison of the expected benefit versus the cost of the solution is done in which phase of SDLC
a)      Definition Phase
b)      Design Phase
c)      Initiation Phase
d)     Implementation Phase

Who is policy/oversight participant in SDLC?
a.       Project Manager
b.      Contracting Officer
c.       Information Technology Manger
d.      Information Resources Management official

Who reviews proposed procurement for sufficiency in the acquisition and installation of the Off-the-Self Software?
a.       Sponsor / User
b.      Project Manager
c.       IT Manger
d.      All of the Above

 “V” testing process is
a. System development process and system test process begins
b. Testing starts after coding is done
c. Do procedures are followed by Check procedures
d. Testing starts after the prototype is done

Validation is
    1. Execute test
    2. Review code
    3. Desk check
    4. Audit
 Which is not in sequence in 11 Step Software Testing process
a.       Assess development plan and status
b.      Develop the test plan
c.       Test software design
d.      Test software requirement
Structural testing is
a.      Requirements are properly satisfied by the application
b.      Uncover errors during “Coding” of the program
c.       Functions works properly
d.      To test how the business requirements are implemented.

Functional testing is
a. Path testing
b. Technology has been used properly
c. Uncover errors that occurs in implementing requirements.
d. Uncover errors in program unit.

Structural testing is NOT
a. Installation testing
b. Stress testing
c. Recovery testing
d. Compliance testing

Stress testing transaction can be obtained from
a. Test data generators
b. Test transactions created by the test group
c. Transactions previously processed in the production environment
d. All of the above.

Who will assess vulnerability in the system
a.      Internal Control Officer
b.      System Security Officer
c.       QA Engineer
d.      Test Manager

What is the structure testing process
a. Parallel
b. Regression
c. Stress
d. Intersystem

Acceptance requirements that a system should meet is
a. Usability
b. Understandability
c. Functionality
d. Enhancements

Testing techniques that can be used in acceptance testing are
a. Structural
b. Functional
c. Usability
d. A and B
e.  B and C

For final software acceptance testing, the system should include
a. Delivered software
b. All user documents
c. Final version of other software deliverables
d. All of the above

Acceptance testing means
a. Testing performed on a single stand – alone module or unit of code
b. Testing after changes have been made to ensure that no unwanted changes were introduced
c. Testing to ensure that the system meets the needs of the organization and end user.
d. Users test the application in the developers environment

Acceptance tests are normally conducted by the
a. Developer
b. End users
c. Test team
d. Systems engineers

Which is not test result data
a. Test factors
b. Interface objective
c. Platform
d. Test estimation

What type of test that will be conducted during the execution of tests, which will be based on software requirements. What category of status data I am looking?
a. Test Result
b. Test Transaction
c. Defects
d. Efficiency

Summary (project)status report provides
a. General view of a project
b. General view of all the projects
c. Detailed view of all the projects
d. Detailed information about a project

Project status report provides
a. General view of a project
b. General view of all the projects
c. Detailed view of all the projects
d. Detailed information about a project

What is not the primary data given by the tester in test execution
a. Total number of tests
b. Number of test cases written for change request
c. Number of test executed to date
d. Number of tests executed successfully to date

Do the current project results meet the performance requirements? Which section of Project Status Report I should look for
a. Vital Project Information
b. General Project Information
c. Project Activities Information
d. Essential Elements Information

Which is a section of Summary status report
a. Vital project information
b. Essential elements information
c. Project activities information
d. Time Line information

Test Result data is
a. Test Transactions
b. Test events
c. Business Objectives
d. Reviews

What type of efficiency can be evaluated during testing?
a. Software system
b. Testing
c. Development
d. A and C
e.       A and B
What is the purpose of code coverage tools?
                          a. They are used to show the extent to which the logic in the program was executed    during testing.
                          b. They are used as an alternative to testing
                           c. They are used to compile the program

Four examples of test specific metrics.
a. Testing Effort variation, Defect Density, Testing Efficiency, Requirements tested.
b. Inspection, review efficiency, Testing Effort variation, Defect Density
c. Test scalability, Defect deviation, Testing Efficiency, Schedule variation
Give one commonly recognized size measurement tool.
a.   Effort analysis
b.      LCO Analysis

c.       LOC Analysis

d.      Code Analysis

Give three components included in a system test report.

a. Description of Testing; resource requirement; and Recommendation

         b. Testing requirements; defects; and usability
         c. Description of test results and findings (defects); Summary (environment and references); and Recommendation

Non Statistical tools are used in the
  1. Work Practice process
  2. Benchmarking process
  3. Both A and B
  4. None of the above

Quality Function deployment (QFD) is a
a.       Statistical tool
b.      Non statistical tool
c.       Development tool
d.      None of the above

The Sequence of the four Phases involved in Bench marking process is
a.       Action, Planning, Integration, Analysis
b.      Planning, Analysis, Integration, Action
c.       Analysis, Planning, Integration, Action
d.      Analysis, Action, Planning, Integration

Defect Density is calculated by
a.      Total no. of Defects/ Effort
b.      Valid Defects/ Total no. of Defect
c.       Invalid Defects/ Valid Defects
d.      Valid Defects/ Effort

Effort Variation is calculated by
a.       (Planned – Actual)/ Actual
b.      (Actual – Planned) / Actual
c.       (Actual – Planned) / Planned
d.      (Planned – Actual)/ Planned

Percentage Rework is calculated by
a.       (Review effort + rework effort)/ Actual Effort expended
b.      (Review effort - rework effort)/ Actual Effort expended
c.       Rework Effort / Planned Effort
d.      Rework Effort / Actual Effort expended

A quantitative measurement used to determine the test completion is
a.       Defect measurement
b.      Requirements coverage
c.       Statistical Analysis
The categories of Error Oriented Techniques are 
a)      Statistical assessment and Error-based testing
b)      Error-based testing and Fault based testing.
c)      Fault based testing and Statistical assessment
d)     Statistical assessment, Error-based testing and Fault based testing.

The following factors should be considered for the Test Tool selection
1.      Test Phase
2.      Test Objective
3.      Test Technique         
4.      Test Deliverable

Equivalence partitioning consists of various activities:
               a). Ensure that test cases test each input and output equivalence class at least once
   b). Identify all inputs and all outputs
   c). Identify equivalence classes for each input
   d). All of the above

It’s an unfair test to perform stress testing at the same time you perform load testing
a)      True
b)     False

Verification activities during design stages are
a)      Reviewing and Inspecting
b)      Inspecting and Testing
c)      Reviewing and Testing
d)     Reviewing, Inspecting and Testing.

Testing, which is carried out using no recognized test case design
a)      Failure Testing
b)     Adhoc Testing
c)      Exhaustive Testing
d)     Empty test case Testing

A test case design technique for a component in which test cases are designed to execute statements is called as ?
a)      State transition Testing
b)      Static Testing
c)      Transition testing
d)     Statement testing

For more on Interview questions on Software Manual testing
For more articles on Manual testing log on to : Manual Testing

Common Sql Queries Interview Questions 4

Common SQL Queries Interview Questions : While we have quite a good number of DBMS softwares in the industry, they all follow some standardization to bring a sense of uniformity of technology .This is the basic reason as to why inspite of so many dbms softwares such as oracle, sql server, db2,sybase and the much well known open source stuff mysql, they all hold the same language in place to perform various database related operations which is called Sequel and abbreviated as SQL. SQL stands for standard query language. Here in below post and quite a number of other database testing related post you will have ample exposure to how SQL queries make our database testing possible.


CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition

11. In a table how can one find all of the employees whose first name does not start with 'M' or 'A'.
SELECT EmployeeID, FirstName, LastName, HireDate, City FROM Employees
WHERE (FirstName NOT LIKE 'M%') AND (FirstName NOT LIKE 'A%')

12.Find the wine(s) sold for the highest 
Sells(bar, wine, price)

FROM Sells
WHERE price >= ALL(
SELECT price
FROM Sells
wines(name, manf)

13.Find the wines that are the unique wine by their manufacturer
SELECT nameFROM wines w1
FROM wines
WHERE manf = w1.manf AND
name <>

14.Find the name and manufacturer of wines that  James like
wines (name, manf) Likes(drinker, wine)
FROM wines
(SELECT wine
FROM Likes
WHERE drinker = ‘James’

15.Find bars that serve Mike at the same price James
charges for Bille.
Sells(bar, wine, price)

FROM Sells
WHERE wine = 'Mike' AND
price =
(SELECT price
FROM Sells
WHERE bar = 'James''s Bar' AND
wine = 'Bille'

16.Find pairs of wines by the same manufacturer.
Wines(name, manf)
FROM Wines w1, Wines w2
WHERE w1.manf = w2.manf AND <;

17.Find the wines that the frequenters of James’s Bar
Likes(drinker, wine)
Frequents(drinker, bar)
FROM Frequents, Likes
WHERE bar = 'James''s Bar' AND
Frequents.drinker = Likes.drinker;

18.Find drinkers whose phone has exchange 555.
Drinkers(name, addr, phone)
FROM Drinkers
WHERE phone LIKE '%555- ';

19.Find the price James's Bar charges for Bille.
Sells(bar, wine, price)
SELECT price
FROM Sells
WHERE bar = 'James''s Bar' AND wine = 'Bille';

20. How to find out the 10th highest salary in SQL query?
Table - Tbl_Test_Salary 
Column - int_salary

select max(int_salary) 
from Tbl_Test_Salary 
where int_salary in(select top 10 int_Salary from Tbl_Test_Salary order by int_salary)

Browse for more Database Testing Related Posts 

Common Sql Queries Interview Questions 4
For more articles on Manual Testing Log On to Manual Testing Articles