Given the following requirements:
Create a table named TESTTAB, which has an identity column named ACTIVITYNO. Define the
identity column to generate the values for the column by default. Start the values at 10 and
increment by 10. Make the identity column unique.
Which of the following CREATE statements will successfully create this table?
A.
CREATE TABLE TESTTAB
(ACTIVITYNO SMALLINT NOT NULL
GENERATED ALWAYS AS IDENTITY
(START WITH 10
INCREMENT BY 10),
ACTKWD CHAR(6) NOT NULL,
ACTDESC VARCHAR(20) NOT NULL,
UNIQUE(ACTIVITYNO))
B.
CREATE TABLE TESTTAB
(ACTIVITYNO SMALLINT NOT NULL
GENERATED ALWAYS AS IDENTITY
(START WITH 1
INCREMENT BY 10),
ACTKWD CHAR(6) NOT NULL,
ACTDESC VARCHAR(20) NOT NULL,
UNIQUE(ACTNO))
C.
CREATE TABLE TESTTAB
(ACTIVITYNO SMALLINT NOT NULL
GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 1),
ACTKWD CHAR(6) NOT NULL,
ACTDESC VARCHAR(20) NOT NULL,
UNIQUE(ACTIVITYNO))
D.
CREATE TABLE TESTTAB
(ACTIVITYNO SMALLINT NOT NULL
GENERATED BY DEFAULT AS IDENTITY
(START WITH 10
INCREMENT BY 10),
ACTKWD CHAR(6) NOT NULL,
ACTDESC VARCHAR(20) NOT NULL,
UNIQUE(ACTIVITYNO))