What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
Correct Answer :
C. 100 Mbps
Related Questions
In two-phase locking protocol the two phases are
growing phase and shrinking phase
execution phase and blocking phase.
running phase and sleeping phase.
none of the above
Select the incorrect statement
View is derived from other tables.
Once a transaction has executed commit work its effect cant be undone by rollback work .
The input to the aggregate function avg can be non numeric data types
A primary key can never be null.
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
The degree of the table with 500 rows and 7 columns is
500
7
3500
none of these
Transaction processing is associated with everything below except
producing detail, summary, or exception reports.
recording a business activity.
confirming an action or triggering a response.
maintaining data.
The statement
Every foreign-key value must match a primary-key value in an associated table
Is related to
View
Cursor defination
Referential intergrity
Trigger
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
Which of the following produces the relation that has attributes of R1 and R2
Cartesian product
Difference
Intersection
Product
Technique(s) used for data recovery after any failure
Logging
Recovery manager
Both A and B are true
Both A and B are false
Which of the following is logical topology?
Bus
Ring
Star
None of these
The raw facts and figures are:
Data
Data field
DBMS
DBASE
Radio frequencies below ............. are more suitable for omnidirectional applications.
300MHz
1GHz
5GHz
10 GHz
Select the incorrect statement
BCNF is stronger than 3NF
Relational algebra is a non-procedural language
Every conflict serializable schedule is view serializable.
none of the above
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
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
Which command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE
Data independence means
data is defined separately and not included in programs.
programs are not dependent on the physical attributes of data.
programs are not dependent on the logical attributes of data.
both B) and C).
File organization that provides fast access to any arbitrary record
Hashed file
B-tree
Ordered file
Unordered file
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
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
In defining the notion of the tuple variable, which one of the clause is useful?
as
by
from
none of the above
.................. 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
Noisy channel has ……… .. types of protocols
two
three
four
none
The language used in application programs to request data from the DBMS is referred to as the
DML
DDL
VDL
SDL
Three SQL, DDL, CREATE commands are
Schema, Base and Table
Schema, Table and View
Base, Table and Schema
Key, Base and Table
In an Entity-Relationship Diagram Ellipses represents
Attributes
Weak entity set
Relationship sets
Multi-valued attributes
Every Boyce-Codd normal form is in
3NF
2NF
1NF
none of the above
Benefit of database normalization is
smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy
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.
Which of the following works as a filter?
UPDATE
DROP
ALTER
SELECT