Indexing
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 624 |
In a relational schema, each tuple is divided in fields called :
| Relations | |
| Domains | |
| Queries | |
| All the above |
Question 624 Explanation:
A domain describes the set of possible values for a given attribute(column), and can be considered a constraint on the value of the attribute. Mathematically, attaching a domain to an
attribute means that any value for the attribute must be an element of the specified set.
For example in relation given below there are 4 attributes where domain of attributes “Name” and “Course” is character string while domain of “Roll-No” and “Marks” attributes is integer value.
Now the domains of each attribute is dividing a tuple(row) in in fields of sequence Character string, integer value, character string and integer value.
attribute means that any value for the attribute must be an element of the specified set.
For example in relation given below there are 4 attributes where domain of attributes “Name” and “Course” is character string while domain of “Roll-No” and “Marks” attributes is integer value.
Now the domains of each attribute is dividing a tuple(row) in in fields of sequence Character string, integer value, character string and integer value.
Correct Answer: B
Question 624 Explanation:
A domain describes the set of possible values for a given attribute(column), and can be considered a constraint on the value of the attribute. Mathematically, attaching a domain to an
attribute means that any value for the attribute must be an element of the specified set.
For example in relation given below there are 4 attributes where domain of attributes “Name” and “Course” is character string while domain of “Roll-No” and “Marks” attributes is integer value.
Now the domains of each attribute is dividing a tuple(row) in in fields of sequence Character string, integer value, character string and integer value.
attribute means that any value for the attribute must be an element of the specified set.
For example in relation given below there are 4 attributes where domain of attributes “Name” and “Course” is character string while domain of “Roll-No” and “Marks” attributes is integer value.
Now the domains of each attribute is dividing a tuple(row) in in fields of sequence Character string, integer value, character string and integer value.