READ Free Dumps For Oracle- 1z0-020
| Question ID 7792 | When using the TABLESPACE_MIGRATE_TO_LOCAL procedure to convert a tablespace format dictionary managed format to a locally managed format, you can optionally provide a file ID number. What does the file ID number specify? |
| Option A | The data file where the initial bitmap blocks will be placed. |
| Option B | A new data file in which the entire tablespace will be created. |
| Option C | The data file where the complete bit map is temporarily created |
| Option D | The data file poiled by the migrate procedure to determine the smallest extent to be supported. |
| Correct Answer | A |
| Question ID 7793 | What does the DBMS_OLAP.VALIDATE_DIMENSION procedure do? |
| Option A | Verifies that the table referenced in the dimension exits. |
| Option B | Verifies that the columns in the dimension exist in the summary. |
| Option C | . Verifies that the columns in the dimension exist in the materialized view. |
| Option D | Verifies that the columns in a dimension satisfy the one-to-many relationship in the hierarchy. |
| Correct Answer | D |