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

Q. Cross Product is a:

View solution

Q. Consider the join of a relation R with relation S. If R has m tuples and S has n tuples, then the maximum size of join is:

View solution

Q. The natural join is equal to :

View solution

Q. In unary relational operations, the SELECT operation is partition of relation usually classified as

View solution

Q. The operators in SELECT operation statement such as 'and' , 'or' and 'not' are classified as

View solution

Q. If in the JOIN operation, the conditions of JOIN operation are not satisfied then the results of the operation is

View solution