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?

Sign in or unlock 200-530 to reveal the answer and full explanation for question #460. The question stem and answer options stay visible for context.

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

Unlock 200-530 to see the answer

You've previewed enough free 200-530 questions. Unlock 200-530 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 200-530 Practice