单选题

You 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 you accept the profile.  Which statement is true when you accept the suggested SQL profile?()  

A The tuned plan is not added to the SQL plan baseline.

B The tuned plan is added to the fixed SQL plan baseline as a fixed plan.

C The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.

D The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

正确答案

来源:www.examk.com

答案解析

相似试题
  • You want to configure and schedule offline database backups to run automatically.  Which tool or utilitywould you use to achieve this()

    单选题查看答案

  • You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space.  You can use Segment Advisor to ()

    单选题查看答案

  • Click the Exhibit button and examine the diagram.  You are running a database that takes advantage of features provided by Connection Manager, heterogeneous services, and external procedures. The diagram depicts the components used for the naming method you just configured. Which naming method are you using?()

    单选题查看答案

  • You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario()

    多选题查看答案

  • You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario()

    多选题查看答案

  • You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically.  Which tool or utility would you use to achieve this? ()

    单选题查看答案

  • Your database runs in ARCHIVELOG mode, and is backed up every Sunday night using RMAN scripts. On Friday your database crashes. Now you want to use the backups from last Sunday night to restore your database.  How can you do this?()

    单选题查看答案

  • You want to configure and schedule offline database backups to run automatically.  Which tool or utility wouldyou use to achieve this()

    单选题查看答案

  • You want to convert your existing non-ASM files to ASM files for the database PROD.  Which method or command would you use to accomplish this task?()  

    单选题查看答案

  • You have a production instance running on your server. UNDO_RETENTION is not long enough to satisfy read-consistency requirements. How do you change the UNDO_RETENTION value?()

    单选题查看答案