IBM(000-730)

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

题目
单选题
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

如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Given that tables T1 and T2 contain the following rows:Table T1: C1 C2 1 4 1 3 1 2Table T2: C1 C2 1 1 1 2 1 3Which of the following queries will return only those rows that exist in both T1 and T2?()

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)


参考答案：C

第2题：

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


参考答案：D

第3题：

Note the following statements that use flashback technology:1. FLASHBACK TABLE <table> TO SCN <scn>;2. SELECT * FROM <table> AS OF SCN 123456;3. FLASHBACK TABLE <table> TO BEFORE DROP;4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;Which of these statements will be dependent on the availability of relevant undo data in the undo segment?（）

A. 1, 2, and 5

B. 1, 3, and 4

C. 2, 3, 4, and 5

D. 1, 2, 3, 4, and 5


参考答案：A

第4题：

臂丛神经的组成是（）

  • A、C1~5脊神经
  • B、C5～T1脊神经
  • C、C5～T1脊神经前根
  • D、C4～T2脊神经前根

正确答案:C

第5题：

Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 1 4 1 3 1 2 Table T2: C1 C2 1 1 1 2 1 3 Which of the following queries will return only those rows that exist in both T1 and T2?（）

  • 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)

正确答案:C

第6题：

Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?()

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


参考答案：C

第7题：

Given that tables T1 and T2 contain the following rows: Table T1:C1 C25 4 5 2 5 5Table T2: C1 C2 5 1 5 2 5 3Which 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


参考答案：B

第8题：

Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?()

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)


参考答案：B

第9题：

已知表T1中有2行数据，T2中有3行数据，执行SQL语句“select a.* from T1 a，T2 b”后，返回的行数为（）

  • A、2
  • B、3
  • C、5
  • D、6

正确答案:C

第10题：

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

正确答案:B

更多相关问题
相关内容