READ Free Dumps For Oracle- 1z0-020
| Question ID 8229 | Which two statements are true when corrupted blocks are skipped? (Choose two) |
| Option A | All rows in a corrupt block are inaccessible. |
| Option B | Referential integrity may be violated. |
| Option C | If the freelist is corrupt the table has to be re-created. |
| Option D | Only the corrupted rows within a block will be inaccessible. |
| Option E | Queries have to be rewritten so they will skip corrupted blocks. |
| Option F | Indexes pointing to corrupt blocks will be marked as invalid. |
| Correct Answer | A,B |
| Question ID 8230 | You want to benefit from a partial partition-wise join for two tables. What is required? |
| Option A | You must define a foreign key constraint. |
| Option B | You need to equipartition both tables on their join keys. |
| Option C | You need to hush-partitioned both tables on their join keys. |
| Option D | You need to partition one of the tables on their join keys. |
| Correct Answer | D |