Oracle
1Z0-882 · Question #103
1Z0-882 Question #103: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #103. The question stem and answer options stay visible for context.
Question
You want to compare all columns of table A to columns with matching names in table B. You want to select the rows where those have the same values on both tables. Which query accomplishes this?
Options
- ASELECT * FROM tableA. tableB
- BSELECT * FROM tableA JOIN tableB
- CSELECT * FROM table A INNER JOIN tableB
- DSELECT * FROM tableA NATURAL JOIN tableB
- ESELECT & FROM tableA STRAIGHT JOIN tableB
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.