SQLD(SQL 개발자) 기출 · DDL

이 문제 풀어보기

1. 1.CREATE TABLE PRODUCT
   ( PROD_ID VARCHAR2(10) NOT NULL
   ,PROD_NM VARCHAR2(100) NOT NULL
   ,REG_DT DATE NOT NULL
   ,REGR_NO NUMBER(10)
   ,CONSTRAINT PRODUCT_PK PRIMARY KEY (PROD_ID) );
2. 2.CREATE TABLE PRODUCT
   ( PROD_ID VARCHAR2(10) NOT NULL
   ,PROD_NM VARCHAR2(100) NOT NULL
   ,REG_DT DATE NOT NULL
   ,REGR_NO NUMBER(IO) NULL
   ,ADD CONSTRAINT PRIMARY KEY (PROD_ID) )；
3. 3.CREATE TABLE PRODUCT
   ( PROD_ID VARCHAR2(10)
   ,PROD_NM VARCHAR2(100)
   ,REG_DT DATE
   ,REGR_NO NUMBER(10) )；
   ALTER TABLE PRODUCT ADD CONSTRAINT PRODUCT_PK
   PRIMARY KEY (PROD_ID)；
4. 4.CREATE TABLE PRODUCT
   ( PROD_ID VARCHAR2(10) NOT NULL
   ,PROD_NM VARCHAR2(100) NOT NULL
   ,REG_DT DATE NOT NULL
   ,REGR_NO NUMBER(10) NULL)；
   ALTER TABLE PRODUCT ADD PRIMARY KEY PRODUCT_PK ON
   (PROD_ID)；