a) -> b) <- c) = d) == Answer: b Explanation: The result of the expression to the right ...
View QuestionWhich of the following is not outer join?
a) Left outer join b) Right outer join c) Full outer join d) All of the ...
View QuestionIn precedence of set operators, the expression is evaluated from
a) Left to left b) Left to right c) Right to left d) From user specification Answer: b Explanation: ...
View QuestionWhich is a join condition contains an equality operator:
a) Equijoins b) Cartesian c) Natural d) Left Answer: a Explanation: Equijoins
View QuestionWhich is a unary operation:
a) Selection operation b) Primitive operation c) Projection operation d) Generalized selection Answer: d Explanation: Generalization Selection ...
View QuestionThe ___________ operation, denoted by −, allows us to find tuples that are in one relation but are not in another.
a) Union b) Set-difference c) Difference d) Intersection Answer: b Explanation: The expression r − s produces a relation ...
View QuestionFor select operation the ________ appear in the subscript and the ___________ argument appears in the paranthesis after the sigma.
a) Predicates, relation b) Relation, Predicates c) Operation, Predicates d) Relation, Operation Answer: a Explanation: ...
View QuestionWhich of the following is used to denote the selection operation in relational algebra?
a) Pi (Greek) b) Sigma (Greek) c) Lambda (Greek) d) Omega (Greek) Answer: b Explanation: The select operation selects ...
View QuestionWhich of the following is a fundamental operation in relational algebra?
a) Set intersection b) Natural join c) Assignment d) None of the mentioned Answer: d Explanation: The ...
View QuestionRelational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.
a) Relational b) Structural c) Procedural d) Fundamental Answer: c Explanation: This language has fundamental and other operations which are ...
View Question