Legal Metrology • Paper-III
Insert into instructor values (10211, ’Smith’, ’Biology’, 66000); What type of statement is this ?
A)
DLL
B)
DML
C)
Relational
D)
DDL
Correct option: B — DML. This matches the standard definition/result for the stated question.
Legal Metrology • Paper-III
In relational algebra, for select operation the __________ appear in the subscript and the __________ argument appears in the parenthesis after the sigma.
A)
Predicates, relation
B)
Relation, Predicates
C)
Operation, Predicates
D)
Relation, Operation
Relational algebra is a procedural query language.
Legal Metrology • Paper-III
Which layers of the OSI model are host-to-host layers?
A)
Transport, Session, Presentation, Application
B)
Network, Transport, Session, Presentation
C)
Datalink, Network, Transport, Session
D)
Physical, Datalink, Network, Transport
The transport, session, presentation and application layers are host-to-host in the OSI layering used in this classification.
Legal Metrology • Paper-III
Wireless transmission can be done via
A)
radio waves
B)
microwaves
C)
infrared
D)
all of these
Correct option: D — all of these. This matches the standard definition/result for the stated question.
Legal Metrology • Paper-III
Coupling is a qualitative indication of the degree to which a module
A)
can be written more compactly
B)
focuses on just one thing
C)
is able to complete its function in a timely manner
D)
is connected to other modules and the outside world
Correct option: D — is connected to other modules and the outside world. This matches the standard definition/result for the stated question.
Legal Metrology • Paper-III
Connection establishment in TCP is done by which mechanism?
A)
Flow control
B)
Three-Way Handshaking
C)
Forwarding
D)
Synchronization
Correct option: B — Three-Way Handshaking. This matches the standard definition/result for the stated question.
Legal Metrology • Paper-III
Which of the following life cycle model can be chosen if the development team has less experience on similar projects?
A)
Spiral
B)
Waterfall
C)
RAD
D)
Iterative Enhancement Model
Correct option: B — Waterfall. This matches the standard definition/result for the stated question.
Legal Metrology • Paper-III
What type of join is needed when you wish to include rows that do not have matching values?
A)
Equi-join
B)
Natural join
C)
Outer join
D)
All of these
Correct option: C — Outer join. This matches the standard definition/result for the stated question.
Legal Metrology • Paper-III
__________ clause is an additional filter that is applied to the result.
A)
Select
B)
Group-by
C)
Having
D)
Order by
Correct option: C — Having. This matches the standard definition/result for the stated question.
Legal Metrology • Paper-III
Which address identifies a process on a host?
A)
physical address
B)
logical address
C)
port address
D)
specific address
Correct option: C — port address. This matches the standard definition/result for the stated question.
Legal Metrology • Paper-III
In the __________ normal form, a composite attribute is converted to individual attributes.
A)
First
B)
Second
C)
Third
D)
Fourth
1NF requires atomic attributes rather than composite/multivalued fields.
Legal Metrology • Paper-III
A __________ is a device that forwards packets between networks by processing the routing information included in the packet.
A)
bridge
B)
firewall
C)
router
D)
all of these
A router forwards packets between networks using routing information.
Legal Metrology • Paper-III
Choose an internal software quality from given below:
A)
scalability
B)
usability
C)
reusability
D)
reliability
Correct option: A — scalability. This matches the standard definition/result for the stated question.
Legal Metrology • Paper-III
Which sublayer of the data link layer performs data link functions that depend upon the type of medium?
A)
logical link control sublayer
B)
media access control sublayer
C)
network interface control sublayer
D)
none of these
Correct option: B — media access control sublayer. This matches the standard definition/result for the stated question.
Legal Metrology • Paper-III
Identify the statement which cannot be associated with OSI model
A)
A structured way to discuss and easier update syatem components
B)
One layer may duplicate lower layer functionality
C)
Functionality at one layer no way requires information from another layer
D)
None of these
Correct option: C — Functionality at one layer no way requires information from another layer. This matches the standard definition/result for the stated question.
Legal Metrology • Paper-III
Which multiplexing technique transmits digital signals?
A)
FDM
B)
TDM
C)
WDM
D)
None of these
TDM is naturally used to multiplex digital streams into time slots.
Legal Metrology • Paper-III
Purpose of process is to deliver software
A)
in time
B)
with acceptable quality
C)
that is cost efficient
D)
both ‘in time’ & ‘with acceptable quality’
Correct option: D — both ‘in time’ & ‘with acceptable quality’. This matches the standard definition/result for the stated question.
Legal Metrology • Paper-III
The level of data abstraction which describes how the data is actually stored is:
A)
Physical level
B)
Conceptual level
C)
External level
D)
View level
Correct option: A — Physical level. This matches the standard definition/result for the stated question.
Legal Metrology • Paper-III
’_ _ _ ’ matches any string of __________ three characters. ’_ _ _ %’ matches any string of at __________ three characters.
A)
Atleast, Exactly
B)
Exactly, Atleast
C)
Atleast, All
D)
All , Exactly
Correct option: B — Exactly, Atleast. This matches the standard definition/result for the stated question.
Legal Metrology • Paper-III
Database __________, which is the logical design of the database, and the database __________, which is a snapshot of the data in the database at a given instant in time.
A)
Instance, Schema
B)
Relation, Schema
C)
Relation, Domain
D)
Schema, Instance
Schema is the database's logical structure; an instance is the data snapshot at a particular time.
Legal Metrology • Paper-III
Which may be estimated either in terms of KLOC (Kilo Line of Code) or by calculating number of function points in the software?
A)
Time estimation
B)
Effort estimation
C)
Cost estimation
D)
Software size estimation
Correct option: D — Software size estimation. This matches the standard definition/result for the stated question.
Legal Metrology • Paper-III
Identify which of the following operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
A)
Join
B)
Cartesian product
C)
Intersection
D)
Set difference
Correct option: B — Cartesian product. This matches the standard definition/result for the stated question.
Legal Metrology • Paper-III
The __________ is the physical path over which a message travels
A)
Path
B)
Medium
C)
Protocol
D)
Route
The information to be communicated is called the message.
Legal Metrology • Paper-III
Bluetooth is an example of
A)
personal area network
B)
local area network
C)
virtual private network
D)
none of these
Correct option: A — personal area network. This matches the standard definition/result for the stated question.
Legal Metrology • Paper-III
If P is risk probability, L is loss, then Risk Exposure (RE) is computed as__________ .
A)
RE = P/L
B)
RE = P + L
C)
RE = P*L
D)
RE = 2* P *L
Correct option: C — RE = P*L. This matches the standard definition/result for the stated question.
