Hi neonix
... Does both computers have the same static ip adress or dynamic DHCP? ...
All computers must have unique addresses. That's a requirement for Ethernet.
How the computers get their addresses has nothing to do with the hub. The
computers can have static addresses, receive an address via DHCP from
another device connected to the hub, or a combination of both.
... How does this passive ethernet hub works? ...
When one computer talks, the message goes out to all of the computers, not
just the one it was addressed to. The other computers see the message was
not addressed to them, so they ignore it.
If more than one computer tries to talk at the same time, you have a data
collision, and the computers will have to try again after a delay.
... Can I connect 4 computers using only one 8 wire cable?
No. The passive hub contains diodes that are used to connect the computers.