單項(xiàng)選擇題

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

你可能感興趣的試題

單項(xiàng)選擇題

How should the following UDF be invoked in order to convert US currency values stored in the EXPENSES table into Canadian currency?CREATE FUNCTION getratews11 ( country1 VARCHAR(100), country2 VARCHAR(100) ) RETURNS DOUBLE LANGUAGE SQL CONTAINS SQL EXTERNAL ACTION NOT DETERMINISTIC BEGIN ... END（）

A.CALL getratews11('USA','CANADA')
B.CALL expenses.getratews11('USA','CANADA')
C.SELECT getratews11('USA','CANADA') FROM expenses
D.SELECT * FROM TABLE(getratews11('USA','CANADA')) AS convert_currency

單項(xiàng)選擇題

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

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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

你可能感興趣的試題

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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