Given the following two tables: TAB1 C1 C2 A 11 B 12 C 13 TAB2 CX CY A 21 C 22 D 23 The following results are desired: C1 C2 CX CY A 11 A 21 C 13 C 22 -- --D 23 Which of the following queries will yield the desired results?（）A、SELECT * FROM tab1 INNER JO

题目

Given the following two tables: TAB1 C1 C2 A 11 B 12 C 13 TAB2 CX CY A 21 C 22 D 23 The following results are desired: C1 C2 CX CY A 11 A 21 C 13 C 22 -- --D 23 Which of the following queries will yield the desired results?（）

A、SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx
B、SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx
C、SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cx
D、SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

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

参考答案：D

第2题：

The datum from which the predicted heights of tides are reckoned in the tide tables is ______.

A.mean low water

B.the same as that used for the charts of the locality

C.the highest possible level

D.given in table three of the tide tables

正确答案：B

第3题：

What is true about joining tables through an equijoin? ()

A. You can join a maximum of two tables through an equijoin.

B. You can join a maximum of two columns through an equijoin.

C. You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.

D. To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.

E. You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.

参考答案：E

第4题：

Which of the following RAID levels would be appropriate given two drives and a need for fault tolerance？（）

A、RAID 0
B、RAID 1
C、RAID 5
D、RAID 10

正确答案:B

第5题：

What are two reasons to create synonyms?（）

A、You have too many tables.
B、Your tables are too long.
C、Your tables have difficult names.
D、You want to work on your own tables.
E、You want to use another schema's tables.
F、You have too many columns in your tables.

正确答案:B,C

第6题：

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.

参考答案：C

第7题：

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.

正确答案:C

第8题：

Given the following two AS path regular expressions: "65000＋ (65001|65002)" "65000(65001|65002){0,}" Which AS path matches both regular expressions?()

A. 65000 65001 65002

B. 65000 65002

C. 65001 65000

D. 65001 65002

参考答案：B

第9题：

Given that Thing is a class， how many objects and reference variables are created by the following code？（） Thing item， stuff； item = new Thing（）； Thing entity = new Thing（）；

A、One object is created
B、Two objects are created
C、Three objects are created
D、One reference variable is created
E、Two reference variables are created
F、Three reference variables are created.

正确答案:B,F

第10题：

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

正确答案:D

Given the following two tables:

题目

相似问题和答案

更多相关问题

相关内容