单选题

While running long running queries, you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error?()

A Memory Advisor

B Segment Advisor

C Undo Advisor

D SQL Tuning Advisor

正确答案

来源:www.examk.com

答案解析

相似试题
  • Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database?()

    多选题查看答案

  • While running the Oracle Universal Installer on a Unix platform to install Oracle Database 10g software, you are prompted to run orainstRoot.sh script. What does this script accomplish?()

    单选题查看答案

  • While creating a job class using the DBMS_SCHEDULER package, you set the logging level to LOGGING_RUNS. What would be the impact of this setting?()

    单选题查看答案

  • Which options would you consider while configuring a flash recovery area fast recovery area in 11g Release 2 for your production database that is running in ARCHIVELOG mode?() 

    多选题查看答案

  • Which statement is true while creating subplans using Resource Manager?()

    单选题查看答案

  • Which three pieces of information are considered while deciding the size of the undo tablespace in your database?()

    多选题查看答案

  • You want to create a temporary table while executing a procedure in a form. Which statement is true?()

    单选题查看答案

  • Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?()

    多选题查看答案

  • Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?()  

    单选题查看答案