多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the year-ending task, SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How does this change to the table affect the index?()

  • A、An update in a leaf row takes place.
  • B、The index becomes invalid after the update.
  • C、The leaf block containing the row to be updated is marked as invalid.
  • D、A row in the leaf block of the index for the key value is deleted and inserted.
正确答案:D
答案解析:
进入题库查看解析

微信扫一扫手机做题