Given the following requirements:Create a table named TESTTAB, which has an identity colum

题目

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题:

AJSPpageneedstoinstantiateaJavaBeantobeusedbyonlythatpage.Whichtwojsp:useBeanattributesmustbeusedtoaccessthisattributeintheJSPpage?()

A.id

B.type

C.name

D.class

E.scope

F.create


参考答案:A, D

第2题:

对“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

第3题:

You’re going to have a quiz ( )by another two in the ( )month.

A. followed,followed

B. followed,following

C. following,followed

D. following,following


参考答案:B

第4题:

如需设置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;

第5题:

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

A.create_clock

B.create clock

C.clock_name

D.clock name


create_clock

第6题:

如果table_name表中有索引index_name,删除此索引的语句错误的是()。

A.DROP INDEX index_name ON talbe_name

B.ALTER TABLE table_name DROP INDEX index_name

C.DROP INDEX table_name.index_name

D.ALTER TABLE table_name DROP CONSTRAINT index_name


ALTER TABLE table_name DROP CONSTRAINT index_name

第7题:

对“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

第8题:

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

B. HttpContext.Current.User.Identity.Name

C. ServiceSecurityContext.Current.PrimaryIdentity.Name

D. OperationContext.Current.ServiceSecurityContext.PrimaryIdentity.Name


参考答案:C, D

第9题:

【单选题】对于建立在数据库上的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

第10题:

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

A.create table

B.create any table

C.create all table

D.create * table


create any table