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

Q. Because of the calculus expression, the relational calculus is considered as

View solution