Question
a.
LEFT OUTER JOIN
b.
FULL OUTER JOIN
c.
HALF OUTER JOIN
d.
DOWNWARD JOIN
Posted under DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. If matching tuples are not found, the kind of OUTER JOIN operation which keeps all the tuples of first and second relation is classified as
Similar Questions
Discover Related MCQs
Q. The operations which are used to enhance the power of expression of relational algebra includes
View solution
Q. In the relational calculus, the variables are bounded with the help of
View solution
Q. In unary relational operations, the symbols such as equal to, less than and greater than are classified as
View solution
Q. The JOIN operation which uses any of the comparison operators is classified as
View solution
Q. The kind of operation by which one tuple can be created with the help of combining tuples from two relations is classified as
View solution
Q. Consider two tuples X and Y, the operation whose result includes tuples that are only in X but not in Y is classified as
View solution
Q. As compared to Cartesian product, the tuples which appears in the result by applying JOIN are the ones
View solution
Q. Consider two tuples R and S, the maximum size of R and S relations is divided to expected size of join is classified as
View solution
Q. In the notation for query trees, the node which is used to terminate the execution is classified as
View solution
Q. The expression used in relational calculus to specify request of retrieval is classified as
View solution
Q. The compatibility condition which states that the relations for union and intersection operations must consist of same type of tuples is classified as
View solution
Q. If the common attributes of two relations are classified as join attributes then the OUTER UNION must be equal to
View solution
Q. The degree of the PROJECT operation is equal to
View solution
Q. The operations used to combine multiple relations to present information in single table are classified as
View solution
Q. In the notation for query graphs, the single circles are used to represent
View solution
Q. The JOIN operation in which only equality operator is used is classified as
View solution
Q. In relational calculus, the expression which does not guarantees finite number of tuples is classified as
View solution
Q. In unary relational operations, the PROJECT operation is partition of relation usually classified as
View solution
Q. The JOIN operation in which two attributes joined have same name in both relations is classified as
View solution
Q. Consider two tuples A and B, the operation whose result includes tuples that are included in both relations is classified as
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!