An association of several structure of a data base can be expressed graphically by?
Tuple
Record
Relationship
Field
Correct Answer :
C. Relationship
Related Questions
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
In an Entity-Relationship Diagram Diamonds represents
Attributes
Multi-valued attributes
Weak entity set
Relationship sets
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
The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is
Normalization
Indexing
Enforcing referential integrity
Enforcing data integrity
Count function in SQL returns the number of
values.
distinct values.
groups.
columns.
RAID
Redundant Arrays of Independent Disks
Redundant Arrays of Independent Drives
Redundant Arrays of Interconnected Drives
Redundant Arrays of Interconnected Disks
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.
The number of cursors depend on the
number of queries
number of attributes
size of memory area
none of these
Encoding method which does not provide for synchronization
B8ZS
Manchester
RZ
NRZ-L
In which of the random-access method, stations do not sense the medium?
ALOHA
ETHERNET
CSMA/CA
CSMA/CD
The physical location of a record is determined by a mathematical formula that transforms
a file key into a record location is :
B-Tree File
Hashed File
Indexed File
Sequential file.
Noisy channel has ……… .. types of protocols
two
three
four
none
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 produces the relation that has attributes of R1 and R2
Cartesian product
Difference
Intersection
Product
A ………… clause permits a view definition to be used in multiple places within a query.
where
exist
with
select
File organization that provides fast access to any arbitrary record
Hashed file
B-tree
Ordered file
Unordered file
Full form of CIDR
Classful Inter Domain Routing
Classless International Domain Routing
Classless Inter Domain Routing
none of these
A transaction is said to have terminated if it has
either committed or aborted
either partially committed or aborted
either committed or failed
none of these
The degree of the table with 500 rows and 7 columns is
500
7
3500
none of these
Range variables are designed using the
TO clause
FROM clause
RANGE clause
none of the above
The union of primary keys of a related entity becomes …………. Of a relation.
primarykey
superkey
candidatekey
foreignkey
What does the number of attributes in a relation is called?
Cardinality
Degree
Tuple
Order
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
A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above
Tertiary storage
magnetic tape
juke box
optical disk
All of the above
The output of the Data Definition Language is stored in the
view table
schema
metadata
all of the above.
The access protocol used by traditional Ethernet
CSMA/CA
CSMA/CD
CSMA
Token ring
Which of the following layer uses trailer of the frame for error detection?
Transport layer
Network layer
Datalink layer
None of these
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