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 FULL OUTER JOIN S ON R.C = S.C

a.

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

b.

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

c.

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

d.

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

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 RIGHT 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
			c3	d3	e3

c.

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

d.

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

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