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

参考答案

更多 “ 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

查看答案

热门标签

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：