1D0-541 practice question 10 of 25

Which statement accurately describes a characteristic of attributes?

Full set: 128 questions
Answer options
A: The ordering of attributes in a table is significant.
B: An attribute contains values from multiple domains.
C: An attribute name can be used only once per table. Correct answer
D: An attribute name can be used only once in a relational database system with multiple tables.
Correct Answer:
C. An attribute name can be used only once per table.
Explanation

In the relational model, a table is formally known as a relation, and its columns are called attributes. A relation's schema is defined as a set of attributes. A fundamental property of a mathematical set is that all its elements must be unique. Therefore, within a single table, every attribute must have a distinct name to uniquely identify it. This uniqueness is essential for unambiguously referencing columns in data retrieval (e.g., SELECT) and manipulation (e.g., UPDATE) statements. While the same attribute name can be used in different tables, it must be unique within the scope of one specific table.

Why Incorrect

A. The ordering of attributes in a table is significant. The relational model treats attributes as an unordered set; their logical sequence has no bearing on query results or the database's structure.
B. An attribute contains values from multiple domains. An attribute is constrained to a single domain, which defines the set of permissible data types and values for that column, ensuring data integrity.
D. An attribute name can be used only once in a relational database system with multiple tables. Attribute names must only be unique within a single table. The same name (e.g., ID, Name) can be reused in different tables throughout the database.

References

1. Elmasri, R., & Navathe, S. B. (2017). Fundamentals of Database Systems (7th ed.). Pearson. In Chapter 3, Section 3.2.2, "Characteristics of Relations," the definition of a relation schema as a set of attributes, R = {A1, A2, ..., An}, implicitly requires that all attribute names (A1, A2, etc.) within that set be distinct. This section also clarifies that the attributes in a relation are not considered to be ordered.

2. Silberschatz, A., Korth, H. F., & Sudarshan, S. (2020). Database System Concepts (7th ed.). McGraw-Hill. In Chapter 2, Section 2.1, "Structure of Relational Databases," a relation schema is defined by a name and a list of attributes. The formal model treats this as a set of attributes, where set theory dictates that elements must be unique.

3. Ramakrishnan, R., & Gehrke, J. (2003). Database Management Systems (3rd ed.). McGraw-Hill. In Chapter 3, Section 3.1.1, "Creating and Modifying Relations," it is explained that a schema for a relation specifies its name and the names and domains of its attributes (fields). The examples and definitions throughout the chapter consistently show unique attribute names per relation. For instance, Students(sid: string, name: string, login: string, age: integer, gpa: real).

Scroll to Top