READ Free Dumps For Oracle- 1z0-061
| Question ID 21010 | View the Exhibit and examine the structure of the customers table.
Using the customers table, you need to generate a report that shows the average credit limit for customers in Washington and NEW YORK. Which SQL statement would produce the required result?
|
| Option A | Option A |
| Option B | Option B |
| Option C | Option C |
| Option D | Option D |
| Correct Answer | C |
| Question ID 21011 | View the Exhibit and examine the data in the employees table:
Which join option can be used in the blank in the above query to get the required output? |
| Option A | INNER JOIN |
| Option B | FULL OUTER JOIN |
| Option C | LEFT OUTER JOIN |
| Option D | RIGHT OUTER JOIN |
| Correct Answer | C |
