1D0-541 practice question 11 of 25

In a relational database, which term describes a single table consisting of rows and columns?

Full set: 128 questions
Answer options
A: Entity
B: Matrix
C: Relation Correct answer
D: Data dictionary
Correct Answer:
C. Relation
Explanation

In the formal relational model of database theory, established by E.F. Codd, the term "relation" is the mathematical and theoretical term for a table. A relation is defined as a set of tuples (rows), where each tuple is a collection of attribute (column) values. While "table" is the common term used in practical implementations and by database management systems (DBMS), "relation" is the precise, foundational term describing this two-dimensional structure of rows and columns.

Why Incorrect

A. Entity: An entity is a conceptual, real-world object (e.g., a person, place, or event) about which data is stored, not the table structure itself.
B. Matrix: While a table is visually similar to a mathematical matrix, "matrix" is not the standard or formal term used in relational database theory.
D. Data dictionary: A data dictionary is a repository of metadata; it contains information about the database structures (like tables and columns), not the data tables themselves.

References

1. Codd, E. F. (1970). A Relational Model of Data for Large Shared Data Banks. Communications of the ACM, 13(6), 377–387.

Section 1.3, Paragraph 2: "For database purposes, it is more usual to picture a relation as a table in which each row represents a tuple." This foundational paper explicitly equates the theoretical term "relation" with the practical concept of a "table."

2. Silberschatz, A., Korth, H. F., & Sudarshan, S. (2020). Database System Concepts (7th ed.). McGraw-Hill.

Chapter 2, Section 2.1, Page 25: "A relational database consists of a collection of tables, each of which is assigned a unique name... The term relation is used to refer to a table in the relational model."

3. Elmasri, R., & Navathe, S. B. (2016). Fundamentals of Database Systems (7th ed.). Pearson.

Chapter 3, Section 3.1, Page 60: "A Relation looks like a table of values. A relation typically contains a set of rows. The data elements in each row represent certain facts that correspond to a real-world entity or relationship." This distinguishes between the relation (table) and the entity it represents.

Scroll to Top