What Action Does 8904 Operator Perform In Relational Algebra #567
What action does ⋈ operator perform in relational algebra
This multiple choice question (MCQ) is related to the book/course
gs gs114 Relational Database Management System.
It can also be found in
gs gs114 Introduction to Relational Model and SQL - Introduction to the Relational Model - Quiz No.1.
What action does ⋈ operator perform in relational algebra
Output specified attributes from all rows of the input relation and remove duplicate tuples from the output
Outputs pairs of rows from the two input relations that have the same value on all attributes that have the same name
Output all pairs of rows from the two input relations (regardless of whether or not they have the same values on common attributes)
Return rows of the input relation that satisfy the predicate
