In what type of SQL operation must two tables have the same field structure?
A)union
B)join
C)concatenation
D)extract

Question

Quizplus · Accepted Answer

In a UNION operation, the two tables involved must have the same number of columns and corresponding data types in order to be combined into a single result set. This operation stacks rows from both tables on top of each other, requiring identical field structures for compatibility.

In What Type of SQL Operation Must Two Tables Have