The                operator takes the results of two queries and returns only rows that appear in both result sets.

Related MCQs

• State true or false. i) Select operator is not a unary operator. ii) Project operator chooses subset of attributes or columns of a relation.
• Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is                            
• In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?
• The              clause allows us to select only those rows in the result relation of the           clause that satisfy a specified predicate.
• The ............ operator preserves unmatched rows of the relations being joined.
• Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?
• Which, if any, of the two queries above will correctly (in SQL2) get the desired set of employee ID’s?
• Which of the following retains duplicate rows in the result of a query or in an Aggregate expression?
• Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates _________ cardinality
• After conversion of high level queries into low level commands for file access and is called compiled_____: