SQL 시험대비 실습 문제 전부 풀기 PPT 2 번

 110 p 

DDL ( index 실습 idx 1 ) 

CREATE UNIQUE INDEX idx_u_dept_test2_01 ON dept_test2 ( deptno ) ;

CREATE INDEX idx_nu_dept_test2_02 ON dept_test2 ( dname);

CREATE INDEX idx_nu_dept_test2_03 ON dept_test2 ( deptno , dname);

DDL ( index 실습 idx 2 )

DROP INDEX idx_u_dept_test2_01 ;

DROP INDEX idx_nu_dept_test2_02;

DROP INDEX idx_nu_dept_test2_03;  

DDL ( index 실습 idx 3 ) 정답없음

CREATE unique index idx_u_dept_test2_01 ON dept_test2 ( deptno);

CREATE INDEX idx_nu_dept2_02 ON dept_test2(dname) ; 

CREATE INDEX idx_nu_dept_test2_03 ON dept_test2 ( dept,dname) 

DDL ( index 실습 idx 4 )

47p 

DDL ( Table - comments 실습 comment1 ) 

SELECT c.table_name, t.table_type, t.comments, c.column_name, c.comments

FROM user_tab_comments t, user_col_comments c

WHERE t.table_name = c.table_name

AND c.table_name IN ( 'CUSTOMER' , 'PRODUCT' , 'CYCLE' , 'DAILY' )