Given two relation table R and S as follows:

R

A	B	C
a1	b1	c1
a3	b3	c3

S

C	D	E
c1	d1	e1
c2	d2	e2

What is the result from the following SQL statement?

SELECT *

FROM S LEFT OUTER JOIN R ON R.C = S.C

a.

A	B	C	C	D	E
a1	b1	c1	c1	d1	e1
			c3	d3	e3

b.

A	B	C	C	D	E
a1	b1	c1	c1	d1	e1
			c2	d2	e2

c.

A	B	C	C	D	E
a1	b1	c1	c1	d1	e1
a2	b2	c2

d.

A	B	C	C	D	E
a1	b1	c1	c1	d1	e1
a3	b3	c3

-----------------------------------------------------------------------

Given two relation table R and S as follows:

R

A	B	C
a1	b1	c1
a3	b3	c3

S

C	D	E
c1	d1	e1
c2	d2	e2

What is the result from the following SQL statement?

SELECT *

FROM S RIGHT OUTER JOIN R ON R.C = S.C

a.

A	B	C	C	D	E
a1	b1	c1	c1	d1	e1
			c3	d3	e3

b.

A	B	C	C	D	E
a1	b1	c1	c1	d1	e1
a2	b2	c2

c.

A	B	C	C	D	E
a1	b1	c1	c1	d1	e1
			c2	d2	e2

d.

A	B	C	C	D	E
a1	b1	c1	c1	d1	e1
a3	b3	c3

---------------------------------------------------------------------------------------------

Given two relation table R and S as follows:

R

A	B	C
a1	b1	c1
a3	b3	c3

S

C	D	E
c1	d1	e1
c2	d2	e2

What is the result from the following SQL statement?

SELECT *

FROM R LEFT OUTER JOIN S ON R.C = S.C

a.

A	B	C	C	D	E
a1	b1	c1	c1	d1	e1
			c2	d2	e2

b.

A	B	C	C	D	E
a1	b1	c1	c1	d1	e1
a3	b3	c3

c.

A	B	C	C	D	E
a1	b1	c1	c1	d1	e1
a2	b2	c2

d.

A	B	C	C	D	E
a1	b1	c1	c1	d1	e1
			c3	d3	e3