Q. The merge join can be used to compute

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. A join of the form r ⨝r.A=s.B s is called as

View solution

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

View solution

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

View solution

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

View solution

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

What does the above expression perform?

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

Q. Which of the following is not a relational algebra function?

View solution

Q. State true or false: In OLAP, analysts cannot view a dimension in different levels of detail.

View solution

Q. The operation of moving from coarser granular data to finer granular data is called _______

View solution

Q. State true or false: OLAP systems can be implemented as client-server systems

View solution

Q. Which of the following OLAP systems do not exist?

View solution

Q. The _______ function allows substitution of values in an attribute of a tuple

View solution

Q. How many dimensions of multi-dimensional data do cross tabs enable analysts to view?

View solution