In which two cases would you use the USING clause? (Choose two) Select one or more: a. The tables to be joined have multiple NULL columns. b. You want to create a nonequijoin. c. The tables to be joined have columns of the same name and different data types. d. The tables to be joined have columns with the same name and compatible data types. Question 2 Not yet answered Marked out of 1.00 Not flaggedFlag question Question text In which cases would you use an outer join?
Answers
Answer:
(c) The tables to be joined have columns of the same name and different data types.
(d) The tables to be joined have columns with the same name and compatible data types.
Explanation:
Answer:
The correct options for this question are c. The tables to be joined have columns of the same name and different data types and d. The tables to be joined have columns with the same name and compatible data types.
Explanation:
When two tables are connected, the USING clause defines which columns should be tested for equality. In JOIN procedures with an explicit join clause, it can be used instead of an ON clause. The distinction between using clause and on clause is that when combining two or more tables using "using clause," the column names of both tables must be the same regardless of which table is being joined, however column names in "on clause" may differ.
Answer for question 2) which cases would you use an outer join?
We use for below 2 cases:
- Null values exist in the columns that are being combined
- The data in the tables being connected is both matched and mismatched
As a result, an outside join is utilized to return all entries with values in either the left or right table.