I have an assignment to check the statements that are true:
A) A clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk
B) The leaf nodes of a clustered index contain pointers to the data pages
C) A non-clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk
D) In online transaction processing systems, relational database design uses the discipline of data modeling and generally follow the Codd rules of data normalization in order to ensure absolute data integrity.
I've been reading a lot and watching Youtube videos explaining these topics, and I think b and c are true, and a and d are false, but I just want a second opinion. Please, help!
