COMPUTER SCIENCE AND ENGINEERING
SQL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Cardinality of the relation
|
|
Degree of the relation
|
|
Cartesian product
|
|
None of the above
|
Detailed explanation-1: -The number of tuples in a relation is called its cardinality, while the number of attributes in a relation is called its degree.
Detailed explanation-2: -A tuple is a row of a relation. A domain is a set of allowable values for one or more attributes. The degree of a relation is the number of attributes it contains. The cardinality of a relation is the number of tuples it contains.
Detailed explanation-3: -Examination of the relation tells us that there are just four tuples for which the predicate holds true.
Detailed explanation-4: -Answer: Cardinality refers to the number of tuples/rows in a table whereas, Degree refers to the number of attributes/columns in a table.
Detailed explanation-5: -The number of rows in the table. The number of unique values for a set of columns for leading columns in an index key, also known as cardinality.