- N O Nyplms Polite Edu Sg Nr Review Quiz Data Organization And Database System Database Advantages Disadvantages Iep 1 (96.62 KiB) Viewed 26 times
Deletion of records in a relation is not allowed when full data
is not available.
b)
Deletion of records in a relation caused unrelated data to be
deleted.
c)
Deletion of records in a relation is not allowed when relation
is not normalized.
d)
Deletion of records only allowed after insertion of new
records.
Question 2: What best describes the "insertion anomaly" of
a relation that is not normalized?
a)
Insertion of new records cannot be done until deletion anomaly
is removed.
b)
Insertion of new records cannot be done if the insertion flag is
false.
c)
New records cannot be created until related records are first
created.
d)
Existing records need to be deleted before new records can be
inserted.
N O nyplms.polite.edu.sg Nr Review Quiz: Data Organization and Database system Database - Advantages & Disadvantages Iepgp.inflibnet.ac.in/epgpdata/uploads/epgp_content... G Which of the following best describes "foreign key" i... + < Back to Content Review Quiz: Data Organization and Database system > Est. Length: 0:20:00 Time Taken:0:02:17 DERRICK POH JUN WEI STU-SEG: Attempt 5 Page 1: What is "deletion anomaly" in a relation that is not normalized? 1 2 3 a) Deletion of records in a relation is not allowed when full data is not available. 4 5 6 b) Deletion of records in a relation caused unrelated data to be deleted. 7 8 9 c) Deletion of records in a relation is not allowed when relation is not normalized. . ✓ 10 11 12 d) Deletion of records only allowed after insertion of new records. Question 7 (1 point) What best describes the "insertion anomaly" of a relation that is not normalized? a) Insertion of new records cannot be done until deletion anomaly is removed. b) Insertion of new records cannot be done if the insertion flag is false.