nerdexam
Zend

ZF-100-500 · Question #182

Ross creates a database for a school. He creates two tables nam ed Students and Courses. Which of the following SELECT statements will he use to define an outer join?

The correct answer is A. 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 nam ed 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

(39 responses)
  • A
    77% (30)
  • B
    3% (1)
  • C
    13% (5)
  • D
    8% (3)

Community Discussion

No community discussion yet for this question.

Full ZF-100-500 Practice