tailieunhanh - OCA: Oracle Database 11g Administrator Certified Associate- P23

Tham khảo tài liệu 'oca: oracle database 11g administrator certified associate- p23', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Review Questions 931 12. To recover a data file from the SYSTEM or UNDO tablespace the instance must be in which database state A. NOMOUNT B. OPEN C. ABORT D. MOUNT 13. The STATUS column of the dynamic performance view V LOGFILE contains what value if one of the redo log file group members has been lost because of a media failure A. INVALID B. STALE C. DELETED D. The column contains a NULL value. 14. Place the following events or actions leading up to and during instance recovery in the correct order. 1. The database is opened and available. 2. Oracle uses undo segments in the undo tablespace to roll back uncommitted transactions. 3. The DBA issues the STARTUP command at the SQL Plus prompt. 4. Oracle applies the information in the online redo log files to the data files. A. 4 3 2 1 B. 3 4 1 2 C. 2 1 3 4 D. 2 1 4 3 E. 3 2 4 1 F. 3 4 2 1 15. You noticed that when your instance crashes it takes a long time to start up the database. Which advisor can be used to tune this situation A. The Undo Advisor B. The SQL Tuning Advisor C. The Database Tuning Advisor D. The MTTR Advisor E. The Instance Tuning Advisor 16. If a data file is missing when the instance is started where is the error message recorded A. Only in the alert log. B. All missing files are returned directly to the administrator in the SQL Plus session. C. The first missing file is returned directly to the administrator in the SQL Plus session and the rest of the missing files are identified in V RECOVER_FILE. D. Only in the alert log and in the DBWR background-process trace files. 932 Chapter 16 Recovering the Database 17. In ARCHIVELOG mode the loss of a data file for any tablespace other than the SYSTEM or UNDO tablespace affects which objects in the database A. The loss affects only objects whose extents reside in the lost data file. B. The loss affects only the objects in the affected tablespace and work can continue in other tablespaces. C. The loss will not abort the instance but will prevent other .