Beginner
Database Management Systems
Q32 / 100
What is the difference between a relation and a table?
Correct! Well done.
Incorrect.
The correct answer is B) A relation is the mathematical set-based concept (no duplicates, no order); a table is a SQL implementation (allows duplicates, ordered storage)
B
Correct Answer
A relation is the mathematical set-based concept (no duplicates, no order); a table is a SQL implementation (allows duplicates, ordered storage)
Explanation
In relational theory, a relation is a set of tuples (no duplicates, no order). SQL tables may have duplicate rows (multisets) and ordered result sets, relaxing strict mathematical relations.
Progress
32/100