READ Free Dumps For Oracle- 1z0-020
| Question ID 8235 | Which two statements are true for an online index rebuild? (Choose two) |
| Option A | No table locking is required. |
| Option B | The operation can be done in parallel. |
| Option C | Queries on the base table will result in errors. |
| Option D | Changes to the base table are logged in a journal table. |
| Correct Answer | A,D |
| Question ID 8236 | Following an upgrade from Oracle8, release 8.0, to Oracle8i, release 1 or 2, you should run the script utlrp.sql to accomplish which goal? |
| Option A | Create a set of compatible data dictionary tables. |
| Option B | Recompile any PL/SQL modules made invalid by the upgrade. |
| Option C | To remove the release upgrade program modules from the SYSTEM tablespace. |
| Option D | Replace statistics tables created with the DBMS_STATS with current versions. |
| Correct Answer | B |