问题

Given the following two tables: TAB1

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

ASELECT * FROM tab1 INNER JOIN tab2 ON c1=cx
BSELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx
CSELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cx
DSELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx

参考答案

参考解析：

分类：IBM(000-730)题库

相关推荐

1、The table is（）for two people

The table is（）for two peopleAnot big enoughBbig not enoughCbig enough not

2、Given the following

Given the following output what course of action should be undertaken for a long ...

3、Given the following requirements: Cre

Given the following requirements:Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is ...

4、Given the following table definitions

Given the following table definitions:EMPLOYEEID NAME DEPTID01Smith 1002Bossy 2003 20Peterson04Goss 3005Pape 4006Avery 5007O'Neal 6008Carter 50DEPA...

5、Given the following

Given the following six method names：（1）addListener（2）addMouseListener （3）setMouseListener（4）deleteMouseListener（5）rem...

6、Given the following two tables: TAB1

Given the following two tables:TAB1 C1 C21 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY5 Europe 6 North America 7 South AmericaWhich of...

编辑推荐

鼻声反射（）。..

数字通信中的消息是用以携载信息的有次序的符号序列，或者携.....

若采用成本法估价，下列表述中不正确的是（）。..

对于鼓风机来说，下列说法哪个是错误的（）。..

座板式单人吊具的每个挂点装置供（）人使用。..

下列不属于医学道德具体原则的是（）。..