READ Free Dumps For Oracle- 1z0-020
| Question ID 8251 | What happens during query rewrites of materialized views? |
| Option A | The user rewrites the SELECT statement without the GROUP BY clause. |
| Option B | The user rewrites the SELECT statement to use the table instead of the materialized view. |
| Option C | The optimizer the SELECT statement to use the table instead of the materialized view. |
| Option D | The optimizer rewrites the SELECT statement to use the materialized view instead of the table. |
| Correct Answer | D |
| Question ID 8252 | Which two initialization parameters are used to create the default value for the SERVICE_NAMES initialization parameter when it is not specified? (Choose two) |
| Option A | DB_NAMES |
| Option B | DB_FILE_NAME_CONVERT |
| Option C | DB_DOMAIN |
| Option D | MTS_SERVICE |
| Option E | INSTANCE_NAME |
| Correct Answer | A,C |