Q. Which of the following is a fundamental operation in relational algebra ?

View solution

Q. Which of the following is used to denote the selection operation in relational algebra ?

View solution

Q. For select operation the ________ appear in the subscript and the ___________ argument appears in the paranthesis after the sigma.

View solution

Q. The ___________ operation, denoted by -, allows us to find tuples that are in one relation but are not in another.

View solution

Q. Which is a unary operation:

View solution

Q. In precedence of set operators the expression is evaluated from

View solution

Q. If E1 and E2 are relational algebra expressions, then which of the following is NOT a relational algebra expression ?

View solution

Q. The operation of a relation X, produces Y, such that Y contains only selected attributes of X. Such an operation is :

View solution

Q. If T1 and T2 are two relations, then which of the following is not a valid relational algebra expression ?

View solution

Q. Which of the following is not valid unary operation in the relational algebra ?

View solution

Q. Relational algebra is :

View solution

Q. Relational calculus is a

View solution

Q. Cartesian product in relational algebra is

View solution

Q. In tuple relational calculus P1 → P2 is equivalent to

View solution

Q. Relational Algebra is

View solution

Q. _______ produces the relation that has attributes of R1 and R2.

View solution

Q. Which of the following operation is used if we are interested in only certain columns of a table?

View solution

Q. Which of the following operations need the participating relations to be union compatible?

View solution

Q. The result of the UNION operation between R1 and R2 is a relation that includes

View solution

Q. Using Relational Algebra the query that finds customers, who have a balance of over 1000 is

View solution