1D0-541 practice question 10 of 25
Which statement accurately describes a characteristic of attributes?
Full set: 128 questionsIn 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.
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.
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).
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 11In a relational database, which term describes a single table consisting of rows and colu…
- Question 12Which of the following occurs in a relation when records are added or removed?
- Question 15A theta-join can be viewed as:
