GATE 2023 CS – Question 16
Databases · Relational Model: Relational Algebra, Tuple Calculus, SQL · 1 mark · Multiple choice
Which one of the options given below refers to the degree (or arity) of a relation in relational database systems?
- Number of attributes of its relation schema.
- Number of tuples stored in the relation.
- Number of entries in the relation.
- Number of distinct domains of its relation schema.
Practise this question in The GATE Grind →
Show answer and explanation
Correct answer: (A) Number of attributes of its relation schema.
Explanation
The degree (arity) of a relation is the number of attributes in its schema. The number of tuples is its cardinality.
More Relational Model: Relational Algebra, Tuple Calculus, SQL questions
- GATE 2023 CS Q61 – Consider the following table named Student in a relational database. The primary key of…
- GATE 2022 CS Q25 – Consider the following three relations in a relational database. Employee(eId, Name),…
- GATE 2022 CS Q56 – Consider the relational database with the following four schemas and their respective…
- GATE 2021 CS (CS1) Q33 – A relation r(A, B) in a relational database has 1200 tuples. The attribute A has integer…
- GATE 2021 CS (CS1) Q37 – The following relation records the age of 500 employees of a company, where empNo…
- GATE 2020 CS Q23 – Consider a relational database containing the following schemas. Catalogue(sno, pno,…
All Relational Model: Relational Algebra, Tuple Calculus, SQL questions →