Q. The select operation’s function in relational algebra is identical to the _______ clause in SQL

View solution

Q. The project operation’s function in relational algebra is identical to the _______ clause in SQL

View solution

Q. What does the following relational operation perform?
ρx(A1,A2,A3…) (E)

View solution

Q. What does the following relational algebra expression do?
σamount > 1200 (loan)

View solution

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