The following statements:CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY(col1)); CREATE TABLE t2 (col1 INT NOT NULL, col2 CHAR(1) NOT NULL, PRIMARY KEY (col1, col2), FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE CASCADE ON UPDATE RESTRICT); CREATE TAB

题目

The following statements:CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY(col1)); CREATE TABLE t2 (col1 INT NOT NULL, col2 CHAR(1) NOT NULL, PRIMARY KEY (col1, col2), FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE CASCADE ON UPDATE RESTRICT); CREATE TABLE t3 (col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (col1, col2),FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE NO ACTION ON UPDATE RESTRICT);INSERT INTO t1 VALUES (1), (2); INSERT INTO t2 VALUES (1, ‘a‘), (1, ‘b‘), (2,‘c‘); INSERT INTO t3 VALUES (1, 100), (2, 200), (2,300);How many rows will be deleted by the following DELETE statement? DELETE FROM t1 WHERE col1= 1;（）

A.4

B.3

C.1

D.0

相似考题

1.在文件系统中，若要实现文件拷贝功能，可利用已有的系统调用，它们是A．create,open,read,write,closeB．create,open,read,write,deleteC．create,open,read,writeD．create,read,write,close

2.YouworkwithadatabasenamedDB1，whichislocatedonaSQLServer2005computer.YoudiscoverthatatablescanonTable1inDB1causesaslowquery.Table1isaverylargetablethatisusedfrequently.Youascertainthatthequerycontainsthefollowingstatement.SELECTcol1，col2FROMtable1WHEREcol3=Youneedtoprovidemaximumqueryperformance.Table1mustremainavailabletousers.Whatshouldyoudo？（）A.UpdateallstatisticsonTable1inDB1.B.UsetheCREATESTATISTICSstatementinDB1tocreatemissingstatisticsoncol3ofTable1.C.Setthepriorityboostserveroptionto1.D.Executethefollowingstatement.USEDB1GOCREATEINDEXindex1ONtable1（col3）INCLUDE（col1，col2）WITH（ONLINE=ON）GO

3.下列四组SQL命令，全部属于数据定义语句的命令是（）A．CREATE，DROP，UPDATEB．CREATE，DROP，ALTERC．CREATE，DROP，GRANTD．CREATE，DROP，SELECT

4.Yourapplicationrequiresthatyouprogrammaticallymanipulateanonqueryrecordgroup.Whichthreebuilt－inscanyouuse?()A.CREATE_GROUPB.ADD_GROUP_NOWC.POPULATE_GROUPD.ADD_GROUP_COLUMNE.CREATE_GROUP_FROM_QUERY

更多“The following statements:CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY(col1)); CREATE TA ”相关问题

  • 第1题：

    下列哪组SQL命令全部属于数据定义语句的命令？（）

    A．CREATE，DROP，ALTER

    B．CREATE，DROP，SELECT

    C．CREATE，DROP，GRANT

    D．CREATE，DROP，UPDATE


    CREATE，DROP，ALTER

  • 第2题：

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

  • 第3题：

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

    A．create table

    B．create any table

    C．create all table

    D．create * table


    create any table

  • 第4题：

    对于表A（col1 int,col2 char（1))使用聚合函数sum，下面语句正确的是（）

    A．select sum(col2) as col2 from A group by col1

    B．select sum(col1) as col1 from A group by col2

    C．select sum(col1) as col1,col2 from A group by col1

    D．select sum(col2) as col1 from A group by col2


    逻辑右移

  • 第5题：

    下列四组SQL命令，全部属于数据定义语句的命令是（）。

    A．CREATE，DROP，ALTER

    B．CREATE，DROP，UPDATE

    C．CREATE，DROP，GRANT

    D．CREATE，DROP，SELECT


    CREATE ， DROP ， ALTER

相关内容