Is bitcoin core database is supposed to be identical on each computer, if they have all blocks till the most recent block downloaded?
If two databases for users A and B have all blockchain blocks do they have them stored in the same order or different?
For example, if we consider some file blk00100.dat should it be the same file for on each computer where bitcoin core is installed and database is downloaded? Or A may have blocks Nx..Ny on his database whereas B may have Ny..Nz on his computer?
I cannot speak for a bit for bit comparison, but that chain is based on a data chain from block 0 up. A downloaded chain is simply a copy of that original chain. Imagine a checkbook register, each copy still starts with the first transaction and onward, as though it were the original.
Each PC may lay it out a little different within the bit per bit, DD style memory, but those are not just flippant copies of the original block, each is a copy of that chain, perhaps copied over and over, but still a copy.