单选题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 T2B SELEC

在下列查询语句中，与SELECT TABl*FROM，TABl WHERE InStr([简历]，”篮球”)<>o功能相同的语句是（ ）。

A.SELECT TABl．*FROM TABl WHERE TABl．简历Like”篮球”

B.SELECT TABl．*FROM TABl WHERE TABl．简历Like”*篮球”

C.SELECT TABl．*FROM TABl WHERE TABl．简历Like”*篮球*”

D.SELECT TABl．*FROM TABl WHERE TABl．简历Like”篮球*”

A.REVOKE DROP ON t1 FROM PUBLIC

B.REVOKE UPDATE ON t1 FROM PUBLIC

C.REVOKE DELETE ON t1 FROM PUBLIC

D.REVOKE CONTROL ON t1 FROM PUBLIC

A. It may advise the use of online table redefinition for tables in dictionary managed tablespace.

B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.

C. It may advise the use of online table redefinition for tables in locally managed tablespaces

D. It will detect and advise about chained rows.

E. It may advise the use of segment shrink for free list managed tables.

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

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)

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

下面不属于同一函数模板的是( )。

A．template＜class t1＞ t1 max(t1 &a,t1 &b) {…}template＜class t2＞ t2 max(t2 &a,t2 &b) {…}

B．template＜class t1＞t1 max(t1 a,t1 b){…}template＜class t2＞t2 max(t2 &a,t2 &b){…}

C．template＜class t1＞ t1 max(t1 * a,t1 * b) {…} template＜class t2＞ t2 max(t2 &a,t2 &b) {…}

D．template＜class t1＞t1 max(t1 a,t1 b){…}template＜class t2＞t2 max(t2 &a,t2 &b,t2 c){…}