Database problems in relations that occur due to redundancy is called……
a) anomaly
b) integrity
c) entity
d) none of these
How many types of anomalies in database?
a) one
b) two
c) three
d) four
Explanation: insertion anomaly, deletion anomaly, modification anomaly
Which of the following are anomalies that can be caused by redundancy in tables?
a) insertion
b) deletion
c) modification
d) all of these
A functional dependency between two or more non-key attributes is called……
a) partial functional dependency
b) partial non-key dependency
c) transitive dependency
d) one of these
Which of the following anomalies result from a transitive dependency?
a) insertion
b) modification
c) deletion
d) all of these
A relation is in third normal form if it is in second normal form and……
a) dependent on part of key
b) dependent on all keys
c) independent of key
d) has no transitive dependency
