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

题目

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

相似考题

1.You’re going to have a quiz ( )by another two in the ( )month.A. followed,followedB. followed,followingC. following,followedD. following,following

2.AJSPpageneedstoinstantiateaJavaBeantobeusedbyonlythatpage.Whichtwojsp:useBeanattributesmustbeusedtoaccessthisattributeintheJSPpage?()A.idB.typeC.nameD.classE.scopeF.create

3.如果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

4.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

更多“Given the following requirements:Create a table named TESTTAB, which has an identity colum ”相关问题

  • 第1题：

    对“named.conf”文件编辑完成后，需要执行（）命令，进行语法检测。

    A．naned.checkconf /var/named.conf

    B．named-checkconf /etc/named.conf

    C．named.checkzone /etc/named.conf

    D．named-checkzone /etc/named.conf


    named-checkconf /etc/named.conf

  • 第2题：

    命令在当前设计中创建一个时钟。

    A．create_clock

    B．create clock

    C．clock_name

    D．clock name


    create_clock

  • 第3题：

    如需设置4多列布局，以下何者正确？

    A．-webkit-colum-count: 4;

    B．-webkit-colum-count: 3;

    C．-webkit-box-flex: 4;

    D．-webkit-box-ordinal-group: 4;


    -webkit-colum-count: 4;

  • 第4题：

    对“named.rfc1912.zones”文件编辑完成后，需要执行（）命令，进行语法检测。

    A．named-checkconf /var/named.rfc1912.zones

    B．named-checkconf /etc/named.rfc1912.zones

    C．named.checkzone /etc/named.rfc1912.zones

    D．named-checkzone /etc/named.rfc1912.zones


    named-checkconf /etc/named.rfc1912.zones

  • 第5题：

    【单选题】对于建立在数据库上的DDL触发器，常用的激活DDL触发器的事件不包括（）

    A．Create_Table，Alter_Table，Drop_Table

    B．Create_View，Alter_View，Drop_View

    C．Create_Procedure，Alter_Procedure，Drop_Procedure

    D．Rollback


    Rollback

  • 第6题：

    如果要让某个用户能够在所有模式下建表应该授予此用户哪个权限？

    A．create table

    B．create any table

    C．create all table

    D．create * table


    create any table

相关内容