INSERT INTO tab1 SELECT cx, cy FROM tab2
INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)
INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)
INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)
第1题:
A.SELECT * FROM t1 UNION SELECT * FROM t2
B.SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2
C.SELECT * FROM t1 INTERSECT SELECT * FROM t2
D.SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
第2题:
Given the following tables: CONTINENTS ID NAME COUNTRIES1 Antarctica 02 Africa 533 Asia 474 Australia 145 Europe 436 North America 237 South America 12REGION ID LOCATION 1 East 2 WestHow many rows would be returned using the following statement? SELECT location FROM continents, region()
A.2
B.7
C.9
D.14
第3题:
以下程序运行后的输出结果是______。 main() { char c1,c2; for(c1='0',c2='9';c1<c2;c1++,c2--) printf("%c%c",c1,c2); printf("\n"); }
A.918245765
B.893478654
C.786584763
D.918273645
第4题:
有以下程序 #include
第5题:
有以下程序:#include <stdio, h>main( ) { char c1='1',c2='2'; c1=getchar();c2=getchar();putchar(c1);putchar(c2); } 当运行时输入:a<回车>后,以下叙述正确的是( )。
A.变量c1被赋予字符a,c2被赋予回车符
B.程序将等待用户输入第二个字符
C.变量c1被赋予字符a,c2中仍是原有字符2
D.变量c1被赋予字符a,c2中将无确定值
第6题:
Given the following statements:CREATE TABLE tab1 (col1 INT); CREATE TABLE tab2 (col1 INT); CREATE TRIGGER trig1 AFTER UPDATE ON tab1 REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3);What is the result of the following query? SELECT count(*) FROM tab2;()
A.3
B.2
C.1
D.0
第7题:
有以下程序#include<stdio. h>main(){ char c1='1',c2='2'; c1=getchar(); c2=getchar(); putchar(c1); putchar(c2);} 当运行时输入:a<回车> 后,以下叙述正确的是
A.变量c1被赋予字符a,c2被赋予回车符
B.程序将等待用户输入第2个字符
C.变量c1被赋予字符a,c2中仍是原有字符2
D.变量c1被赋予字符a,c2中将无确定值
第8题:
有以下程序: # include<stdio.h> main() {char c1='1',c2='2'; c1=getchar();c2=getchar();putchar(c1);putchar (c2); } 当运行时输入:a<回车>后,以下叙述正确的是 ______。
A.变量c1被赋予字符a,c2被赋予回车符
B.程序将等待用户输入2个字符
C.变量c1被赋予字符a,c2中仍是原有字符2
D.变量c1被赋予字符a,c2中将无确定值
第9题:
电容器C1、C2并联后,其总电容为()
第10题:
Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1 and C2 together, which statement(s) will create index(es) that will provide optimal query performance? ()