Static means "constant--never changing".
dynamic is "changing". You can make dynamic changes to a database without having to shutdown the instance and restart for the changes to take effect. However, if you do not update the control file, when you shutdown and startup, the dynamic change is gone--it wasn't permanent.
Static sites are meant for those sites that cant be changed or updates regularly.
and Dynamic sites are those sites that changes or update regularly.