🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← Quiz: ER to Tables: all 15 questions

Quiz: ER to Tables · Question 15 of 15

Listing each course with its prerequisite's title needs the course table twice. How is that written?

Listing each course with its prerequisite's title needs the course table twice. How is that written?

  1. A.With UNION
  2. B.With a CROSS JOIN only
  3. C.Join course twice under different aliases, such as c and pre
  4. D.It cannot be done in SQL
Answer & explanation

Correct answer: Join course twice under different aliases, such as c and pre

Aliases let the same table play two roles, as in any self join.

Can you get the rest right without peeking?

Take the timed Quiz: ER to Tables quiz free. Pass it to earn XP and count towards your certificate.

Start the quiz →