Q. How is the left outer join symbol represented in relational algebra?

View solution

Q. How is the right outer join symbol represented in relational algebra?

View solution

Q. Πcustomer_name, loan_number, amount (borrower ⋈loan)

What does the above expression perform?

View solution

Q. Updating, Deleting and Inserting in relational algebra is done using the ________ operator

View solution

Q. State true or false: There exists a division operator in Relational Algebra

View solution

Q. The collections on which aggregate functions can operate are called as __________

View solution

Q. A join of the form r ⨝r.A=s.B s is called as

View solution

Q. If nested loop join is done on a per block basis rather than on a per tuple basis, it is called as

View solution

Q. The merge join can be used to compute

View solution

Q. The ___________ merges the sorted relation with leaf entries of the secondary B+ tree index.

View solution

Q. The splitting of input until each partition of the build input fits the memory is called as ______

View solution

Q. Overflow resolution is performed when,

View solution

Q. Which of the following is not a set operation

View solution

Q. Which of the following joins preserves the tuples of the relation on the left side of the operator?

View solution

Q. State true or false: The aggregation functions can be implemented in the same way as that of duplicate elimination.

View solution