174.Which two statements are true regarding B-tree index? (Choose two.)
A.The leaf blocks in the index are doubly linked.
B.The leaf node stores a bitmap for each key value.
C.The rows with NULL value in key columns also have entries in the index.
D.The deletion of a row from the table causes a logical deletion in index leaf block and the space becomes available for the new leaf entry.
答案：AD
解析：
参考：171题
A:正确
B:与位图索引没关系
C:b-tree不存储null
D:正确
A.The leaf blocks in the index are doubly linked.
B.The leaf node stores a bitmap for each key value.
C.The rows with NULL value in key columns also have entries in the index.
D.The deletion of a row from the table causes a logical deletion in index leaf block and the space becomes available for the new leaf entry.
答案：AD
解析：
参考：171题
A:正确
B:与位图索引没关系
C:b-tree不存储null
D:正确
4325
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
