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

Q. The DIVISION operation can be applied to two relations A and B such as R(A) ÷ R(B) where as

View solution

Q. In the EQUIJOIN condition, the operation which is used to avoid superfluous attribute is classified as

View solution

Q. The Boolean expression used in the SELECT operation consists of clauses such as

View solution

Q. The types of binary operations includes

View solution

Q. In the notation for query graphs, the double ovals or circles are used to represent

View solution

Q. The operation which allows to process relationships from multiple relations rather than single relation is classified as

View solution

Q. The branch of calculus which is based on mathematical logic is classified as

View solution

Q. In a query tree, the operations of relational algebra are classified as

View solution