For large networks, _______ topology is used
Ring
Bus
Mesh
none of these
Correct Answer :
A. Ring
Related Questions
A fragmentation is categorized in
1 part
2 part
3 part
4 part
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
Which of the following submit and execute query at run time?
Static SQL
Dynamic SQL
both
none of these
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
Generalization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
............... noise is caused by the random motion of the electrons in a wire and is avoidable.
Thermal
Intermodulation
Cross talk
Impulse
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)
Cross Product is a:
Unary Operator
Binary Operator
Ternary Operator
none of the above
Tape storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
Noiseless channel has ……… types of protocols.
2
3
4
5
The overall design of a database is called
Subschema of the database
Schema of the database
Structure of the database
View of the database
Secondary storage
magnetic disk
magnetic tape
juke box
cache
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).
Primary storage
magnetic disk
magnetic tape
juke box
cache
Which of the following statements is not true about two tier client server database architecture?
SQL statements are processed on tier server
SQL statements may be processed on some of the clients
Business logic is mostly processed on clients
Business logic may be processed on the server
In an Entity-Relationship Diagram Diamonds represents
Attributes
Multi-valued attributes
Weak entity set
Relationship sets
A logical description of some portion of database that is required by a user to perform task is called as
System View
User View
Logical View
Data View
Tertiary storage
magnetic tape
juke box
optical disk
All of the above
Which topology requires a central controller or hub?
Ring
Tree
Switch
Graph
In RDBMS, Data is presented as a collection of
Relation
Table
Attribute
Entity
What does a field or a combination of fields that has a unique value called ?
Foreign key
Secondary key
Primary key
Alternate key
.................. means sending a digital signal over a channel without changing the digital signal to an analog signal.
Baseband transmission
Broadband transmission
Digital transmission
Analog transmission
A composite attribute is converted to individual attributes in which of the following normal form ?
first
Second
third
fourth
The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
It is possible to define a schema completely using
VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.
Which of the following is a classical approach to database design?
Left Right approach
Right Left approach
Top Down approach
Bottom Up approach
Benefit of database normalization is
smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy
B-Tree is used for
searching data
storing data
both A and B
none of these
Which of the following is logical topology?
Bus
Ring
Star
None of these
Only one communication channel is needed rather than n channels to transmit data between two communicating devices
parallel
serial
analog
digital