Bissoy.com
Doctors Medicines MCQs Q&A

_________________ operations do not preserve non-matched tuples.

_________________ operations do not preserve non-matched tuples. Correct Answer Inner join

Left outer join returns all the rows from the table that is on the left side and matching rows on the right side of the join. Inner join returns all rows when there is at least one match in BOTH tables. Natural join returns the common columns from the tables being joined. A right outer join returns all the rows from the table that is on the right side and matching rows on the left side of the join.

Related Questions

Consider two database relations R and S having 3 tuples in R and 2 tuples in S. what is the maximum number of tuples that could appear in the natural join of R and S?
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?
Which of the following Relational Algebra operations can be used when you want to keep all the tuples of the first relation irrespective of whether or not they have matching tuples in the second relation?
In a _____________ operations do not wait for requests to produce tuples, but instead generate the tuples eagerly.
Which of the join operations do not preserve non matched tuples?
The join operations that do not retain mismatched tuples are called as _________ operations
The question given below consists of a statement, followed by three arguments numbered I, II and III. You have to decide which of the arguments is/are ‘strong’ arguments and which is/are ‘weak’ arguments and accordingly choose your answer from the alternatives given below each question. Statement: The imposition of Governor’s rule in Jammu and Kashmir will not affect operations in the state, according to Army Chief General, even as security forces are looking at higher intensity of operations against terrorists, to force them to ‘hibernate’. These operations will be based on greater level of intelligence from the J&K Police, as compared to what was being generated during the suspension of operations for the holy month of Ramzan. A challenge, however, for the security forces still remains the recruitment of local terrorists. Why? Arguments: I. Meanwhile, data shared by security forces reveal that there are about 210 terrorists currently operating in Kashmir, mainly in the South. Out of this, 65 per cent are locals and the remaining are foreign terrorists.  II. In South Kashmir itself, the maximum number of terrorists belong to the HizbulMujahideen, while some are from the Lashkar-e-Toiba and Jaish-e-Mohammed. III. When a local terrorist is killed during an operation, at his funeral more locals are willing to join terrorism. It is a mob mentality.
Consider two relations R1(A, B) with the tuples (1, 5), (3, 7) and R2(A, C) = (1, 7), (4, 9). Assume that R(A, B, C) is the full natural outer join of R1 and R2. Consider the following tuples of the form (A, B, C): a = (1, 5, null), b = (1, null, 7), c = (3, null, 9), d = (4, 7, null), e = (1, 5, 7), f = (3, 7, null), g = (4, null, 9). Which one of the following statements is correct?
SQL allows duplicate tuples in relations, and correspondingly defines the multiplicity of tuples in the result of joins. Which one of the following queries always gives the same answer as the nested select * from R where a in (select S.a from S)
A ________ on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.