更多"Given that tables T1 and T2 contain"的相关试题:
[单项选择] Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 5 4 5 2 5 5 Table T2: C1 C2 5 1 5 2 5 3 Which of the following queries will return only those rows that exist in T1 and not in T2?（）
A. SELECT * FROM T1 MINUS SELECT * FROM T2
B. SELECT * FROM T1 EXCEPT SELECT * FROM T2
C. SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1
D. SELECT * FROM T1 NOT EXISTS SELECT * FROM T2
[单项选择]Which of the following would contain information regarding network device alerts using SNMP?（）
A. Syslog
B. Audit log
C. History log
D. Ping sweep reports
[单项选择] Given table T1 has column I1 containing the following data: I1 1 2 3 4 If the following sequence of SQL statements is applied within a single unit of work: UPDATE t1 SET i1 = 3 WHERE i1 = 2; S AVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE t1 SET i1 = 5 WHERE i1 = 3; SAVEPOINT s2 ON ROLLBACK RETAIN CURSORS;INSERT INTO t1 (i1) VALUES (6); ROLLBACK TO SAVEPOINT s1; UPDATE t1 SET i1 = 2 WHERE i1 = 4; COMMIT; What is the expected sequence of values returned from?（） SELECT i1 FROM t1 ORDER BY i1
A. 1, 2, 3, 3
B. 1, 2, 2, 4
C. 1, 2, 3, 3, 6
D. 1, 2, 2, 5, 6
[单项选择]Which of the following does not contain caffeine, according to the passage
A. cola drinks
B. tea
C. chocolate and cocoa
D. water
[单项选择]Seminiferous tubules contain all of the following components EXCEPT
A. Sertoli cells
B. Spermatocytes
C. A fibrous connective tissue tunic
D. Skeletal muscle in their tunica propria
E. A germinal epithelium
[单项选择] Given the following tables: CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West How many rows would be returned using the following statement? SELECT location FROM continents, region（）
A. 2
B. 7
C. 9
D. 14
[单项选择]Which of the following words does NOT contain one morpheme
A. Table.
B. Often.
C. Desirable.
D. Life.
[单项选择]Which of the following do you think would contain the most calories
A. Chips.
B. A chocolate coated ice cream.
C. A green salad.
D. A cucumber.
[单项选择]Which of the following does not contain a non-finite clause
[单项选择]Given that t1 is a reference to a live thread, which is true?（）
A. The Thread.sleep() method can take t1 as an argument.
B. The Object.notify() method can take t1 as an argument.
C. The Thread.yield() method can take t1 as an argument.
D. The Thread.setPriority() method can take t1 as an argument.
E. The Object.notify() method arbitrarily chooses which thread to notify.
[单项选择] Given the following two tables: TAB1 C1 C2 1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY 5 Europe 6 North America 7 South America Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?（）
A. INSERT INTO tab1 SELECT cx, cy FROM tab2
B. INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)
C. INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)
D. INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)
[单项选择] Given the following two tables: TAB1 C1 C2 A 11 B 12 C 13 TAB2 CX CY A 21 C 22 D 23 The following results are desired: C1 C2 CX CY A 11 A 21 C 13 C 22 -- --D 23 Which of the following queries will yield the desired results?（）
A. SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx
B. SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx
C. SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cx
D. SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx
[单项选择] Given the following two tables: TAB1 R1 A A A B B C C D E TAB2 R2 A A B B C C D Which of the following queries returns the following result set? RETVAL E（）
A. SELECT r1 AS retval FROM tab1 INTERSECT SELECT r2 AS retval FROM tab2
B. SELECT r1 AS retval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2
C. SELECT DISTINCT r1 AS retval FROM tab1, tab2 WHERE r1 <> r2
D. SELECT r1 AS retval FROM tab1 UNION SELECT r2 AS retval FROM tab2
[单项选择]
若系统中存在5个等待事务T0，T1，T2，T3，T4，其中：T0正等待被T1锁住的数据项A1，T正等待被T2锁住的数据项A2，T2正等待被T3锁住的数据项A3，T3正等待被T4锁住的数据项A4，T4正等待被T0锁住的数据项A0，则系统处于（）的工作状态。
A. 并发处理
B. 封锁
C. 循环
D. 死锁
[单项选择]Given that t1 is a reference to a live thread， which is true？（）
A. The Thread.sleep（） method can take t1 as an argument.
B. The Object.notify（） method can take t1 as an argument.
C. The Thread.yield（） method can take t1 as an argument.
D. The Thread.setPriority（） method can take t1 as an argument.
E. The Object.notify（） method arbitrarily chooses which thread to notify.
[单项选择]1mol双原子分子气体，当温度由T1升至T2时，假定转动惯量不变，T2=2T1， 系统的转动熵变为（）
A. 5.763J·K-1·mol-1；
B. 11.526J·K-1·mol-1；
C. RlnT1；
D. Rln（I·T1/σ）；
E. 2.882J·K-1·mol-1
[单项选择]若系统中存在一个等待事务集{T0，T1，T2，…，Tn}，其中T0正等待被T1锁住的数据项D1，T1正等待被T2锁住的数据项D2，…，Tn-1正等待被Tn锁住的数据项Dn，Tn正等待被T0锁住的数据项D0，则系统处于（）的工作状态。
A. 封锁
B. 死锁
C. 循环
D. 并发处理
[单项选择]现有 3个同时到达的作业 J1、J2和 J3，它们的执行时间分别是 T1、T2和 T3，且 T1＜T2＜T3。系统按单道方式运行且采用短作业优先算法，则平均周转时间是（ ）。
A. T1+T2+T3
B. (T1+T2+T3)/3
C. (3T1+2T2+T3)/3
D. (T1+2T2+3T3)/3
