READ Free Dumps For Oracle- 1z0-020
Question ID 7762 | 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 | AB |
Question ID 7763 | 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 |