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

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)?()  

    答案解析

快考试在线搜题