Legal Metrology β’ Paper-III
Network in which every computer is capable of playing the role of client, server or both at the same time is called
A)
peer-to-peer network
B)
local area network
C)
dedicated server network
D)
wide area network
Correct option: A β peer-to-peer network. This matches the standard definition/result for the stated question.
Legal Metrology β’ Paper-III
Which is the first step in the software development life cycle ?
A)
Analysis
B)
Design
C)
Problem/Opportunity Identification
D)
Development and Documentation
Correct option: C β Problem/Opportunity Identification. This matches the standard definition/result for the stated question.
Legal Metrology β’ Paper-III
Empdt1(empcode, name, street, city, state,pincode). For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, Empdt1 is a relation in
A)
1 NF only
B)
2 NF and hence also in 1 NF
C)
3NF and hence also in 2NF and 1NF
D)
BCNF and hence also in 3NF, 2NF and 1NF
NOR-latch S=R=1 drives both outputs low and is the invalid state.
Legal Metrology β’ Paper-III
Which is one of the most important stakeholder from the following ?
A)
Entry level personnel
B)
Middle level stakeholder
C)
Managers
D)
Users of the software
Correct option: D β Users of the software. This matches the standard definition/result for the stated question.
Legal Metrology β’ Paper-III
In order to undo the work of transaction after last commit which one should be used?
A)
View
B)
Commit
C)
Rollback
D)
Flashback
Correct option: C β Rollback. This matches the standard definition/result for the stated question.
Legal Metrology β’ Paper-III
An entity set that does not have sufficient attributes to form a primary key is termed a __________
A)
Strong entity set
B)
Variant set
C)
Weak entity set
D)
Variable set
Correct option: C β Weak entity set. This matches the standard definition/result for the stated question.
Legal Metrology β’ Paper-III
Which two models doesnβt allow defining requirements early in the cycle?
A)
Waterfall & RAD
B)
Prototyping & Spiral
C)
Prototyping & RAD
D)
Waterfall & Spiral
Correct option: B β Prototyping & Spiral. This matches the standard definition/result for the stated question.
Legal Metrology β’ Paper-III
Which one of the following extends a private network across public networks?
A)
local area network
B)
virtual private network
C)
enterprise private network
D)
storage area network
A VPN extends a private network securely across a public network.
Legal Metrology β’ Paper-III
Which of the following protocols ensures conflict serializability and safety from deadlocks?
A)
Two-phase locking protocol
B)
Time-stamp ordering protocol
C)
Graph based protocol
D)
None of these
Correct option: A β Two-phase locking protocol. This matches the standard definition/result for the stated question.
Legal Metrology β’ Paper-III
Which granularity level of testing checks the behavior of module cooperation?
A)
Unit Testing
B)
Integration Testing
C)
Acceptance Testing
D)
Regression Testing
Correct option: B β Integration Testing. This matches the standard definition/result for the stated question.
Legal Metrology β’ Paper-III
In the OSI model, as a data packet moves from the lower to the upper layers, headers are ________
A)
Added
B)
Removed
C)
Rearranged
D)
None of these
The commonly taught Internet/TCP-IP stack is represented here with five layers.
Legal Metrology β’ Paper-III
To remove a relation from an SQL database, we use the __________ command.
A)
Delete
B)
Purge
C)
Remove
D)
Drop table
Correct option: D β Drop table. This matches the standard definition/result for the stated question.
Legal Metrology β’ Paper-III
To include integrity constraint in a existing relation use :
A)
Create table
B)
Modify table
C)
Alter table
D)
Drop table
Correct option: C β Alter table. This matches the standard definition/result for the stated question.
Legal Metrology β’ Paper-III
Updates that violate __________ are disallowed.
A)
Integrity constraints
B)
Transaction control
C)
Authorization
D)
DDL constraints
Correct option: A β Integrity constraints. This matches the standard definition/result for the stated question.
Legal Metrology β’ Paper-III
The basic data type char(n) is a __________ length character string and varchar(n) is __________ length character.
A)
Fixed, equal
B)
Equal, variable
C)
Fixed, variable
D)
Variable, equal
Correct option: C β Fixed, variable. This matches the standard definition/result for the stated question.
Legal Metrology β’ Paper-III
In which test design each input is tested at both ends of its valid range and just outside its valid range?
A)
Boundary value testing
B)
Equivalence class partitioning
C)
Boundary value testing AND Equivalence class partitioning
D)
Decision tables
A high resistance is connected in series to limit the current through the voltmeter movement.
Legal Metrology β’ Paper-III
physical layer provides
A)
mechanical specifications of electrical connectors and cables
B)
electrical specification of transmission line signal level
C)
specification for IR over optical fiber
D)
all of these
Correct option: D β all of these. This matches the standard definition/result for the stated question.
Legal Metrology β’ Paper-III
The work associated with software engineering 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. i. support, ii. development, iii. definition
A)
i, ii, iii
B)
ii, i, iii
C)
iii, ii, i
D)
iii, i, ii
Correct option: A β i, ii, iii. This matches the standard definition/result for the stated question.
Legal Metrology β’ Paper-III
A __________ error means that two or more bits in the data unit have changed.
A)
burst
B)
double-bit
C)
single-bit
D)
none of these
Correct option: A β burst. This matches the standard definition/result for the stated question.
Legal Metrology β’ Paper-III
A domain is atomic if elements of the domain are considered to be __________ units.
A)
Different
B)
Indivisible
C)
Constant
D)
Divisible
An atomic domain treats each field value as an indivisible unit.
Legal Metrology β’ Paper-III
Which one of the following is a procedural language ?
A)
Domain relational calculus
B)
Tuple relational calculus
C)
Relational algebra
D)
Query language
Relational algebra is a procedural query language.
Legal Metrology β’ Paper-III
In SQL the spaces at the end of the string are removed by __________ function .
A)
Upper
B)
String
C)
Trim
D)
Lower
Correct option: C β Trim. This matches the standard definition/result for the stated question.
Legal Metrology β’ Paper-III
ASK, PSK, FSK, and QAM are examples of __________ encoding.
A)
analog-to-digital
B)
analog-to-analog
C)
digital-to-analog
D)
digital-to-digital
ASK/PSK/FSK/QAM are digital-to-analog modulation methods because digital data alters an analog carrier.
Legal Metrology β’ Paper-III
In size oriented metrics, metrics are developed based on the __________
A)
number of Functions
B)
number of user inputs
C)
number of lines of code
D)
amount of memory usage
Correct option: C β number of lines of code. This matches the standard definition/result for the stated question.
Legal Metrology β’ Paper-III
Which one of the following models is not suitable for accommodating any change?
A)
Build & Fix Model
B)
Prototyping Model
C)
Evolutionary Model
D)
Waterfall Model
Correct option: D β Waterfall Model. This matches the standard definition/result for the stated question.