Relational Database Management System (RDBMS) Question:
Spurious tuples may occur due to?
Answer:
i. Bad normalization
ii. Theta joins
iii. Updating tables from join
a) i & ii b) ii & iii
c) i & iii d) ii & iii
(a) i & iii because theta joins are joins made on keys that are not primary keys.
ii. Theta joins
iii. Updating tables from join
a) i & ii b) ii & iii
c) i & iii d) ii & iii
(a) i & iii because theta joins are joins made on keys that are not primary keys.
| Previous Question | Next Question |
| A B C is a set of attributes. The functional dependency is as follows AB -> B AC -> C C -> B? | Tables derived from the ERD? |