Consider the following two statements: S1: If a database has two tables T1, T2…

Consider the following two statements:

S1: If a database has two tables T1, T2 and both of these tables have a same column C, then C is a foreign key.

S2: Number of tuples in left outer join of relation r and s is strictly greater than number of tuples in full outer join of r and s.

Which of the following is correct about S1 and S2?

  1. A.

    S1 is true but S2 is false

  2. B.

    S1 is false but S2 is true

  3. C.

    Both S1 and S2 are true

  4. D.

    Both S1 and S2 are false

Attempted by 63 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…