EVISWANG的博客

QUESTION 118You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk groupDATA. You have RMAN backup of data as well as ASM metadata backup. You want to re-create th

117Posted by seenagape on June 23, 2012 Leave a comment (0) Go to commentsThe BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statementis true while performing a

132Examine the parameter setting in your database: SQL>SHOW PARAMETER TARGETNAME TYPE VALUE----------------------------- -------------- ----------archive_lag_target integer 0db_flashback_r

QUESTION 3While tuning a SQLstatement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?

QUESTION 5You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline.The STA generates a SQL profile for the SQL statement, which recommends建议，推荐 that

QUESTION 14You have a very large table that your users access frequently. Which of the following advisors willrecommend any indexes to improve the performance of queries against this table?A. Th

QUESTION 34Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)A. The user has dropped an important table that needs to be recovered.B. The database fil

188Examine the following scenario:The target database instance is running. The most recent backup available for the target database wastaken two days ago. Log files switches have occurred in las

40For which two situations would you use functionality provided by the Resource Manager? (Choose two.)A. setting idle timeout limits on resource plansB. saving storage space by using compressed

QUESTION 83You enable block change tracking.You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE;The next day, you issue thefollowing command: BACKUP INCREMENTAL LEVEL 1CUMULAT

102For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?(Choose two.)A. viewsB. fixed tablesC. heap tablesD. external tablesE. temporary tables