Which of the following layer uses trailer of the frame for error detection?
Transport layer
Network layer
Datalink layer
None of these
Correct Answer :
C. Datalink layer
Related Questions
FDDI protocol operates in
i) Transport layer
ii) Network layer
iii) Datalink layer
iv) Physical layer
i and ii only
ii and iii only
i and iii only
iii and iv only
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
It is possible to define a schema completely using
VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.
QBE
Query By Execution
Query By Example
Query By Extraction
None of the above.
Technique(s) used for data recovery after any failure
Logging
Recovery manager
Both A and B are true
Both A and B are false
In the architecture of a database system external level is the
physical level.
logical level.
conceptual level
view level.
In case of entity integrity, the primary key may be
not Null
Null
both Null & not Null.
any value.
The raw facts and figures are:
Data
Data field
DBMS
DBASE
In this data model each record can hae more than one parent
Hierarchical model
E-R model
Network based model
none of these
Which of the following is not an Aggregate function?
Min
Max
Select
Avg
When all attributes in a relation tuple are not functionally dependent only on the key attribute. Which of the following normalization is needed?
first
second
third
fourth
............... noise is caused by the random motion of the electrons in a wire and is avoidable.
Thermal
Intermodulation
Cross talk
Impulse
By default a user who has been granted some form of authorization
is allowed to pass them to others
is not allowed to pass them to others
may be or may not be allowed to pass them to others
none
The number of cursors depend on the
number of queries
number of attributes
size of memory area
none of these
Event condition action model is related to
Views
Cursors
Triggers
None of these.
The mode in which data item may be locked
Partner
Mutual
Exclusive
Atomic
Functional dependencies are generalization of
Relation dependencies
Data dependencies
key dependencies
none of the above
A ………… clause permits a view definition to be used in multiple places within a query.
where
exist
with
select
The access protocol used by traditional Ethernet
CSMA/CA
CSMA/CD
CSMA
Token ring
An operation that will increase the length of a list is
insert
modify
lookup
none of the above
A data manipulation command the combines the records from one or more tables is called
SELECT
PROJECT
JOIN
PRODUCT
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
A data dictionary contains:
i) The name of all fields in all files.
ii) The data type of all fields in all files.
iii) The width of all fields in all files.
only i)
only i) and ii)
only ii) and iii)
i) ii) iii)
A relation is said to be in ………. If it doesnt contain partial dependency
1NF
2NF
3NF
BCNF
Triggers are also called
active rules
passive rules
inferences
none of the above
Authorization command in SQL
Allow
Access
Grant
none of the above
Which of the following submit and execute query at run time?
Static SQL
Dynamic SQL
both
none of these
The race condition occurs when
Two concurrent processes attempt to interact with each other.
Two concurrent processes interact with different data files.
Two concurrent processes attempt to hold a data item .
none of the above.
A fragmentation is categorized in
1 part
2 part
3 part
4 part
The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these