Which of the following is the unit of signaling speed or modulation rate or the rate of symbol transmission?
Data rate
Bit rate
Signal to Noise Ratio
Baud rate
Correct Answer :
D. Baud rate
Related Questions
DBMS helps achieve
Data independence
Centralized control of data
Neither A) nor B)
both A) and B)
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
Primary storage
magnetic disk
magnetic tape
juke box
cache
The language used in application programs to request data from the DBMS is referred to as the
DML
DDL
VDL
SDL
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
A lock that allows concurrent transactions to access different rows of the same table is known as a
Field-level lock
Row-level lock
Table-level lock
Database-level lock
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
Multivalued dependency is removed in
4 NF
3 NF
2 NF
1 NF
Natural mask for a Class A network
255.0.0.0
255.255.0.0
255.255.255.0
none of these
The mode in which data item may be locked
Partner
Mutual
Exclusive
Atomic
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.
A fragmentation is categorized in
1 part
2 part
3 part
4 part
Technique used in log based recovery
Immediate database modification
Graph-based recovery
key dependencies
none of the above
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
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
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.
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.
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
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
The types of noiseless channels are
i) Selective Reject ARQ
ii) simplest protocol
iii) Go-Back-N ARQ
iv) Stop-and-Wait Protocol
i, ii only
ii and iv only
ii and iv only
i, iv only
The access protocol used by traditional Ethernet
CSMA/CA
CSMA/CD
CSMA
Token ring
B-Tree is used for
searching data
storing data
both A and B
none of these
Unwanted energy from source other than the transmitter.
Attenuation
Distortion
Delay
Noise
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
The database environment has all of the following components except:
users.
separate files.
database.
database administrator.
The attribute that can be divided into other attributes is called
Simple Attribute
Composite Attribute
Multi-valued Attribute
Derived Attribute
…………… is responsible for using that the database remains in a consistent state despite system failure.
Storage manager
Admin
Transaction manager
none 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
The overall design of a database is called
Subschema of the database
Schema of the database
Structure of the database
View of the database
Benefit of database normalization is
smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy