READ Free Dumps For Oracle- 1z0-020
| Question ID 8227 | 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 8228 | 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 |