READ Free Dumps For Oracle- 1z0-020
Question ID 7768 | 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 | AD |
Question ID 7769 | 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 |