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 questionsIn 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.
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.
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.
Keep practicing
Take the free 1D0-541 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1D0-541 practice questions
- Question 3To create a view, what are the minimal privileges that a user must have for the relations…
- Question 5Consider the following relation definitions: STUDENT( Student_Number: integer NOT NULL Na…
- Question 7Which subset of Structured Query Language (SQL) is used to limit access to a database or …
- Question 10Which statement accurately describes a characteristic of attributes?
- Question 12Which of the following occurs in a relation when records are added or removed?
- Question 15A theta-join can be viewed as:
