Examine this statement: SELECT 1 AS id, ' John' AS name FROM DUAL UNION SELECT 1 , ' John' AS name FROM DUAL ORDER BY 1; What is returned upon execution? A an error B 0 rows C 2 rows D 1 row