Zend
200-530 · Question #460
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?
The correct answer is C. SELECT Stud.Student_ID, Cou.Course_ID FROM Students Stud, Courses Cou WHERE. See the full explanation below for the reasoning.
Question
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?
Options
- ASELECT Stud.Student_ID, Cou.Course_ID FROM Students Stud, Courses Cou WHERE
- BSELECT Stud.Student_ID, Cou.Course_ID FROM Students Stud, Courses Cou WHERE \
- CSELECT Stud.Student_ID, Cou.Course_ID FROM Students Stud, Courses Cou WHERE
- DSELECT Stud.Student_ID, Cou.Course_ID FROM Students Stud, Courses Cou WHERE
How the community answered
(22 responses)- A5% (1)
- B14% (3)
- C77% (17)
- D5% (1)
Community Discussion
No community discussion yet for this question.