Computer Sciences > GATE 2021 SET-1 > Relational Algebra
A relation r(A, B) in a relational database has 1200 tuples. The attribute A has integer values ranging from 6 to 20, and the attribute B has integer values ranging from 1 to 20. Assume that the attributes A and B are independently distributed. The estimated number of tuples in the output of σ(A>10)∨(B=18)(r) is _______.
Correct : 819
Similar Questions
Consider a database that has the relation schemas EMP (EmpId, EmpName, DepId), and DEPT(DeptName, DeptId). Note that the DepId can be permitted to be NULL in th...
Consider the following two relations, R(A,B) and S(A,C);
The total number of tuples obtained by evaluating the following expression σB<C(R ⨝R.A=S.AS) is...
The relation schema, Person(pid, city), describes the city of residence for every person uniquely identified by pid. The following relational algebra operators...
Total Unique Visitors
Loading......