Font size
S
M
L
XL
WorksheetsFinal Evaluation - QA-BA Training
Total questions: 125
Worksheet time: 4hrs 10mins
Name
Class
Date
1.
Whose responsibility it is to conduct interviews with the users and understand their requirements?
a)
Steering Committee
b)
Project managers
c)
Business Analyst
d)
Domain Specialist
2.
Identify which of the following life cycle contains the phases: test case design, test execution, defect tracking, maintenance.
a)
SDLC
b)
STLC
c)
SQLC
d)
BLC
3.
Identify the term which is known as a variance from software product specifications?
a)
Report
b)
Defect
c)
Review
d)
Requirement
4.
The work associated with software development can be categorized into three generic phases, regardless of application area, project size, or complexity, namely the ________ phase which focuses on what, the ________ phase which focuses on how and the ________ phase which focuses on change.
1. Support
2. Development
3. Definition
a)
1, 2, 3
b)
2, 1, 3
c)
3, 2, 1
d)
3, 1, 2
5.
Risk analysis of a project is done in :
a)
System Analysis phase
b)
Feasibility Study
c)
Implementation phase
d)
Maintenance phase
6.
Which of the following property does not correspond to a good Software Requirements Specification (SRS) ?
a)
Verifiable
b)
Ambiguous
c)
Complete
d)
Traceable
7.
“Consider a system where, a heat sensor detects an intrusion and alerts the security company.” What kind of a requirement the system is providing ?
a)
Functional
b)
Non-Functional
c)
Known Requirement
d)
None of the mentioned
8.
Software Maintenance includes
a)
Error corrections
b)
Enhancements of capabilities
c)
Deletion of obsolete capabilities
d)
All of the mentioned
9.
Which of the following is not the primary objectives in the Preliminary investigation of system development?
a)
Assess cost and benefit of alternative approces
b)
determining the size of the project
c)
Preparing the SRS to cover all the system specifications
d)
Report finding to the management with recomendation to accept or reject the proposal
10.
What is the purpose of a primary key in a database?
a)
It ensures uniqueness and identifies each record in a table.
b)
It establishes a relationship between two tables.
c)
It allows for data manipulation and retrieval.
d)
It defines the data type of a column.
11.
Which concept is used to establish a relationship between two tables in a database?
a)
Primary key
b)
Foreign key
c)
Data type
d)
Operator
12.
Which SQL statement is used to create a new database?
a)
SQL CREATE Database
b)
SQL CREATE Table
c)
SQL INSERT
d)
SQL UPDATE
13.
Which SQL statement is used to insert new records into a table?
a)
SQL CREATE Database
b)
SQL CREATE Table
c)
SQL INSERT
d)
SQL UPDATE
14.
Which SQL statement is used to modify existing records in a table?
a)
SQL ALTER
b)
SQL DROP
c)
SQL UPDATE
d)
SQL DELETE
15.
Which SQL statement is used to delete records from a table?
a)
SQL ALTER
b)
SQL DROP
c)
SQL UPDATE
d)
SQL DELETE
16.
What does the SQL SELECT statement do?
a)
It creates a new table in the database.
b)
It modifies the structure of an existing table.
c)
It retrieves data from one or more tables.
d)
It deletes records from a table.
17.
Which SQL clause is used to specify a condition in a SELECT statement?
a)
SQL WHERE
b)
SQL DISTINCT
c)
SQL AND
d)
SQL OR
18.
Which SQL operator is used to retrieve unique values in a SELECT statement?
a)
SQL WHERE
b)
SQL DISTINCT
c)
SQL AND
d)
SQL OR
19.
Which SQL operator is used to combine multiple conditions in a SELECT statement?
a)
SQL WHERE
b)
SQL DISTINCT
c)
SQL AND
d)
SQL OR
20.
Which SQL operator is used to retrieve records from two or more tables?
a)
SQL UNION
b)
SQL UNION ALL
c)
SQL AND
d)
SQL OR
21.
Which SQL operator is used to retrieve all records from two or more tables, including duplicates?
a)
SQL UNION
b)
SQL UNION ALL
c)
SQL AND
d)
SQL OR
22.
Which SQL wildcard character represents any number of characters?
a)
%
b)
_
c)
*
d)
#
23.
What is user-interface ?
a)
Helps users to communicate using windows, icons with the computer system and application system
b)
It converts program to machine language form
c)
Transmit data to a remote location as packets
d)
None of these
24.
ER diagram is related with :
a)
Entity Relationship
b)
Data flow
c)
Foreign key
d)
System testing
25.
Identify the disadvantage of Spiral Model
a)
Doesn’t work well for smaller projects
b)
High amount of risk analysis
c)
Strong approval and documentation control
d)
Additional Functionality can be added at a later date
26.
Requirements analysis is critical to the success of a development project.
a)
True
b)
False
c)
Depends upon the size of project
d)
None of the mentioned
27.
Which one of the following models is not suitable for accommodating changes?
a)
Spiral model
b)
Prototyping Model
c)
Agile Model
d)
Waterfall Model
28.
What is Agile's highest priority?
a)
The continuous delivery of software
b)
The continuous integration of software
c)
The continuous deployment of software
d)
The continuous maintenance of software
29.
____________ and ____________ are not the subject matter of Requirement Analysis.
a)
Performance, modelling present system
b)
Stakeholder knowledge of computers, Developer’s staff
c)
Functional, Non-Functional
d)
internal controls, present system work load
30.
Which is the following is the most important feature of the spiral model?
a)
Efficiency Management
b)
Time Management
c)
Risk Management
d)
Quality management
31.
Which of the following is not included in SRS ?
a)
Performance
b)
Functionality
c)
Design solutions
d)
External Interfaces
32.
Which of the following is the first step of SDLC?
a)
Coding
b)
Design
c)
Analysis
d)
Testing
33.
"Using CASE Tools”. CASE stands for
a)
Cost Aided Software Engineering
b)
Computer Aided Software Engineering
c)
Control Aided Software Engineering
d)
None of the mentioned
34.
The modification of the software to match changes in the ever changing environment, falls under which category of software maintenance?
a)
Corrective
b)
Adaptive
c)
Perfective
d)
Preventive
35.
“Robustness” answers which of the following description?
a)
CASE tools be used to support the process activities
b)
Process errors are avoided or trapped before they result in product errors
c)
Defined process is acceptable and usable by the engineers responsible for producing the software
d)
Process continues in spite of unexpected problems
36.
In which type of interface users provide commands selecting from a menu ?
a)
Command Line User Interface
b)
Graphical User Interface
c)
Voice Recognition User Interface
d)
None of these
37.
The process of hiding internal and implementation details and just representing major functionalities is known as :
a)
Abstraction
b)
Encapsulation
c)
Dynamic Binding
d)
Static Binding
38.
In which phase of the System Development Life Cycle(SDLC), users or developers may discover errors or problems that cause the entire process to start over again?
a)
System Analysis
b)
System Design
c)
System Implementation
d)
System Maintenance
39.
Which type of user interface provide input by typing a string in the keyboard ?
a)
Command Line User Interface
b)
Graphical User Interface
c)
Voice Recognition User Interface
d)
None of these
40.
UML stands for
a)
Unified Modeling Language
b)
Unified Modular Language
c)
Unique Modeling Language
d)
None of the above
41.
How many levels are there in Tesing?
a)
5
b)
6
c)
4
d)
3
42.
Which of the following is a common testing conducted by the developers?
a)
Acceptance testing
b)
Unit testing
c)
System Testing
d)
None of these
43.
Another name for white-box testing is ___________
a)
Control testing
b)
Graybox
c)
Glassbox
d)
Black box
44.
The testing which is done by going through the code is known as
a)
Unit Testing
b)
Black Box Testing
c)
White Box Testing
d)
Regression Testing
45.
Boundary Value Analysis belongs to which testing method?
a)
Black Box
b)
White Box
c)
It's not even a technique
d)
None of these
46.
What are the Types of Integration Testing?
a)
Bottom Up
b)
Top Down
c)
Hybrid
d)
All of the above
47.
Which is non-functional software testing?
a)
Unit Testing
b)
Black Box Testing
c)
Performance Testing
d)
Regression Testing
48.
Which SQL wildcard character represents a single character?
a)
%
b)
_
c)
*
d)
#
49.
Which SQL operator is used to retrieve records that match a specific pattern?
a)
SQL LIKE
b)
SQL IN
c)
SQL BETWEEN
d)
SQL ORDER BY
50.
Which SQL operator is used to retrieve records that match multiple values?
a)
SQL LIKE
b)
SQL IN
c)
SQL BETWEEN
d)
SQL ORDER BY
51.
Which SQL operator is used to retrieve records within a specific range?
a)
SQL LIKE
b)
SQL IN
c)
SQL BETWEEN
d)
SQL ORDER BY
52.
Which phase of the Software Testing Life Cycle (STLC) involves reviewing the requirements?
a)
Test Planning
b)
Test Case Development
c)
Test Environment Setup
d)
Requirement Analysis
53.
Which phase of the STLC involves creating a master test plan?
a)
Test Planning
b)
Test Execution
c)
Test Cycle Closure
d)
Test Case Development
54.
Which type of testing involves testing the individual components or modules of the software?
a)
System Testing
b)
Integration Testing
c)
Unit Testing
d)
Acceptance Testing
55.
What is the purpose of a traceability matrix?
a)
To track test cases and their results
b)
To map requirements to test cases
c)
To identify defects and their root causes
d)
To monitor progress during test execution
56.
Which test case design technique involves selecting values that are on the edge of input domains?
a)
Boundary Value Analysis
b)
Equivalence Partitioning
c)
Decision Table
d)
State Transition Diagram
57.
What is the purpose of regression testing?
a)
To test new functionality added to the software
b)
To ensure that defects have been fixed correctly
c)
To ensure that existing functionality still works after changes are made
d)
To ensure that the software meets user requirements
58.
Which test case design technique involves dividing the input domain into groups of data that are expected to behave similarly?
a)
Boundary Value Analysis
b)
Equivalence Partitioning
c)
Decision Table
d)
State Transition Diagram
59.
Which level of testing involves testing the software's compliance with non-functional requirements?
a)
System Testing
b)
Integration Testing
c)
Unit Testing
d)
Non-Functional Testing
60.
What is the purpose of smoke testing?
a)
To ensure that critical functionality works before starting full testing
b)
To ensure that the software meets user requirements
c)
To test new functionality added to the software
d)
To test the software's performance under load
61.
Which SQL clause is used to sort the result set in ascending or descending order?
a)
SQL LIKE
b)
SQL IN
c)
SQL BETWEEN
d)
SQL ORDER BY
62.
Which SQL clause is used to group rows based on a specified condition?
a)
SQL WHERE
b)
SQL DISTINCT
c)
SQL GROUP BY
d)
SQL HAVING
63.
Which SQL clause is used to filter grouped records in a SELECT statement?
a)
SQL WHERE
b)
SQL DISTINCT
c)
SQL GROUP BY
d)
SQL HAVING
64.
What is the main difference between the HAVING and WHERE clauses in SQL?
a)
The HAVING clause is used with aggregate functions, while the WHERE clause is used with individual rows.
b)
The HAVING clause is used for filtering, while the WHERE clause is used for grouping.
c)
The HAVING clause is used for sorting, while the WHERE clause is used for joining tables.
d)
The HAVING clause is used for subqueries, while the WHERE clause is used for outer joins.
65.
Which SQL function is used to perform calculations on a set of values and return a single value?
a)
Aggregate functions
b)
String functions
c)
Numeric functions
d)
Conversion functions
66.
Which SQL function is used to concatenate two or more strings?
a)
Aggregate functions
b)
String functions
c)
Numeric functions
d)
Conversion functions
67.
Which type of SQL join returns only the matching records between two tables?
a)
INNER JOIN
b)
OUTER JOIN
c)
LEFT JOIN
d)
RIGHT JOIN
68.
Which type of SQL join returns all records from the left table and matching records from the right table?
a)
INNER JOIN
b)
OUTER JOIN
c)
LEFT JOIN
d)
RIGHT JOIN
69.
Who writes the Software Requirement Specifications Document(SRS)?
a)
Developer
b)
Business Analyst
c)
Tester
d)
None of these above
70.
What is the final outcome of the requirements analysis and specifications phase ?
a)
Drawing the data flow diagram
b)
The SRS Document
c)
Coding the project
d)
The User Manual
71.
SRS document is called black box specification of a system because
a)
It does not contain the contradictory materials
b)
It does not contain the user documentation
c)
SRS document should specify only the external behaviour of the system
d)
None of these above
72.
The type of software testing in which each module is tested along in an attempt to discover any errors in its code, is known as
a)
Integration testing
b)
Acceptance testing
c)
System testing
d)
Unit testing
73.
Which of the following quality of SRS document ensures to compare the results of a phase with another phase?
a)
Structured
b)
Verifiable
c)
Traceable
d)
Concise
74.
Testing can be applied to:
a)
Requirements
b)
Analysis
c)
Design
d)
Code
75.
Running the system under a live environment using Live data in order to find errors is known as
a)
Beta Testing
b)
Alpha Testing
c)
Acceptance Testing
d)
System Testing
76.
The goal of reading SRS document by the software developer is to :
a)
ensure requirements are understandable from a functionality point of view
b)
understand the features of the product
c)
ensure that the software is developed as per customer needs
d)
None of these above
77.
“Black” refers in the “Black-box” testing means
a)
Characters of the movie “Black Adam”
b)
I – O is hidden
c)
Source Code is hidden
d)
Users are hidden
78.
Which one of the following testing is performed by user?
a)
Acceptance testing
b)
Unit testing
c)
Compatibility testing
d)
None of these
79.
Which of the following is not included in the Software Requirements Specification(SRS) Document ?
a)
Functional Requirements
b)
Non-Functional Requirement
c)
Goals of Implementation
d)
User Manual
80.
Which type of SQL join returns all records from the right table and matching records from the left table?
a)
INNER JOIN
b)
OUTER JOIN
c)
LEFT JOIN
d)
RIGHT JOIN
81.
Which SQL statement is used to create a new table in the database?
a)
SQL CREATE Database
b)
SQL CREATE Table
c)
SQL INSERT
d)
SQL UPDATE
82.
Which SQL statement is used to modify the structure of an existing table?
a)
SQL ALTER
b)
SQL DROP
c)
SQL UPDATE
d)
SQL DELETE
83.
Which SQL statement is used to remove a table from the database?
a)
SQL ALTER
b)
SQL DROP
c)
SQL UPDATE
d)
SQL DELETE
84.
Which SQL statement is used to retrieve records from one or more tables based on specified conditions?
a)
SQL SELECT
b)
SQL WHERE
c)
SQL DISTINCT
d)
SQL ORDER BY
85.
Which SQL statement is used to combine the result sets of two or more SELECT statements?
a)
SQL UNION
b)
SQL UNION ALL
c)
SQL JOIN
d)
SQL DISTINCT
86.
Which SQL statement is used to retrieve distinct values from a column?
a)
SQL UNION
b)
SQL UNION ALL
c)
SQL JOIN
d)
SQL DISTINCT
87.
Which test case design technique involves identifying all possible scenarios that could occur during software use?
a)
Boundary Value Analysis
b)
Equivalence Partitioning
c)
Decision Table
d)
Use Case Testing
88.
Which level of testing involves testing the software's compatibility with different hardware, software, and network configurations?
a)
Compatibility Testing
b)
System Testing
c)
Integration Testing
d)
Acceptance Testing
89.
Which test case design technique involves creating a table that shows all possible combinations of input conditions and expected results?
a)
Boundary Value Analysis
b)
Equivalence Partitioning
c)
Decision Table
d)
Use Case Testing
90.
Which type of testing involves testing the software's ability to handle different user roles and access levels?
a)
Performance Testing
b)
Compatibility Testing
c)
Security Testing
d)
Recovery Testing
91.
Which test case design technique involves creating a diagram that shows the different states that the software can be in and the transitions between them?
a)
Boundary Value Analysis
b)
Equivalence Partitioning
c)
State Transition Diagram
d)
Use Case Testing
92.
Which level of testing involves testing the software's compliance with user requirements?
a)
System Testing
b)
Integration Testing
c)
Acceptance Testing
d)
Regression Testing
93.
What is the difference between quality assurance (Qand quality control (QC)?
a)
QA ensures that defects are prevented, while QC ensures that defects are identified and fixed
b)
QA and QC are the same thing
c)
QA involves testing the software, while QC involves reviewing the requirements
d)
QA ensures that the software meets user requirements, while QC ensures that the software is bug-free
94.
Which test case design technique involves creating a narrative that describes how the software will be used?
a)
Boundary Value Analysis
b)
Equivalence Partitioning
c)
Test Scenario
d)
Decision Table
95.
Which type of testing involves testing the software's ability to handle high levels of traffic or data?
a)
Performance Testing
b)
Scalability Testing
c)
Security Testing
d)
Compatibility Testing
96.
Which level of testing involves testing the software's internal logic and code structure?
a)
System Testing
b)
Integration Testing
c)
Unit Testing
d)
Acceptance Testing
97.
Which SQL statement is used to filter rows based on multiple conditions using logical operators?
a)
SQL AND
b)
SQL OR
c)
SQL BETWEEN
d)
SQL IN
98.
Which SQL statement is used to filter rows based on multiple conditions using logical operators, allowing for either condition to be true?
a)
SQL AND
b)
SQL OR
c)
SQL BETWEEN
d)
SQL IN
99.
Which SQL operator is used to combine the result sets of two or more SELECT statements, including duplicates?
a)
SQL UNION
b)
SQL UNION ALL
c)
SQL JOIN
d)
SQL DISTINCT
100.
Which SQL wildcard character represents any sequence of characters, including no characters?
a)
%
b)
_
c)
*
d)
#
101.
Which SQL operator is used to retrieve records that match a specific pattern?
a)
SQL LIKE
b)
SQL IN
c)
SQL BETWEEN
d)
SQL ORDER BY
102.
Which SQL operator is used to retrieve records that match any of the specified values?
a)
SQL LIKE
b)
SQL IN
c)
SQL BETWEEN
d)
SQL ORDER BY
103.
Which SQL operator is used to retrieve records that fall within a specified range of values?
a)
SQL LIKE
b)
SQL IN
c)
SQL BETWEEN
d)
SQL ORDER BY
104.
Which SQL clause is used to sort the result set in ascending order?
a)
SQL ASC
b)
SQL DESC
c)
SQL ORDER BY
d)
SQL GROUP BY
105.
Which SQL clause is used to sort the result set in descending order?
a)
SQL ASC
b)
SQL DESC
c)
SQL ORDER BY
d)
SQL GROUP BY
106.
Which SQL clause is used to group rows based on a specified column?
a)
SQL WHERE
b)
SQL DISTINCT
c)
SQL GROUP BY
d)
SQL HAVING
107.
Which SQL clause is used to filter grouped records in a SELECT statement?
a)
SQL WHERE
b)
SQL DISTINCT
c)
SQL GROUP BY
d)
SQL HAVING
108.
Which type of testing involves testing the software's ability to handle unexpected or invalid inputs?
a)
Boundary Value Analysis
b)
Equivalence Partitioning
c)
Exception Handling Testing
d)
Usability Testing
109.
Which test case design technique involves creating a table that shows the expected results for different combinations of input values?
a)
Boundary Value Analysis
b)
Equivalence Partitioning
c)
Decision Table
d)
Use Case Testing
110.
Which type of testing involves testing the software's ability to handle different types and volumes of data?
a)
Performance Testing
b)
Security Testing
c)
Compatibility Testing
d)
Recovery Testing
111.
Which level of testing involves testing the software as a whole, including all of its components and subsystems?
a)
System Testing
b)
Integration Testing
c)
Acceptance Testing
d)
Regression Testing
112.
Which type of testing involves testing the software's ability to handle multiple users accessing it simultaneously?
a)
Performance Testing
b)
Security Testing
c)
Compatibility Testing
d)
Recovery Testing
113.
Which test case design technique involves dividing the input range into smaller, manageable segments?
a)
Boundary Value Analysis
b)
Equivalence Partitioning
c)
Decision Table
d)
Use Case Testing
114.
Which level of testing involves testing the software's ability to handle changes or upgrades to the system or environment?
a)
System Testing
b)
Integration Testing
c)
Acceptance Testing
d)
Regression Testing
115.
Which type of testing involves testing the software's ability to handle different screen sizes, resolutions, and orientations?
a)
Performance Testing
b)
Usability Testing
c)
Compatibility Testing
d)
Security Testing
116.
Which type of testing involves testing the software's ability to handle large amounts of data or traffic over a long period of time?
a)
Performance Testing
b)
Scalability Testing
c)
Security Testing
d)
Recovery Testing
117.
Which level of testing involves testing the software's ability to integrate with other systems or components?
a)
System Testing
b)
Integration Testing
c)
Acceptance Testing
d)
Regression Testing
118.
Which test case design technique involves creating a diagram that shows the different actors and their interactions with the software?
a)
Boundary Value Analysis
b)
Equivalence Partitioning
c)
Use Case Testing
d)
Decision Table
119.
What is the main difference between the HAVING and WHERE clauses in SQL?
a)
The HAVING clause is used for filtering grouped records, while the WHERE clause is used for individual rows.
b)
The HAVING clause is used for joining tables, while the WHERE clause is used for sorting.
c)
The HAVING clause is used for subqueries, while the WHERE clause is used for aggregate functions.
d)
The HAVING clause is used for grouping, while the WHERE clause is used for selecting specific columns.
120.
Which SQL function is used to perform calculations on a set of values and return a single value?
a)
Aggregate functions
b)
String functions
c)
Numeric functions
d)
Conversion functions
121.
Which SQL function is used to manipulate and perform operations on strings?
a)
Aggregate functions
b)
String functions
c)
Numeric functions
d)
Conversion functions
122.
Which type of SQL join returns all records from the left table and matching records from the right table, filling unmatched values with NULL?
a)
INNER JOIN
b)
OUTER JOIN
c)
LEFT JOIN
d)
RIGHT JOIN
123.
Which type of SQL join returns all records from the right table and matching records from the left table, filling unmatched values with NULL?
a)
INNER JOIN
b)
OUTER JOIN
c)
LEFT JOIN
d)
RIGHT JOIN
124.
Which SQL statement is used to create a new table in the database?
a)
SQL CREATE Database
b)
SQL CREATE Table
c)
SQL INSERT
d)
SQL UPDATE
125.
Which SQL statement is used to modify the structure of an existing table?
a)
SQL ALTER
b)
SQL DROP
c)
SQL UPDATE
d)
SQL DELETE
Reset
