Oracle
1Z0-882 · Question #57
1Z0-882 Question #57: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #57. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.