A. SELECT order_id, order_date FROM ordersWHERE order_date > IN(SELECT order_date FROM 주문 WHERE customer_id = 101);

B. SELECT order_id, order_date FROM ordersWHERE order_date > ALL(SELECT MAX(order_date) FROM 주문 ) AND customer_id = 101;

C. SELECT order_id, order_date FROM ordersWHERE order_date > ALL(SELECT order_date FROM 주문 WHERE customer_id = 101);

D. SELECT order_id, order_date FROM ordersWHERE order_date >ANY(SELECT order_date FROM 주문 WHERE customer_id = 101);

A. SELECT LOWER (SUBSTR('Hello World', 2)) FROM DUAL;

B. SELECT INITCAP(TRIM('H' FROM 'Hello World')) FROM DUAL;

C. SELECT LOWER(TRIM('H' FROM 'Hello World')) FROM DUAL;

D. SELECT SUBSTR('Hello World', 2) FROM DUAL;

E. SELECT LOWER(SUBSTR('Hello World, 2, 1)) FROM DUAL;

A. SELECT d.department_id, c.course_id FROM Department_details d LEFT OUTER JOIN Course_details c ON (d.department_id=c.department_id);

B. 선택 d.department_id, c.course_id FROM Course_details c LEFT OUTER JOIN Department_details d ON (c.department_id=d.department_id);

C. d.department_id, c.course_id FROM Department_details d RIGHT OUTER JOIN Course_details c ON 선택 (d.department_id=c.department_id);

D. d.department_id, c.course_id FROM Department_details d RIGHT OUTER JOIN Course_details c ON 선택(c.department_id=d.department_id);

A. 테이블에 정의된 모든 트리거를 삭제합니다.

B. 제거된 행이 사용하는 공간을 항상 유지합니다.

C. ROLLBACK 문을 사용하여 삭제된 데이터를 검색할 수 있습니다.

D. 테이블에 정의된 무결성 제약 조건을 유지합니다.

E. 테이블에 정의된 인덱스를 유지합니다.

F. FLASHBACK TABLE 문을 사용하여 삭제된 데이터를 검색할 수 있습니다.

A. SELECT deptno,LISTAGG(ename, ' , ') WITHIN GROUP AS employee_list FROM emp GROUP BY deptno;

B. SELECT deptno,LISTAGG(ename, ', ') WITHIN GROUP (GROUP BY deptno) AS employee_list FROM emp ORDER BY ename;

C. SELECT deptno,LISTAGG(ename, ', ') WITHIN GROUP AS employee_list FROM emp GROUP BY deptno ORDER BY ename;

D. SELECT deptno,LISTAGG(ename, ', ') WITHIN GROUP (ORDER BY ename) AS employee_list FROM emp GROUP BY deptno;