试题详情
- 单项选择题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
关注下方微信公众号，在线模考后查看
热门试题