In relational database, the data type of values in each column of a table is…
2023
In relational database, the data type of values in each column of a table is called ______.
- A.
attribute
- B.
domain
- C.
relation
- D.
More than one of the above
- E.
None of the above
Attempted by 2017 students.
Show answer & explanation
Correct answer: B
In a relational database, each column in a table has a specific data type that defines the kind of values it can store. This data type is known as the 'domain'. The domain specifies the set of valid values for a column, such as integers, strings, or dates. For example, a column for age might have a domain of integer values between 0 and 120. The term 'attribute' refers to a column itself, not its data type. Similarly, 'relation' refers to the entire table. Therefore, the correct term for the data type of values in a column is 'domain'.