Ross creates a database for a school. He creates two tables named Students and Courses. Which
of the following SELECT statements will he use to define an outer join?
A.
SELECT Stud.Student_ID, Cou.Course_ID
FROM Students Stud, Courses Cou
WHERE Stud.Course_ID (+) = Cou.Course_ID;
B.
SELECT Stud.Student_ID, Cou.Course_ID
FROM Students Stud, Courses Cou
WHERE Stud.Fees BETWEEN Cou.Min_Fees and Cou.Max_Fees;
C.
SELECT Stud.Student_ID, Cou.Course_ID
FROM Students Stud, Courses Cou
WHERE Stud.Course_ID = Cou.Course_ID;
D.
SELECT Stud.Student_ID, Cou.Course_ID
FROM Students Stud, Courses Cou
WHERE Stud.Student_ID = Cou.Course_ID;
Explanation:
I choose A
0
0