試卷名稱:110年 - 110 國立中山大學_碩士暨碩士專班招生考試_資管系/甲、乙組:計算機概論#105543
年份:110年
科目:研究所、轉學考(插大)、學士後-計算機概論
37. Consider the following tables, A and B, in a relational database:
Which of the following SQL statement can be used to concatenate A and B?
(A) SELECT * FROM A UNION ALL SELECT * FROM B
(B) SELECT * FROM A FULL OUTER JOIN B ON A.id = B.id
(C) SELECT * FROM A INNER JOIN B ON A.id = B.id
(D)SELECT * FROM A LEFT JOIN B ON A.id = B.id