PrepAway - Latest Free Exam Questions & Answers

Which of the following SELECT statements will he use to define an outer join?

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?

PrepAway - Latest Free Exam Questions & Answers

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;


Leave a Reply

Your email address will not be published. Required fields are marked *