单选题

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

    多选题查看答案