当前位置:IBM(000-730)题库

问题:

[单选] 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))

充装工业用液化石油气的气瓶字色为()。 大红;。 黑;。 淡黄;。 白。 During a planning session, the customer indicates the need to provide high availability between a  Node attached to an IBM TotalStorage Enterprise Storage Server and a remote node attached to a IBM TotalStorage FAStT server with automatic fallover in the event of a disaster.  Which of the following HACMP options will provide this functionality?()    GeoRM。  HACMP/XD:PPRC。  HACMP/XD:GPFS。  HACMP/XD:HAGEO。 两闸瓦托扭曲原型不大于()。 3mm。 5mm。 10mm。 15mm。 DS5020磁盘阵列支持 SAS 和 SATA 磁盘的混插。 急性毒性试验的目的是什么? 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?()
参考答案:

  参考解析

本题暂无解析

在线 客服