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))

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))

相关考题：

You’re going to have a quiz ( )by another two in the ( )month. A. followed,followedB. followed,followingC. following,followedD. following,following
查看答案
A self-hosted Windows Communication Foundation (WCF) service uses a secure HTTP binding with a custom principal permission mode. The binding requires users to provide their Windows logon credentials. You need to retrieve the identity of the caller.What are two possible properties you can use to achieve this goal? (Each correct answer presents a complete solution Choose two)（）A. Thread.CurrentPrincipal.Identity.NameB. HttpContext.Current.User.Identity.NameC. ServiceSecurityContext.Current.PrimaryIdentity.NameD. OperationContext.Current.ServiceSecurityContext.PrimaryIdentity.Name
查看答案
AJSPpageneedstoinstantiateaJavaBeantobeusedbyonlythatpage.Whichtwojsp:useBeanattributesmustbeusedtoaccessthisattributeintheJSPpage?() A.idB.typeC.nameD.classE.scopeF.create
查看答案
如果table_name表中有索引index_name，删除此索引的语句错误的是（）。A．DROP INDEX index_name ON talbe_nameB．ALTER TABLE table_name DROP INDEX index_nameC．DROP INDEX table_name.index_nameD．ALTER TABLE table_name DROP CONSTRAINT index_name
查看答案
对“named.conf”文件编辑完成后，需要执行（）命令，进行语法检测。A．naned.checkconf /var/named.confB．named-checkconf /etc/named.confC．named.checkzone /etc/named.confD．named-checkzone /etc/named.conf
查看答案
对“named.rfc1912.zones”文件编辑完成后，需要执行（）命令，进行语法检测。A．named-checkconf /var/named.rfc1912.zonesB．named-checkconf /etc/named.rfc1912.zonesC．named.checkzone /etc/named.rfc1912.zonesD．named-checkzone /etc/named.rfc1912.zones
查看答案
命令在当前设计中创建一个时钟。A．create_clockB．create clockC．clock_nameD．clock name
查看答案
【单选题】对于建立在数据库上的DDL触发器，常用的激活DDL触发器的事件不包括（）A．Create_Table，Alter_Table，Drop_TableB．Create_View，Alter_View，Drop_ViewC．Create_Procedure，Alter_Procedure，Drop_ProcedureD．Rollback
查看答案
如需设置4多列布局，以下何者正确？A．-webkit-colum-count: 4;B．-webkit-colum-count: 3;C．-webkit-box-flex: 4;D．-webkit-box-ordinal-group: 4;
查看答案
如果要让某个用户能够在所有模式下建表应该授予此用户哪个权限？A．create tableB．create any tableC．create all tableD．create * table
查看答案
热门标签