Oracle Exam 1Z0-497 Topic 4 Question 35 Discussion

Actual exam question for Oracle's 1Z0-497 exam

Question #: 35
Topic #: 4

Which two statements are true about the B-tree Index?

AThe leaf blocks in the index are doubly linked.

BThe leaf node stores a bitmap for each key value.

CRows with a NULL value in key columns also have entries in the Index.

DThe deletion of a row from the table causes a logical deletion in the index leaf block and the space becomes available for a new leaf entry.

Show Suggested Answer

Suggested Answer: A, D

by Wilda at May 06, 2022, 04:51 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!