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

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

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

单项选择题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 statements eliminates all but one of each set of duplicate rows in the DEPT column in the STAFF table?（）

A.SELECT UNIQUE dept FROM staff
B.SELECT DISTINCT dept FROM staff
C.SELECT (dept) UNIQUE FROM staff
D.SELECT (dept) DISTINCT FROM staff

单项选择题In which of the following situations should correlation names be used?（）

A.A table referenced in the FROM clause has no indexed column.
B.The table referenced in the FROM clause has more than 200 columns.
C.Two or more tables in the FROM clause have identical column names.
D.The FROM clause contains two or more tables in the SELECT statement.