Oracle
1Z0-882 · Question #57
You attempt to create a temporary table by using the following statement: CREATE TEMPORARY TABLE employeesMAIN SELECT FROM employees1 UNION ALL SELECT FROM employees2; What is the result?
The correct answer is D. All rows from both tables exist in employeesMAIN. See the full explanation below for the reasoning.
Question
You attempt to create a temporary table by using the following statement:
CREATE TEMPORARY TABLE employeesMAIN SELECT * FROM employees1 UNION ALL SELECT * FROM employees2; What is the result?
Options
- AAn error is produced because you cannot create a TEMPORARY TABLE with a UNION.
- BThe employees common to both tables exist in employees MAIN.
- CA unique list of employees exist in employeesMAIN.
- DAll rows from both tables exist in employeesMAIN.
How the community answered
(34 responses)- A12% (4)
- B3% (1)
- C3% (1)
- D82% (28)
Community Discussion
No community discussion yet for this question.