试题详情
- 单项选择题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?()
A、A leaf will be marked as invalid.
B、An update in a leaf row takes place.
C、The index will be updated automatically at commit.
D、A leaf row in the index will be deleted and inserted.
E、The index becomes invalid when you make any updates.
- D
关注下方微信公众号,在线模考后查看
热门试题
- Oracle允许数据库中有比操作系统规定
- You work
- Giventhatthecurrentd
- Click the Exhibit bu
- MySQLisinstalledonaL
- The Automatic&
- 写出索引的作用与建立索引时应注意的问题。
- You decided&en
- Your database&
- Which statemen
- You set t
- Which syntax turns a
- Your database instan
- Which two statements
- User SCOTT&ens
- Given: Whichtwostat
- Which object privile
- What will&ensp
- While performi
- Which script