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

Why does performance degrade when many UPDATE, INSERT, or DELETE statements are issued on a tablethat has an associated Bitmap index()

AThe DML operations re-create the Bitmap index blocks.

BThe Bitmap index is rebuilt automatically after a DML operation.

CThe smallest amount of a bitmap that can be locked is a bitmap segment.

DAdditional time is taken to remove NULL values from the Bitmap index after a DML operation.

正确答案

来源:www.examk.com

答案解析

相似试题

  • (多选题)

    Why would you run the delete obsolete command?()  

    答案解析

  • (单选题)

    Why would you execute the report obsolete command?()  

    答案解析

  • (单选题)

    Why should you back up a duplicated tablespace after a TSPITR is complete?()  

    答案解析

  • (单选题)

    Why would you use WebLogic Diagnostics Framework (WLDF) instead of Oracle Enterprise Manager (OEM) ()

    答案解析

  • (单选题)

    Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance?()

    答案解析

  • (单选题)

    When scaling Coherence from one to two cache servers, it will not show the same scalability as two to four. Why?()

    答案解析

  • (多选题)

    Identify three reasons that explain why assigning more than one managed serve achieve better  performance than running one managed server with more resources?()

    答案解析

  • (单选题)

    You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these are valid reasons why that might occur?()  

    答案解析

  • (多选题)

    A common approach to solve application performance issues is to add more hardware. Which two  reasons describe why this alone does not always solve performance problems?()

    答案解析

快考试在线搜题