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;

Explanation:

One Comment on “Which of the following SELECT statements will he use to define an outer join?


Leave a Reply

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