728x90
insert
-
SQLD 자격검증실전문제 122번 문제<자격증>/[SQLD] 2023. 3. 19. 15:59
Lee: GRANT SELECT, INSERT, DELETE ON R TO Kim WITH GRANT OPTION; Kim: GRANT SELECT, INSERT, DELETE ON R TO Park; Lee: REVOKE DELETE ON R FROM Kim; Lee: REVOKE INSERT ON R FROM Kim CASCADE; 1 Park: SELECT * FROM R WHERE A = 400; 2 Park: INSERT INTO R VALUES(400, 600); 3 Park: DELETE FROM R WHERE B=800; 4 Kim: INSERT INTO R VALUES(500, 600); 이후에 실행 가능한 SQL은 다음과 같습니다. Park: SELECT * FROM R WHERE A ..