[Solved] The ___________ operation, denoted by −, allows us to find tuples that are in one relation but are not in another.

Q.	The ___________ operation, denoted by −, allows us to find tuples that are in one relation but are not in another.
A.	Union
B.	Set-difference
C.	Difference
D.	Intersection
Answer» B. Set-difference

1.4k

Do you find this helpful?

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

Related MCQs

The operation, denoted by −, allows us to ﬁnd tuples that are in one relation but are not in another.
A on an attribute of a relation is a data structure that allows the database system to ﬁnd those tuples in the relation that have a speciﬁed value for that attribute eﬃciently, without scanning through all the tuples of the relation.
Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
Given the relation Supplier(s_id, p_order, s_name, qty) Given that there is a unique s_name for each s_id and that s_id, p_order is a composite key, find the correct statement among the following: i. this relation is a BCNF ii. this is 3 NF relation iii. this is a 2 NF relation iv. this is a 1 NF relation
The operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
In a operations do not wait for requests to produce tuples, but instead generate the tuples eagerly.
Suppose now that R(A,B:) and S(A,B:) are two relations with r and s tuples, respectively (again, not necessarily distinct). If m is the number of (not necessarily distinct) tuples in the result of the SQL query: R intersect S; Then which of the following is the most restrictive, correct condition on the value of m?
The number of tuples in a relation is called it’s …………. While the number of attributes in a relation is called it’s ………………..
The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called
The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called ______________