READ Free Dumps For Oracle- 1z0-007
Question ID 1690 | What does the FORCE option for creating a view do? |
Option A | A. creates a view with constraints |
Option B | B. creates a view in another schema even if you don't have privileges |
Option C | C. creates a view even if the underlying parent table has constraints |
Option D | D. creates a view regardless of whether or not the base tables exist |
Correct Answer | D |
Question ID 1691 | The CUSTOMERS table has these columns: |
Option A | A. WHERE lower(country_address) = 'france' |
Option B | B. WHERE lower(country_address) = "france" |
Option C | C. WHERE lower(country_address) LIKE %france% |
Option D | D. WHERE lower(country_address) = '%france%' |
Option E | E. WHERE lower(country_address) IS 'france' |
Correct Answer | A |