Software Design
1) Software design broadly classified in to
a) Software
architectural design
b) Software structural design
c) Software
details design
d) Software module design
**Can select multiple options
2) What are the key issues in software design?
a) Concurrency
b) Enabling techniques
c) Data
persistence
d) Design process
**Can select multiple options
3) What are all the software design strategies and
methods?
a) Function oriented design
b) Object oriented design
c) Data structured design
d) Component based design
e) All of the
above
**Can select multiple options
4) What are the components builds the architectural
design?
a) Functional
requirements
b) Design
constraints
c) Quality
attribute requirements
d) None of the above
**Can select multiple options
5) Match the following based on how they depend to
one another.
a) User
requirement specification 1) Customer
acceptance testing
b) Functional
design specification 2) Coding
integration and testing
c) Software
design specification 3) Module
testing
6) What are the enabling techniques in software
design principles?
a) Abstraction
b) Coupling cohesion
c) Decomposition
d) Modularization
e) Encapsulation/information hiding
f) Option a & c
g) Option a, b,d,e
h) Option
a,b,c,d,e
i) None of the above
7) State true or false
Error and
exception handling and fault tolerance are some of the key issues in software
design? T or F
8) State true or false
Sufficiency, completeness and primitiveness are not some part of the
enabling techniques T or F?
9) Select the correct option available in software
design notations?
a) Structural descriptions
b) Behavior description
c) Both a &
b
10) Match the following
1) Structural description a) static view
2) behavior description b) dynamic view
Testing Scenarios
1. Test scenarios is used in identifying
A.
Identifying defects which might go undetected during execution of separate test
cases.
B.
Identifying testable requirements.
C.
Identifying business scenarios.
D. None of the above.
2. Test design should include
A. Normal conditions
B. error conditions
C.
both normal & error conditions
D. None of the above.
3. Test scenarios are generated using
A. class diagrams
B. sequence diagrams
C. collaboration diagrams
D.
use case Modeling techniques.
4. In test scenarios alternate flows
cannot be tested by themselves
A.
True
B. False
5. What are the components of test
scenarios
A.
Scenario #
B.
Reference document
C. User id
D. None of the above.
6. Good test scenarios should include
A.
Basic flows
B. Alternate flows
C.
Both A & B
D. none of the above
7. Significance of test scenario are
A.
Clear & simple flow
B.
Hypothetical stories
C.
Realistic events of application
D. None of the above.
8. The test design process has
A. Test scenario
B. Test development
C.
both A & B
9. A test scenarios do not have
A.
case specific data values assigned to them.
B. Business rules
C. Normal conditions.
10. Is it necessary to consider
exception flow while modeling use case diagram for test scenarios
A.
True
B. False
SOFTWARE QULAITY
MANAGEMENT
1.Software quality management processes
used for?
a. Defining the process
b. Specifies the process owner
c.
Both a and b
d. None of the above
2. Quality assurance is used for
a. Auditing and reporting function
b. Completeness of quality
c. User satisfaction
d.
All the above
3. how many types of reviews used in
SQM?
a.4
b.2
c.5
d.3
4. What is an Inspection?
a.
Detect s/w and identify s/w product
b. Evaluate s/w product
c. Both a and b
d. None of the above
5.What is Walkthrough?
a.
Evaluate s/w product
b. Detect s/w product
c. identify s/w product
d. None of the above
6. What are the objectives of
walkthrough?
a. Find anomalies
b. improve the s/w product
c. Consider the alternative
implementations
d.
All the above
7. What are the software quality
Requirements?
a. Analytical technique
b. both a and c
c. Dependability
d. Integrity level
e.
both c and d.
8. What are the software quality
Management technique?
a. Static techniques
b. Integrity level.
c. Analytical techniques
d.
both a and c
e. both a and b
9. RunCharts is an example of
a.
Statistical based
b. Statistical tests
c. Trend Analysis
d. Prediction
10. Binomial test and chi squared test
is an example of
a. Statistical based
b.
Statistical tests
c. Trend Analysis
d. Prediction
SOFTWARE ENGINEERING
1) Which
is the 3rd stage under SDLC
a)Requirement
Analysis b)Evolution c)Implementation d)Testing
2)
The Software Requirements Specification does not contain which of the following
?
a)
Performance b)Scalability c) Actors & Use
cases d) Constraints
3)
Functional Requirements are also termed as
a)
Functional Specifications b) Processes c)
Behaviours d)
Capabilities
4)
Legislative Requirements comes under which category
a)Functional
/Product Requirements b)
Non-functional /Process Requirements
c)
Functional/Process Requirements d)Non-functional/ External Requirements
5)
Quantifiable requirements are the one which give Mathematical Value for any
System
a) True b)
False
6)
According to _____System means "an interacting combination of elements to
accomplish a defined objective”
a)
UNO b)UNESCO c)ISI d)INCOSE00 e)FBI
7)
Neither Market Analysts nor Customers are
categorized as Stake Holders
a)True b)False
8)
Requirement Analysis use one of the below Analysis Technique
a)LAPD b)SADT
c)NYPD c)NYNJ
9)
Process Support Management acts as a link between Process activities and____
a)Human
Resources b)Training c)Tools d)All the above
10)
.NET Platform with SQL Database are to be implemented at which stage
a)
Low level Requirement b)High level
Requirement c)Business
Application Goal
d)
Feature List
11)
why should the s/w engineer need to analyze the requirements?(check box)
a.detect and resolve the conflicts
b.discover the bounds of the s/w
c.link
the process activities identified
d.elaborate system requirements to derive s/w requirements
12.
In system design project h/w design starts from
a.identification of size and capacity requirements of hardware
b.cataloging
price from h/w vendors
c.finding
compatability between h/w and s/w
d.none
of the above
13.which
of the following is not a s/w lifecycle model?
a.spiral
model
b.waterfall
maodel
c.prototyping
model
d.CMM
14.waterfall
model is not suitable for?
a.small
projects
b.complex
projects
c.accommodating change
d.none
of the above
15.during
s/w development which factor is more crucial?
a.people
b.process
c.product
d.project
16.prototype
is a
a.working model of existing system
b.mini
model of existing system
c.working
model of processing system
d.none
of the above
TESTING-DEVELOPMENT
TEST DEVELOPMENT PROCESS
1.The
process of preparation of complete set of test cases to be performed during
testing is the test development process. say true or false
a.True
b.False
2.The test development process is based
on
a.Entry
criteria
b.Exit
criteria
c.Entry and Exit criteria
d.None
of the above
3.The popular techniques for developing
the test cases are
a.BVA(boundary
value analysis)
b.EP
c.EG
d.All the above
4.The test cases can be created based on
a.set
of inputs
b.execution
pre-condition
c.expected
outcomes
d.all the above
5.what are the elements should test
cases include?
a.description
of what requirement is being tested
b.method
of how it ill be tested
c.actions
and expected results
d. all the above
6.Multiple test cases could be generated
for a single scenario with multiple test conditions. Say true or false
a.true
b.false
7.Equivalence partitioning divides the
output data of a software unit into partions of data from which test cases can
be derived.say true or false
a.true
b.false
8.In Equivalence partitioning, the test
cases are designed to cover each partion at least
a.once
b.twice
c.thrice
d.none
of the above
9.What is a technique that consists of
developing a test cases and data that focuses on input and output boundaries of
a given function
a.Equivalence
partitioning
b.Boundary value analysis
c.Both
a and b
d.none
of the above
10.Is Boundary value analysis identify
the error at the boundaries rather than finding those that exists in the center
of the output domain.say true or false
a.true
b.false
11.The ranges of the Boundary value
analysis are
a.First
,second amd Last value of the range
b.Value
immediately below range and below last value of range
c.value
immediately above range
d.all the baove
SOFTWARE TESTING
1) Technique used for casual analysis is
A. Glass analysis, B. Fish-bone analysis, C. waterfall analysis, D. None
2) Popular methodologies of software
development
A. V model, B. Waterfall model, C.
inheritance, D.A&B, E. All above
3) What are the two process to be done
while developing software
A.
Verification & Validation, B. Validation &
Analysis, C. Both A & B,
D. None
4) Waterfall methodology consists of
A.
Sdlc & Stlc, B. Stlc & Vmodel, C. All, d.
None
5) what does test execution does
A. Selenium/Qtp, B. QC, C. Prioritizing,
D. All, E. None.
6) Each process model follows a
particular _____ in order to ensure access in process of software development
A.
Life cycle, B. Waterfall, C. Iterative, D. Vmodel
7) software testing helps to identify
_____ of the developed software
A. Correctness, B. Verification, C.
Completeness, D. A & C, E. A
& B.
8.After a tast case is designed,it
undergoes how many cycles of review?
A).Two
B).Three
C).four
9.Formal review is conducted by subject
matter experts in the absence of the author.state true or false
A).True
B).false
10.what are the benefits of review
checklist?
A).Avoids rework
B).Helps to detect defects at an earlier
stage.
C)Can be customizaed based on project
specific standards
D).All
of the above
11).what are the main activities
involved in Test Execution process
A).Re testing of defects
B).Regression testing
c).Test execution status reporting
D).all
of the above
12).What are done in defect management?
A).Defect
triaging
B).Defect
tracking
13).Defect testing
D)All of the above
6).Build verification using smoke/sanity
test is done by which team?
A).Development team
B).Build manager
C).Test
team
14.The two ways of review like formal
review and informal review is done in which type of review?
A).Self review
B).peer
review
15.Build verification and performing the
test runs are part of Test Execution process.state True or false
A).True
B).False
SOFTWARE QUALITY
1.What are the different quality
standards?
a)SMDL
b)TickIT
c)SLOI
d)CMMI
2.What
are tools which Quality objective can be met?
a)TQM
b)PCDQ
c)TSM
d)PDCA
3.Which one is not SQM process?
a)Verification process
b)Software
life cycle process
c)Review process
d)Quality assurance process
4.Finding
area of a program not exercised by a set of test cases is called…………
a)Defect Resolution
b)Coverage
Analysis
c)Risk Management
d)Test Management
5.Checking Quality of software in both simulated and live
environments is known as
a)Checking
b)Usability
c)validity
d)validation
6.
The static system model exploit which type of relationship
a)Activity cost
b)Quality
cost
c)Time cost
d)None of the above
7.Variation in debugging:coding ability
has been reported to
a)1:5
b)1:8
c)1:10
d)1:2
8.Defects caught internally deal by
discarding or repairing the defective items called
a)appraisal cost
b)internal
failure cost
c)prevention cost
d)external failure cost
9.Coding and testing is done in
following manner
a)cross_functional
b)ad_hoc
c)Bottom-up
d)Top-down
10.The largest percentage of total
life cycle software cost is
a)Design
cost
b)Coding cost
c)Maintance
cost
d) Testing cost
SOFTWARE CONSTRUCTION
1.
Construction produces high volume of
a.
configuration
items
b.Design
c.Process
2. The
fundamentals of software construction include:
a.Minimizing
complexity
b.Anticipating change
c.Constructing
for verification
d.Standards
in construction
e.all of the above
3. Standards
which directly affect construction issues include,
a.ProgrammingLanguages
b. Unified Modeling Language
b. Unified Modeling Language
c.Mainframe
d.all
of the above
4. We should construct
software that allows bugs to be easily found and fixed.
a.True
b.False
5. Do Anticipation
of change affect software construction.
a.True
b.False.
6. Construction depends on which of the following
a.
degree of the life cycle model used.
b.degree
of designing process.
7. System
testing is done by ,
a.QA engineers.
b.Developers
c.Quality Manager.
8.Unit
testing is done by ,
a.QA engineers.
b.Developers
c.Quality Manager.
9.Which of the following are Integration strategies
a.Big bang, top-down and bottom-up
b.Continuous integration
c.all
the above
10. The
important decisions are taken during which of the following phases,
a.Coding Phase
b.Testing Phase.
c.
requirements analysis and design
SQL JOINS,SUBQUERIES & VIEWS AND
INDEXES
1. Which of the following is
outer join?
a. Equi join
b.
Left outer join
c. Natural join
d.
Right outer join
2. The ON clause is used in
which of the following?
a. Theta Style
b.
ANSI Style
c. All of the above
d. None of the above.
3. The parenthesis are
strictly required in ON clause.
a. True
b.
False
4. To join tables on columns
of the same name, the ________clause can be used?
a. ON
b.
USING
c. All of the above.
5. To fetch various
combinations of two/more table records ,which join can be used?
a. Inner join
b. Outer join
c.
Cross join
d. Self join
6. The comparison operators
that are not in equi join are
a. <=
b. >=
c.
<!=>
d. =
7. The left outer join
contains
a.
All records of the left
table.
b. Only records those match
with both tables.
c. All records of the right
table.
d. Both left and right
records even if they does not match.
8. A subquery in an SQL
statement is enclosed within
a. Braces {..}
b. CAPITAL LETTERS
c.
Parantheseis (…)
d. Brackets […]
9. A subquery cannot be
immediately enclosed in a set function.
a.
True
b. False
10. The subqueries can be used
with _________ statement.
a.
Select
b.
Insert
c.
Update
d.
Delete
11. We can use a scalar
subquery in _______
a.
In the WHERE clause of a
SELECT
b. In the VALUES clause of an
UPDATE statement.
c. The SET or WHERE clauses
of an INSERT statement.
d.
The WHERE clause of a
DELETE statement.
12. The multiple row subquery
contains
a.
IN
b.
NOT IN
c. ON
d. All of the above
13. A subquery that refers to
a column of a table that is not in its FROM
clause but can be in the PROJECTION or in the WHERE clause is called_________.
a. Scalar subquery
b. Multiple Row subquery
c.
Correlated Subquery
d. Non correlated subquery
14. A virtual table that can
access the data using SQL SELECT statement is _______.
a. Index
b. Transaction
c.
View
d. None of the above.
15. Inline views does not
contain_________
a. GROUP BY
b. HAVING
c. ORDER BY
d.
USING
16. The physical order of the
rows is not the same as the index order in clustered index.
a. True
b.
False
MY-SQL
1. ____________________ is a set of programs that enables sorting,
modifying and extracting information from a database.
a. Database
b.
Database management system
c. Relational database management system
d. None of these
2. ___________________ is based on a perception of the world as
consisting of a collection of basic objects (entities)
and relationships among these objects.
a.
E-R model
b. Record based model
c. Object based model
d. Relational model
3. Data and relationships are represented by a
collection of tables. Which model?
_____________
a. E-R model
b. Record based model
c. Object based model
d.
Relational model
4. Organization of the records is as a collection
of trees, rather than arbitrary graphs. Which model? _____________
a. E-R model
b. Record based model
c. Object based model
a.
Hierarchical model
5. _____________ is the process of organizing the
fields and tables of a relational database to minimize redundancy and
dependency.
a. Redundancy
b. Consistency
c.
Normalization
d. None of these
6. ________________ normal form should have functional
dependency and remove partial dependencies.
a. First
b.
Second
c. Third
d. Bcnf
7. ________________ normal form should have functional
dependency and remove transitive dependencies.
a. Second
b. First
c.
Third
d. Bcnf
8. ______________
normal form contains each and
every determinant as a candidate key and
removes non-trival dependencies
a. Third
b. Second
c.
Bcnf
d. First
9.
_____________
normal form contains only atomic values, and the value of each attribute
contains only a single value from that domain.
a. Third
b.
First
c. Second
d. Bcnf
10. In a like clause ______________ is used for
fetching the value ending with “ton”.
A.
LIKE ton$
B. LIKE ^.*ton$
C. LIKE %ton
D. LIKE *ton
E. LIKE.*ton
B. LIKE ^.*ton$
C. LIKE %ton
D. LIKE *ton
E. LIKE.*ton
11) To remove duplicate rows from the
result set of a SELECT use the following keyword:
|
|||||
a) NO DUPLICATE
|
|||||
b) UNIQUE
|
|||||
c) DISTINCT
|
|||||
d) None of the above
|
|||||
12) A NULL value is treated as a blank or
0.
|
|||||
a) True
|
|||||
b) Fasle
|
|||||
c) None of the above
|
|||||
13) Which function used to get the current
time in mysql?
|
|||||
a) getTime()
|
|||||
b) Time()
|
|||||
c) NOW()
|
|||||
14) Which of the following is not a valid
aggregate function?
|
|||||
a) COUNT
|
|||||
b) MIN
|
|||||
c) MAX
|
|||||
d)
COMPUTE
|
|||||
16)
mysql_pconnect ()
is used to make a persistent connection to the database which means a SQL link that do not close when the execution of your script ends. |
|||||
a) True
|
|||||
b) False
|
|||||
17)
Which of the following is used to delete an entire MYSQL database?
|
|||||
a) mysql_drop_database
|
|||||
b) mysql_drop_entiredb
|
|||||
c)
mysql_drop_db
|
|||||
d) mysql_drop_dbase
|
|||||
18)
Primary Key does allow the Null Values. where as in
Unique key doesn't accept the Null values. True or False? |
|||||
a)
False
|
|||||
b) True
|
|||||
19)
How much characters are allowed to create database name?
|
|||||
a) 55
|
|||||
b) 72
|
|||||
c)
64
|
|||||
d) 40
|
|||||
20)
Which of the following commands should be used to create a database named
“student”?
|
|||||
a) CREATE ?I student
|
|||||
b)
CREATE DATABASE student
|
|||||
c) DATABASE /student
|
|||||
d) DATABSE student
|
|||||
21)
Which one will delete the table data as well as table structure?
|
|||||
a) TRUNCATE
|
|||||
b) DROP
|
|||||
22)
The USE command?
|
|||||
a) Is used to load code from another file
|
|||||
b) Has been deprecated and should be
avoided for security reasons
|
|||||
c) Is a pseudonym for the SELECT command
|
|||||
d) Should be used to choose the database you want to use once you've
connected to MySQL
|
23)
Given an employee’s table as follows:
What
value will be return by below query?
Select count(*) from employees |
||||||
a) 3
|
||||||
b)
2
|
||||||
c) 1
|
||||||
d) none of the above
|
24)
The main MySQL program that does all the data handling is called?
|
a) mysql.exe
|
b) mysql
|
c) mysqld
|
d) httpd
|
25)
A SELECT command without a WHERE clause returns?
|
a) All the records from a table that
match the previous WHERE clause
|
b)
All the records from a table, or information about all the records
|
c) SELECT is invalid without a WHERE
clause
|
d) Nothing
|
26)
In a SELECT with a GROUP BY clause, a WHERE clause, and a HAVING clause, the
WHERE conditions are applied before the HAVING conditions.
|
a)
True
|
b) Fasle
|
c) Either True or False
|
d) None of the above
|
27) If we want to undo GRANT, we
should use?
a) REVOKE
b) UNDO
c) UNGRANT
d) DELETE
e) ROLLBACK
28)
The result of a SELECT statement can contain duplicate rows.
|
a)
False
|
b) True
|
c)
None of the above
|
SOFTWARE
PROCESS MEASUREMENT
1. The
AIS cycle allows for multiple iterations.
a. True
b. false
2. There
are _____ general architectures for assessment model
a.3 b. 4 c.2
d. 5
3. model building includes only calibration.
a. true b.false
4. software product measurement includes
a. size b. structure c. both a
and b d. only a e. only b
5. measurement is used to identify strength and weakness of processes.
a. false b. true
6. the personal software process is a part of
a. process model b. experimental technique c.
analytical technique d.
benchmarking
7. process measurement technique are classified into 3 types
a. true b.
false
8. minimum requirement in CBA-IPI assessment method does not include
data validation and collection
a. true b. false
9. In staged process assessment model risk analysis forms which stage
a. 5 b. 6 c.3 d. 4
10. the last stage in automation
tools is
a. mockup b. create c. stage and test d.
release
SOFTWARE ENGINEERING PROCESS
1)The
number of stages in software engineering process are
a.1
b.2
c.3
d.4
2.)Process
infrastructure and software process
management cycle come under which of the following stages in software
engineering process?
a.process
definition
b.process
implementation and change
c.process
assessment
d.none
of the above
3.)Process
measurement and software product measurement come under which stage in software
engineering process?
a.process
definition
b.process
assessment
c.process
and product measurement
d.none
of the above
4.) _________ is concerned with modifying
existing software systems to meet new requirements.
(a)
Software specification
(b)
Software design and implementation
(c)
Software validation
(d)
Software evolution
5.)
Which of these terms are level names in the Capability Maturity Model?
A) Performed
B) Repeated
C) Reused
D) Optimized
E) both a and d
6.)
Which of the items listed below is not one of the software engineering layers?
A) Process
B) Manufacturing
C) Methods
D) Tools
7.
Which statement best describe a meaning of "waterfall" life cycle
model.
(a)
When a phase in the lifecycle is completed, the results fall down to the next
phase and there is no going back.(ans)
(b)
When a phase in the lifecycle iterates like a ring on the spiral, moving
outward from the center.
(c)
When a phase in the lifecycle overlapping with each others.
(d)
When a phase in the lifecycle is executed continuously without stop.
8.)DFD
represents?
a.The
flow of data
b.The
processes
c.The
area where they are stored
d.
none of the above
9.The
software life cycle can be said to consist of a series of phases. The classical
model is referred to as the waterfall model. Which phase may be defined as
"The concept is explored and refined, and the client's requirements are
elicited?"
(a) Requirements
(b) Specification
(c) Design
(d) Implementation
(e)
Integration
0 comments :
Post a Comment