SQLD CBT 기출문제 예상문제 947번

다음 문제를 풀어보세요.

다음 보기 중 아래 SQL과 실행결과가 동일한 것을 고르시오.

SELECT E.EMPNO
     , E.ENAME
     , E.DEPTNO
     , (SELECT DNAME FROM DEPT D WHERE D.DEPTNO = E.DEPTNO) DNAME
FROM (SELECT *
      FROM   EMP 
      ORDER  BY EMPNO DESC
     ) E
WHERE  ROWNUM <= 10;

SELECT *
FROM  (SELECT E.EMPNO
            , E.ENAME
            , E.DEPTNO
            , D.DNAME
       FROM   EMP E, DEPT D
       WHERE  E.DEPTNO = D.DEPTNO
       ORDER  BY E.EMPNO DESC
      ) 
WHERE  ROWNUM <= 10;

SELECT *
FROM  (SELECT E.EMPNO
            , E.ENAME
            , E.DEPTNO
            , D.DNAME
       FROM   EMP E, DEPT D
       WHERE  E.DEPTNO = D.DEPTNO(+)
       ORDER  BY E.EMPNO DESC
      )
WHERE  ROWNUM <= 10;

SELECT *
FROM  (SELECT E.EMPNO
            , E.ENAME
            , E.DEPTNO
            , D.DNAME
       FROM   EMP E, DEPT D
       WHERE  E.DEPTNO = D.DEPTNO(+)
      )
WHERE  ROWNUM <= 10;

SELECT *
FROM  (SELECT E.EMPNO
            , E.ENAME
            , E.DEPTNO
            , D.DNAME
       FROM   EMP E, DEPT D
       WHERE  E.DEPTNO = D.DEPTNO
      ) 
WHERE  ROWNUM <= 10;