The _______ operator takes the results of two queries and returns only – McqOptions

MCQOPTIONS

1.	The _______ operator takes the results of two queries and returns only rows that appear in both result sets.
A.	Union
B.	Intersect
C.	Difference
D.	Projection
Answer» C. Difference

Discussion

No Comment Found

Related MCQs

The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.
A functional dependency f on R is _______ by a set of functional dependencies F on r if every instance of r(R) that satisfies f also satisfies F.
To specify the foreign keys in relations referencing temporal data we need to specify _______
An instance of a relation that satisfies all real world constraints is known as?
The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation.
If K → R then K is said to be the _______ of R
Student(ID, name, dept name, tot_cred)In this query which attribute form the primary key?
A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.
Which one of the following is a procedural language ?