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.
正确答案
答案解析
相似试题
(多选题)
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?()