If there are n tuples in the partition and the rank of the tuple is r, then its                  is defined as (r −1)/(n−1).

Related MCQs

• Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
• Suppose now that R(A,B:) and S(A,B:) are two relations with r and s tuples, respectively (again, not necessarily distinct). If m is the number of (not necessarily distinct) tuples in the result of the SQL query: R intersect S; Then which of the following is the most restrictive, correct condition on the value of m?
• A                    integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
• A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
• A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
• In rank() function if one value is shared by two tuples then
• A            is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
• The           operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
• A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
• A _____ is a property of the entire relation, rather than of the individual tuples in Which each tuple is unique.