SQLD · 제61회 · 48번

Question

다음 중 오류가 발생하는 SQL은? 보기 CREATE TABLE DEPT ( DEPT_ID NUMBER PRIMARY KEY , DEPT_NAME VARCHAR2 (20) ); CREATE TABLE EMP ( EMP_ID NUMBER PRIMARY KEY , EMP_NAME VARCHAR2 (20), DEPT_ID NUMBER , CONSTRAINT FK_DEPT FOREIGN KEY (DEPT_ID) REFERENCES DEPT(DEPT_ID) ); INSERT INTO DEPT VALUES (10, '개발팀' ); INSERT INTO EMP VALUES (1, 'KIM' , 10); COMMIT ;

Accepted Answer

INSERT INTO EMP VALUES (4, 'CHOI', 20);

Answer

INSERT INTO EMP VALUES (2, 'LEE', 10);

Answer

INSERT INTO EMP VALUES (3, 'PARK', NULL);

Answer

DELETE FROM EMP WHERE EMP_ID = 1;