5 votes 5 votes The join operation can be defined as a cartesian product of two relations followed by a selection a cartesian product of two relations a union of two relations followed by cartesian product of the two relations a union of two relations Databases isro2008 databases relational-algebra + – go_editor asked Jun 12, 2016 go_editor 5.1k views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
Best answer 7 votes 7 votes Answer will be option A. Join is a combination of a Cartesian product followed by a selection process. A Join operation pairs two tuples from different relations, if and only if a given join condition is satisfied. reference:: http://www.tutorialspoint.com/dbms/database_joins.htm Anindita answered Jun 20, 2016 • selected Jun 25, 2016 by Arjun Anindita comment Share Follow See all 0 reply Please log in or register to add a comment.
8 votes 8 votes Answer : A Join is a combination of a Cartesian product followed by a selection process. A Join operation pairs two tuples from different relations, if and only if a given join condition is satisfied. shekhar chauhan answered Jun 12, 2016 shekhar chauhan comment Share Follow See all 0 reply Please log in or register to add a comment.
3 votes 3 votes ans is (a) A SQL join clause combines columns from one or more tables in a relational database. It creates a set that can be saved as a table or used as it is. A JOIN is a means for combining columns from one (self-table) or more tables by using values common to each. ANSI-standard SQL specifies five types of JOIN: INNER, LEFT OUTER,RIGHT OUTER, FULL OUTER and CROSS. As a special case, a table (base table, view, or joined table) can JOIN to itself in a self-join. https://en.wikipedia.org/wiki/Join_(SQL) kvkumar answered Jul 1, 2016 kvkumar comment Share Follow See all 0 reply Please log in or register to add a comment.