Database Management System
Questions 21 to 30
21.
|
A named
set of SQL statements that are considered when a data modification occurs are
called
|
||||||||||
22.
|
Which
protocol ensures conflict serializability?
|
||||||||||
23.
|
Which
type of file is easiest to update?
|
||||||||||
24.
|
When a regular entity type contains
a multivalued attribute, one must
|
||||||||||
25.
|
Given following figure is an example
of mapping which type of relationship?
|
||||||||||
26.
|
A
candidate key must satisfy all of the following conditions EXCEPT
|
||||||||||
27.
|
A relation
that contains no multivalued attributes and has nonkey attributes solely
dependent on the primary key, but contains transitive dependencies is in
which normal form?
|
||||||||||
28.
|
A functional
dependency between two or more nonkey attributes is called a
|
||||||||||
29.
|
Which of the
following technique is an alternative to log based recovery?
|
||||||||||
30.
|
DBMS periodically suspends all
processing and synchronizes its files and journals through the use of
|
Answers
21.
|
Answer : (b)
Reason: A named set of SQL statements that are
considered when a data modification occurs are called triggers
|
22.
|
Answer : (c)
Reason: Timestamp
based protocol ensures
conflict serializability.
|
23.
|
Answer : (b)
Reason: Hashed file is easiest to update.
|
24.
|
Answer : (b)
Reason: When a regular entity type contains a
multivalued attribute, one must Create two new relations, one containing the
multivalued attribute.
|
25.
|
Answer : (d)
Reason: The given mapping is an example of ternary
relationship of Patient Treatment with three entities, viz., Patient,
Physician and Treatment.
|
26.
|
Answer : (b)
Reason: A candidate key (i) must uniquely identify the row
(ii) must indicate the row’s position in the
table
(iii) must be non-redundant and
(iv)
(iv) One of the primary key.
A
candidate key does not indicate the row’s positon in the table. Hence option
(b) is the answer.
|
27.
|
Answer : (b)
Reason: A relation that contains no multivalued
attributes and has non-key attributes solely dependent on the primary key,
but contains transitive dependencies is in second normal form.
|
28.
|
Answer : (c)
Reason: A functional dependency between two or more
non-key attributes is called a transitive dependency.
|
29.
|
Answer : (e)
Reason: Shadow paging technique is an alternative to
log based recovery.
|
30.
|
Answer : (a)
Reason: DBMS periodically suspends all processing and
synchronizes its files and journals through the use of Checkpoint facility.
|
<< Prev 1... 2... 3... 4... 5... 6... 7... 8... 9... 10... 11... 12... 13... 14... 15... 16... 17... 18... 19... 20... 21... 22... 23... 24... 25... 26... 27... 28... 29... 30... 31... 32... 33... 34... 35... 36... Next >>
Image is not loading for q.n0 25
ReplyDelete