READ Free Dumps For Oracle- 1z0-007
| Question ID 8003 | What does the FORCE option for creating a view do? |
| Option A | creates a view with constraints |
| Option B | creates a view even if the underlying parent table has constraints |
| Option C | creates a view in another schema even if you don't have privileges |
| Option D | creates a view regardless of whether or not the base tables exist |
| Correct Answer | D |
| Question ID 8004 | A data manipulation language statement _____. |
| Option A | completes a transaction on a table |
| Option B | modifies the structure and data in a table |
| Option C | modifies the data but not the structure of a table |
| Option D | modifies the structure but not the data of a table |
| Correct Answer | C |