ITPub博客

408.Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?A. SQL Access Advisor recommendations are automatically implemented.B. Individual SQL Access Advisor recommendations can be scheduled for implementation.C. All SQL Access Advisor recommendation...

406.Which of these appropriately describes the results of a manual SQL Tuning Advisor task?A. A list of SQL statements and recommendations for tuningB. A list of SQL statements that have been tuned by the Advisor, with before and after metricsC. Graphs showing the actual performance improvement m...

405.To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?A. From the Advisor Central home page, select the tuning task from the Advisor Tasks section.B. From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.C. From Advisor C...

404.When creating a SQL tuning set, which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values?A. Filter versionsB. Filter loadsC. Filter tasksD. Filter optionsAnswer: D参考：http://docs.oracle.com/cd/E11882_01/server.112/e10822/td...

401.Which of the following are correct about TbMlock media recovery? (Choose all that apply.)A. Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_CORRUPTION.B. Logical corruptions are repairable by BMR.C. Physical corruptions are repairable by BMR.D. RMAN can us...

399.Which of the following is not an advantage of block media recovery (BMR)?A. Reduced MTTR.B. Datafiles remain offline while corrupt blocks are repaired.C. Datafiles remain online while corrupt blocks are repaired.D. A and CAnswer: B下列哪项不是块介质恢复（BMR）的优势？B、数据文件仍处于脱...

398.Choose the correct order to package and upload data for an incident to Oracle Support.A. Schedule, create new package, view manifest, view contentsB. Create new package, view manifest, view contents, scheduleC. Schedule, create new package, view contents, view manifestD. Create new package, ...

397.Which of the following tasks does the tool Incident Packaging Service (IPS) perform?A. Cleans up the ADR by deleting files not associated with an incident uploaded to Oracle Support.B. Identifies all files associated with a critical error and adds them to a zip file to be sent to Oracle Suppor...

396.Which of the following are not fundamental tasks of the Support Workbench? (Choose all that apply.)A. View long-running SQL workloadsB. View problem detailsC. Gather additional diagnostic informationD. Create a Service RequestE. Clean up incident data after upload to Oracle SupportAnswer: ...

394.Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST?A. The default value is the value of the environment variable $ORACLE_HOME; if $ORACLE_HOME isn't set, then the default is set to $ORACLE_BASE.B. The default value is the value of the environment v...

393.Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository? (Choose all that apply.)A. BACKGROUND_DUMP_DESTB. FOREGROUND_DUMP_DESTC. CORE_DUMP_DESTD. USER_DUMP_DESTE. DIAGNOSTIC_DESTF. All of the abov...

389.The _______ writes the Flashback Database logs in the flash recovery area.A. FLSHB. FLDBC. RVWRD. RVRWE. FBDAAnswer: C哪一个进程将闪回数据库日志写入闪回恢复区。

386.You have just performed a FLASHBACK TABLE operation using the following command:flashback table employees to scn 123456;The employees table has triggers associated with it. Which of the following statements is true regarding the state of the triggers during the Flashback Table operation?A. Al...

383.At the request of a user, you issue the following command to restore a dropped table: flashback table "BIN$F2JFfMq8Q5unbC0ceE9eJg==$0" to before drop;Later, the user notifies you that the data in the table seems to be very old and out of date. What might be the problem?A. Because a proper ran...

379.Users notify you that their application is failing every time they try to add new records. Because of poor application design, the actual ORA error message is unavailable. What might be the problem?(Choose the best answers.)A. The application user has exceeded their undo quota.B. The FLASHBACK...

378.In order to perform Flashback Transaction Query operations, which of these steps are required?(Choose all that apply.)A. Ensure that database is running with version 10.1 compatibility.B. Enable Flashback Logging.C. Enable Supplemental Logging.D. Ensure that the database is running with vers...

377.AUM has been retaining about 15 minutes worth of undo. You want to double the retention period, but not at the expense of new transactions failing. You decide to alter the system to set the parameter UNDO_RETENTION=18000. However, AUM still retains only about 15 minutes worth of undo. What is th...

373.Which of the following Oracle features utilize the undo tablespace? (Choose all that apply)A. Flashback QueryB. Flashback DropC. Flashback TableD. Flashback DatabaseE. Transaction ProcessingF. Recycle BinAnswer: ACE以下哪些Oracle特性是使用了撤消表空间？闪回查询，闪回表，事务处理。...

370.Why should you back up a duplicated tablespace after a TSPITR is complete?A. The tablespace cannot be duplicated or restored to any point in time after the duplication.B. The tablespace cannot be duplicated or restored to the point in time before the duplication.C. The entire database cannot ...

366.If you are going to run a TSPITR recovery, which view will help you to determine which objects will be lost during the TSPITR?A. TS_OBJECTS_TO_BE_DROPPEDB. TS_PTTR_OBJECT_DROPPEDC. TS_PITR_OBJECTS_TO_BE_DROPPEDD. TS_OBJECTS_DROPPEDE. TS_DROPPED_OBJECTSAnswer: C如果你要运行表空间时间点恢...