問題文
A query joins two tables with the NATURAL keyword. Both tables hold a department identifier column and both also hold a column named created by with different data types. What happens when the statement runs?
選択肢
- The statement succeeds and the natural join uses the department identifier because it is the only pair with matching types.
- The statement succeeds and the natural join falls back to a cross product for that pair.
- The statement fails and the natural join uses every column that shares a name across the two tables.
- The statement succeeds and the natural join uses the first column pair that both tables declare.