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
Correct Answer :
D. iii and iv only
Related Questions
As a side-effect of database update ,the system automatically executes a statement called
a view
a grant permission
a trigger
all of the above
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 proper state of transaction ?
Partially aborted
Partially committed
Aborted
Committed
Unwanted energy from source other than the transmitter.
Attenuation
Distortion
Delay
Noise
A functional dependency between two or more non-key attributes is called
Transitive dependency
Partial transitive dependency
Functional dependency
Partial functional dependency
Select the correct
i) A timestamp-based scheduler cant produce live lock
ii) Aggregate functions cant appear with HAVING clause.
iii) Isolation is a property of database transaction.
i and ii only
ii and iii only
i and iii only
i only
Noisy channel has ……… .. types of protocols
two
three
four
none
The transaction consists of all statements executed between
the begin transaction and end transaction
the start transaction and end transaction
the begin transaction and finish transaction
none of the above.
Authorization command in SQL
Allow
Access
Grant
none of the above
The raw facts and figures are:
Data
Data field
DBMS
DBASE
A transaction which completes successfully is called
Granted
Committed
Compensated
Accomplished
In defining the notion of the tuple variable, which one of the clause is useful?
as
by
from
none of the above
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
The access protocol used by traditional Ethernet
CSMA/CA
CSMA/CD
CSMA
Token ring
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
In which of the following SET concept is used ?
Network Model
Hierarchical Model
Relational Model
None of these
Only one communication channel is needed rather than n channels to transmit data between two communicating devices
parallel
serial
analog
digital
The command used to delete a particular column in a relation
UPDATE
DROP
ALTER
DELETE
Secondary storage
magnetic disk
magnetic tape
juke box
cache
Which of the following concurrency control schemes is not based on serializability property?
Two-phase locking
Timestamped based locking
Graph-based locking
none of the above
Which one of the following statements is false?
The data dictionary is normally maintained by the database administrator.
Data elements in the database can be modified by changing the data dictionary.
The data dictionary contains the name and description of each data element.
The data dictionary is a tool used exclusively by the database administrator.
.................. is the loss of energy as the signal propagates outward, where the amount of energy depends on the frequency.
Noise
Delay distortion
Attenuation distortion
Dispersion
Which of the following produces the relation that has attributes of R1 and R2
Cartesian product
Difference
Intersection
Product
Which one of the following is provided by a data dictionary ?
User data
Database structure data
Sorted data
Functional data
A fragmentation is categorized in
1 part
2 part
3 part
4 part
In E-R Diagram weak entity set are represented by
Ellipse
Dashed ellipse
Dashed Rectangle
Doubled Rectangle
The control of concurrent execution is left with the
operating system
controller unit of the kernel
concurrency control component of the database system
none
Tape storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
Full form of CIDR
Classful Inter Domain Routing
Classless International Domain Routing
Classless Inter Domain Routing
none of these
An entity set which have sufficient attributes to form a primary key
Tree structure
Subtree structure
Strong entity set
Table structure