A、A.update table A setcol2=’N’ where col1=1
B、B.modify table A setcol2=N where col1=1
C、C.update A set col2=’N’ where col1=1
D、D.modify A set col2=N where col1=1
更多“对于表A（col1 int，col2 char（1））更新col1=1的数据col2值为N，下面语句正确的是（）”相关的问题
A、select col1，col2，col3 from T1 into T2（col1，col2，col3） B、insert T1 （col1，col，col3） into T2（col1，col2，col3） C、insert into T2 （col1，col2，col3） as select col1，col2，col3 from T1 D、insert into T2（col1，col2，col3） select col1，col2，col3 from T1；
A、The operation col1.retainAll（col2） will not modify the col1 object. B、The operation col1.removeAll（col2） will not modify the col2 object. C、The operation col1.addAll（col2） will return a new collection object， containing elements from both col1 and col2. D、The operation col1.containsAll（Col2） will not modify the col1 object.
A、更新DB1数据库中表Table1的所有统计信息 B、在DB1数据库中，使用CREATE STATISTICS 语句为表Table1的列col3创建缺少的统计信息 C、设置优先值提升选项的值为1 D、执行如下语句：USE DB1 GO CREATE INDEX index1 ON table1（col3） INCLUDE（col1， col2） WITH （ONLINE = ON） GO E、执行如下语句 USE DB1GOCREATE INDEX index1 ON table1（col3， col2，col1）
A、A.COL1 will accept NULL values and can be referenced in another table's foreign key specification. B、B.COL1 will not accept NULL values and cannot be referenced in another tables foreign key specification. C、C.COL1 will not accept NULL values and can be referenced in another tables foreign key specification. D、D.COL1 will accept NULL values and cannot be referenced in another tables foreign key specification.
A、When view V1 is created B、Each time the REFRESH VIEW v1 statement is executed C、Each time an SQL statement is executed against view V1 D、Only the first time an SQL statement is executed against view V1
客服
TOP
查看正确答案
