Why does performance degrade when many UPDATE, INSERT, or DE

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

The DML operations re-create the Bitmap index blocks.

B

The Bitmap index is rebuilt automatically after a DML operation.

C

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

D

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

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

在SQL中,对基本表进行插入和修改记录的命令为( )。

A、insert和delete

B、update和delete

C、delete和select

D、insert和update


参考答案:D

第2题:

SQL Server2005触发器主要针对下列语句创建()。

A.SELECT、INSERT、DELETE

B.INSERT、UPDATE、DELETE

C.SELECT、UPDATE、INSERT

D.INSERT、UPDATE、CREATE


本题答案:B

第3题:

用来插入数据的命令是( ),用于更新的命令是( )

A.INSERT,UPDATE

B.CREATE,INSERT INTO

C.DELETE,UPDATE

D.UPDATE,INSERT


正确答案:A 

第4题:

SQL Server触发器主要针对下列语句创建()。

  • A、SELECT、INSERT、DELETE
  • B、INSERT、UPDATE、DELETE
  • C、SELECT、UPDATE、INSERT
  • D、INSERT、UPDATE、CREATE

正确答案:B

第5题:

— Why does he look sad?—There are so many problems()

Aremaining to settle

Bremained settling

Cremaining to be settled

Dremained to besettled


C

第6题:

-Why does he look so anxious -Because there are so many problems().

A、remaining to settle

B、remained settling

C、remaining to be settled

D、remained to be settled


参考答案:C

第7题:

When I try to understand( )that prevents so many Americans from being as happy as one might expect,it seems to me that there are two causes.

A.why it does
B.what it does
C.what it is
D.why it is

答案:C
解析:
该题考查句子结构。根据题干,“that...might expect”在句中做understand的宾语。宾语从句可由连接词that引导,that仅起连接作用,常可省略。若连接词在句中兼起一个句子成分的作用,则应使用what,how,when,why,who,which,where等连词,但要用陈述语气,根据句意答案为C,连接词在句中做表语。

第8题:

Do you know ()?

A.when does the meeting start

B.why the party starts

C.what time the party starts

D.if the party endts


参考答案:C

第9题:

用来插入数据、更新的命令分别是()。

  • A、DELETE,UPDATE
  • B、INSERT,UPDATE
  • C、CREATE,INSERT INTO
  • D、UPDATE,INSERT

正确答案:B

第10题:

SQL Server2005触发器主要针对下列语句创建()。

  • A、SELECT、INSERT、DELETE
  • B、INSERT、UPDATE、DELETE
  • C、SELECT、UPDATE、INSERT
  • D、INSERT、UPDATE、CREATE

正确答案:B

更多相关问题