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?（） -题库考试答案搜索网

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?（）

单选题

2022-01-03 00:31

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)

查看答案

正确答案

试题解析

标签： IBM(000-730)

感兴趣题目

HTML代码表示（）。

HTML代码表示（）

A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）

An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement:
CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT)
Which of the following SQL statements will provide the table definition that meets the specified requirements?（）

Given that t1 is a reference to a live thread, which is true?（）

“Full speed ahead” and “Full speed astern” are（）given by the officers or the pilots.

冷热流体进出换热器的温度t1、t2、T1、T2表示，则最大温差为T1－t2。

日负荷曲线、横坐标、纵坐标轴t1和t2所围成的面积，表示从t1到t2时刻的（）。

T2 WI反应病变敏感，T1 WI反映组织结构清楚。

并发执行的三个事务T1 、T2 和T3，事务T1 对数据 D1 加了共享锁，事务T2、 T3分别对数据 D2 、D3 加了排它锁，之后事务T1 对数据（）;事务T2对数据（）。

若事务T1对数据 D1 加了共享锁，事务 T2 、T3分别对数据D2 、D3 加了排它锁，则事务T1对数据（）;事务T2对数据（）。

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