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?

R contains a, b, e, f, g but not c, d.
R contains all of a, b, c, d, e, f, g.
R contains e, f, g but not a, b.
R contains e but not f, g.

LohaHridoy

4 views

2025-01-04 04:42

1 Answers

AhmedNazir

Option 3 : R contains e, f, g but not a, b.

[ alt="ya15" src="//storage.googleapis.com/tb-img/production/17/03/ya15.JPG">

Full natural outer join of R₁ and R₂ is :

[ alt="ya16" src="//storage.googleapis.com/tb-img/production/17/03/ya16.JPG">

Hence option 3 is correct:

4 views Answered 2022-09-04 04:29

Related Questions

In each of the following questions, two statements numbered I and II are given. There may be cause and effect relationship between the two statements. These two statements may be the effect of the same cause or independent causes. These statements may be independent causes without having any relationship. Read both the statements in each question and mark your answer. Statements: I. Hotel Leela venture, which currently has a debt of over Rs. 3,600 crore, had issued secured redeemable non-convertible debentures on private placement basis aggregating to Rs. 90 crores to LIC in December, 2008. II. Hotel Leela venture’s "operating cash flows are not sufficient to service its term loans and NCDs and the funds of the company are escrowed with its lenders and are also monitored by the lenders".?

1 Answers 6 Views

The question given below has two statements I and II. These statements may be either independent causes or maybe effects of independent causes or a common cause. One of these statements may be the effect of the other statement. Read both the statements and decide which of these answer choices correctly depicts the relationship between the two statements. Statements: I. Majority of the residents of the housing society participated in the dinner hosted by one of the members of the society. II. Most of the people living in the housing society invite other members for the functions at their house.?

1 Answers 5 Views

The question given below has two statements I and II. These statements may be either independent causes or maybe effects of independent causes or a common cause. One of these statements may be the effect of the other statement. Read both the statements and decide which of these answer choices correctly depicts the relationship between the two statements. Statements: I. Many shops in a locality remained closed throughout the day. II. Many offices in a locality closed during the day.?

1 Answers 7 Views

The question given below has two statements I and II. These statements may be either independent causes or maybe effects of independent causes or a common cause. One of these statements may be the effect of the other statement. Read both the statements and decide which of these answer choices correctly depicts the relationship between the two statements. Statements: I. There has been a considerable increase in the sale of fat free food articles. II. Now, people have become more conscious about their health condition and food habits.?

1 Answers 6 Views

The question given below has two statements I and II. These statements may be either independent causes or maybe effects of independent causes or a common cause. One of these statements may be the effect of the other statement. Read both the statements and decide which of these answer choices correctly depicts the relationship between the two statements. Statements: I. This year the cut off percentage for admission to junior colleges has increased over the last year. II. This year’s performance of the students in Xth final exam was considerably higher than that of the previous year.?

1 Answers 7 Views

Consider the following two tables and four queries in SQL. Book (isbn, bname), Stock (isbn, copies) Query 1: SELECT B.isbn, S.copies FROM Book B INNER JOIN Stock S ON B.isbn = S.isbn; Query 2: SELECT B.isbn, S.copies FROM Book B LEFT OUTER JOIN Stock S ON B.isbn = S.isbn; Query 3: SELECT B.isbn, S.copies FROM Book B RIGHT OUTER JOIN Stock S ON B.isbn = S.isbn; Query 4: SELECT B.isbn, S.copies FROM Book B FULL OUTER JOIN Stock S ON B.isbn = S.isbn; Which one of the queries above is certain to have an output that is a superset of the outputs of the other three queries?

1 Answers 6 Views

Below a question is given with two statements (I) and (II). These statements may be either independent causes or may be effects of independent causes or a common cause. One of these statements may be the effect of the other statement. Read both the statements and decide which of the following answer choice correctly depicts the relationship between these two statements. I: Kirti cut two inches of her hair. II: Split ends were troubling Kirti since a long time.?

1 Answers 4 Views

In the following question, two statements are given each followed by two conclusions I and II. You have to consider the statements to be true even if they seem to be at variance from commonly known facts. You have to decide which of the given conclusions, if any follows from the given statements. Statements: I) We are going back again to our ancestors and finding out the importance of Yoga and Pranayam. II) People in west have already opted it, It does not require any external equipment but only body and soul. Conclusions: I) Ancient science is treasure of many cures and natural remedies of various diseases. II) Technology has overshadowed these ancient sources and introduced new concepts of fitness called gym.?

1 Answers 5 Views

In the below question two statements I and II are given. These statements may either be independent causes or may be effects of independent causes or a common cause. One of these statements may be the effect of the other statement. Read both the statements and decide which of the following answer choice correctly depicts the relationship between these two statements. Statements: I) Saketh lost his job as a software professional due to the recession last month. II) Ayansh, a salesperson, received only half his salary as there is fall in demand for their products in the market?

1 Answers 4 Views

Two statements I and II are given. These statements may be either independent causes or may be the effects of independent causes or a common cause. One of these statements may be the effect of the other statement. Read both the statements and decide which of the following options correctly depicts the relationship between these two statements. Statements: I. The school bus with teachers and students couldn't reach the school on time. II. A major accident took place on the road blocking the traffic.?

1 Answers 4 Views

এক্সাম দিয়ে মেধা যাচাই করুন

Job Preparation (1125)

Admission (754)

এসএসসি (10)

এইচএসসি (5)