Q. The operation which is not considered a basic operation of relational algebra is

View solution

Q. Relational Algebra is a __________ query language that takes two relation as input and produces another relation as output of the query.

View solution

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