State which of the following statements are True
i) TCP is connection oriented but unreliable
ii) UDP is connection oriented but unreliable
iii) TCP is connectionless but reliable
iv) UDP is connectionless but reliable
i and ii only
ii and iii only
i and iii only
None of these
Correct Answer :
D. None of these
Related Questions
Volatile storage
loses its contents when power is switched off.
doesnt loses its contents when power is switched off.
creates backup when power is switched off.
none
Full form of CIDR
Classful Inter Domain Routing
Classless International Domain Routing
Classless Inter Domain Routing
none of these
A DBMS query language is designed to
support end users who use English-like commands.
support in the development of complex applications software.
specify the structure of a database.
all of the above.
Which of the following will NOT eliminates the ambiguities of a null value?
Define the attribute as required
Define subtypes
Define each attribute as having an initial value that is recognized as blank
Define supertypes
DECLARE is a(an)
executable statement.
declarative statement.
Ordered file
none of the above
Technique used in log based recovery
Immediate database modification
Graph-based recovery
key dependencies
none of the above
A relation that has no partial dependencies is in which normal form
First
Second
Third
BCNF
An advantage of the database management approach is
data is dependent on programs.
data redundancy increases.
data is integrated and can be accessed by multiple programs.
none of the above.
In E-R diagram Generalization is represented by
Circle
Rectangle
Hyperbola
Triangle
Triggers are also called
active rules
passive rules
inferences
none of the above
In mesh topology, if the number of devices is n , then the number of ports present in each device is
n
n+1
n-1
n/2
Primary storage
magnetic disk
magnetic tape
juke box
cache
Which command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE
Benefit of database normalization is
smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy
Generalization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
Only one communication channel is needed rather than n channels to transmit data between two communicating devices
parallel
serial
analog
digital
In the architecture of a database system external level is the
physical level.
logical level.
conceptual level
view level.
In this data model each record can hae more than one parent
Hierarchical model
E-R model
Network based model
none of these
Select the incorrect statement(s)
i) Shared locks are compatible with each other.
ii) A relation which is in 3NF may have redundancy due to composite keys.
iii) A table in a database can have multiple indexes.
i only
ii, only
ii, iii only
none of the above
The index table has …… Columns.
1
2
3
4
.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.
Noise
Delay distortion
Attenuation distortion
Dispersion
Cross Product is a:
Unary Operator
Binary Operator
Ternary Operator
none of the above
Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.
Gray
White
Blue
Black
B-Tree is used for
searching data
storing data
both A and B
none of these
A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above
The ________ states that a foreign key must either match a primary key value in another relation or it must be null.
entity integrity rule
referential integrity constraint
composite attribute
action assertion
A transaction has following states
i) Active
ii) Fail
iii) Abort
iv) Commit
i and ii only
ii and iii only
i and iii only
iii and iv only
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
Repeaters operate in
i) Physical layer
ii) Datalink layer
iii) Transport layer
iv) Network layer
i and ii only
ii and iii only
ii only
i only
Range variables are designed using the
TO clause
FROM clause
RANGE clause
none of the above