A、A inner join B
B、A left join B
C、A right join B
D、Across join B
更多“对于表A（col1 int，col2 char（1）），表B（col1 int，col2char（1）），为确保表A的数据全部被保留，下面正确的联接方式是（）”相关的问题
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、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
查看正确答案
