【2020年8月】Oracle OCP 071考试新题(-6题)CUUG内部题库

Choose the best answer.

Examine this statement:

SELECT 1 AS id, 'John' AS first_name, NULL AS commission

FROM DUAL

INTERSECT

SELECT 1, 'John' ,NULL

FROM DUAL

ORDER BY 3;

What is returned upon execution?

A) 2 rows

B) 1 row.

C) 0 rows

D) an error

2020年8月份Oracle OCP 071考试新题(-5题)CUUG内部题库,钉钉群(35277291)Oracle金牌名师亲自题库解析