READ Free Dumps For Oracle- 1z0-020
Question ID 7760 | What is found in the destination provided by the STANDBY_ARCHIVE_DEST parameter? |
Option A | Archive logs generated by the standby database. |
Option B | Archive logs copied by the DBA from the primary site. |
Option C | Archive logs copied automatically from the primary site. |
Option D | Default destination for archiving in the event a current archive destination becomes unavailable. |
Correct Answer | C |
Question ID 7761 | You want to rebuild the EMP_INDX index and collect statistics. Which command would you use? |
Option A | ALTER INDEX emp_indx REBUILD COMPUTE STATISTICS; |
Option B | ALTER INDEX emp_indx REBUILD COLLECT STATISTICS; |
Option C | ALTER INDEX emp_indx REBUILD ESTIMATE STATISTICS; |
Option D | ALTER INDEX emp_indx REBUILD; ANALYZE TABLE emp COLLECT STATISTICS; |
Correct Answer | A |