📚 Question Bank
Q83 — DBMS
⚙
Tags
👁
Hide
☾
Dark
Home
›
UGC NET Paper 2: Computer Sc 6th Jan 2025 Shift 1
› DBMS
DBMS
Q83.
Marks: +2.0
UGC NET Paper 2: Computer Sc 6th Jan 2025 Shift 1
The degree of a relation in database is
1.
the number of tuples in the relation
2.
the number of attribute in the relation
✓ Correct
3.
the number of values in domian
4.
the number of keys in a relation
Show Solution
Solution
The correct answer is
the number of attributes in the relation
.
Key Points
The degree of a relation (or table) in a database refers to the number of attributes (or columns) that the relation contains.
Each attribute represents a property or characteristic of the entity that the relation describes.
For example, in a student relation, attributes could include student ID, name, age, and major.
The degree of the student relation would be 4 if there are four attributes.
This term is different from the cardinality of a relation, which refers to the number of tuples (or rows) in the relation.
Additional Information
Understanding the degree of a relation is essential in database design, as it impacts how data is structured and accessed.
Database schemas define the structure of relations, including their degree and the data types of their attributes.
Normalization techniques in database design aim to optimize the degree and minimize redundancy.
Relational database management systems (RDBMS) use the schema to enforce data integrity and support query optimization.
📄 All “DBMS” questions across papers
← Previous
9 / 9 in this subject •
Back to paper
Next →
🏷 Change Tag for this Question
▶
Loading…
Update Tag