← Back to exam page

1z0-882 – MySQL 5.6 Developer

Loading demo links...

Showing 10–10 of 10 questions

Question 10

Given the data:

Expected output:

Which query produces the expected output?

Select an option, then click Submit answer.

  • ○

    SELECT colors2.name, colors1.name
    FROM colors2
    OPTIONAL JOIN colors1
    ON colors2.name, colors1.name
  • ○

    SELECT colors2.name, colors1.name
    FROM colors2
    NATURAL JOIN colors1
    ON colors2.name=colors1.name
  • ○

    SELECT colors2.name, colors1.name
    FROM colors2
    STRAIGHT JOIN colors1
    ON colors2.name, =colors1.name
  • ○

    SELECT colors2.name,colors1.name
    FROM colors2
    LEFT JOIN colors1
    ON colors2.name=colors1.name
  • ○

    SELECT colors2.name,colors1.name
    FROM colors2
    RIGHT JOIN colors1
    ON colors2.name=colors1.name