nerdexam
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)
  • A
    5% (1)
  • B
    14% (3)
  • C
    77% (17)
  • D
    5% (1)

Community Discussion

No community discussion yet for this question.

Full 200-530 Practice