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?

 

CREATE TABLE TESTTAB(ACTIVITYNOSMALLINT NOT NULLGENERATED ALWAYS AS IDENTITY(START WITH 10INCREMENT BY 10),ACTKWD CHAR(6) NOT NULL,ACTDESC VARCHAR(20) NOT NULL,UNIQUE(ACTIVITYNO)) 

CREATE TABLE TESTTAB(ACTIVITYNO SMALLINT NOT NULLGENERATED ALWAYS AS IDENTITY(START WITH 1INCREMENT BY 10),ACTKWD CHAR(6) NOT NULL,ACTDESC VARCHAR(20) NOT NULL,UNIQUE(ACTNO)) 

CREATE TABLE TESTTAB(ACTIVITYNO SMALLINT NOT NULLGENERATED BY DEFAULT AS
IDENTITY (START WITH 10 INCREMENT BY 1),ACTKWD CHAR(6) NOT NULL,ACTDESC
VARCHAR(20) NOT NULL,UNIQUE(ACTIVITYNO)) 

CREATE TABLE TESTTAB(ACTIVITYNO SMALLINT NOT NULLGENERATED BY DEFAULT AS
IDENTITY(START WITH 10INCREMENT BY 10),ACTKWD CHAR(6) NOT NULL,ACTDESC
VARCHAR(20) NOT NULL,UNIQUE(ACTIVITYNO))