单选题

As a result of performance analysis, you created an index on the prod_name column of the prod_det table, which contains about ten thousand rows. Later, you updated a product name in the table. How does this change affect the index?()

AA leaf will be marked as invalid.

BAn update in a leaf row takes place.

CThe index will be updated automatically at commit.

DA leaf row in the index will be deleted and inserted.

EThe index becomes invalid when you make any updates.

正确答案

来源:www.examk.com

答案解析

相似试题
  • A bitmap join index is defined as().

    单选题查看答案

  • A schedule defined entirely within the confines of a Scheduler job object is known as a (n) ()

    单选题查看答案

  • As A DBA, which of the following methods can you use to make a backup of your table?()

    单选题查看答案

  • Which background process of a database instance,using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?()

    单选题查看答案

  • Which client requests to the database can be captured as a part of the workload capture?() 

    多选题查看答案

  • You specified extent management as local for a tablespace. How will it affect space management in the tablespace?()

    单选题查看答案

  • By default, checkpoints happen at least as often as().

    单选题查看答案

  • You want to create a template to be used as a standard for all company reports. What is the easiest way to do this?()

    单选题查看答案

  • You specified segment space management as automatic for a tablespace. What effect would this have on space management?()

    单选题查看答案

  • Oracle Coherence is best classified as ()? 

    单选题查看答案