首页计算机考试Oracle认证
(多选题)

While deploying a new application module,the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced.  Which two statements describe the consequences?()

A The plan baselines can be evolved over time to produce better performance.

B The newly generated plans are directly placed into the SQL plan baseline without being verified.

C The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.

D The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.

正确答案

来源:www.examk.com

答案解析

相似试题

  • (多选题)

    A developer is creating a class Book, that needs to access class Paper. The Paper class is deployed in a JAR named myLib.jar.  Which three, taken independently, will allow the developer to use the Paper class while compiling the Bookclass?()

    答案解析

  • (单选题)

    Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client  while connecting to the database instance from a remote machine()

    答案解析

  • (多选题)

    A user receives the following error while executing a query: ORA/x7f01555:snapshot too old Which two options can be the solutions to avoid such errors in future?()

    答案解析

  • (单选题)

    You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database.  What additional information is available to you when you enable tracing?()

    答案解析

  • (单选题)

    You work as a database administrator for Certkiller .com. You received the following error while working on your database: ORA-01555: snapshot too old  In which situation would you receive such an error?()

    答案解析

  • (多选题)

    While creating a scheduler window using the DBMS_SCHEDULER package, a user logged in as DBMGR gets the error message insufficient privileges.  Which two commands would you use to resolve this error?()

    答案解析

  • (多选题)

    While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences?()

    答案解析

  • (单选题)

    You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. While studying the parameter file of the ASM instance, you find the following entry:  ASM_DISKSTRING = /devices/*  What could be the reason for this setting?()

    答案解析

  • (单选题)

    You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. While studying the parameter file of the ASM instance, you find the following entry:  ASM_DISKSTRING = /devices/*  What could be the reason for this setting?()

    答案解析

快考试在线搜题